I_BillingPlanSDData

Billing Plan SD Data | view: IBPSD | Extraction: Not supported | Component: Commercial Project Management - Project Workspace
Tables used: FPLAFPLTVBKD
Column Name Description
Column Name Description
💲 Currency Key (TransactionCurrency):
NetAmount Value to be billed/calc. on date in billing/invoice plan
Column Name Description
Column Name Description
BillingDate Billing Date
Column Name Description
BillingPlanRule Rule in billing plan/invoice plan Show values
SDDocumentStatus Billing status for the billing plan/invoice plan date Show values
IsBillingCreatedInAdvance Billing/Invoice Creation in Advance Show values
Column Name Description Domain name
BillingPlan Billing plan number / invoicing plan number FPLNR
BillingPlanItem Item for billing plan/invoice plan/payment cards FPLTR
SalesDocument Sales and Distribution Document Number VBELN
SalesDocumentItem Item number of the SD document POSNR
EventType null
Master Data Relations Join Conditions
Billing block for billing plan/invoice plan dates
  • Billing block for billing plan/invoice plan dates
  • Client
  • I_BILLINGPLANSDDATA.BILLINGBLOCKREASON == TVFS.FAKSP
  • I_BILLINGPLANSDDATA.MANDT == TVFS.MANDT
Date Description
  • Date Description
  • Client
  • I_BILLINGPLANSDDATA.BILLINGPLANBILLINGDATERULE == TVTB.TETBE
  • I_BILLINGPLANSDDATA.MANDT == TVTB.MANDT
Date category
  • Billing/Invoicing Plan Type
  • Date category
  • Client
  • I_BILLINGPLANSDDATA.BILLINGPLANTYPE == TFPLT.FPART
  • I_BILLINGPLANSDDATA.BILLINGPLANCATEGORY == TFPLT.FPTTP
  • I_BILLINGPLANSDDATA.MANDT == TFPLT.MANDT
Billing/Invoicing Plan Type
  • Billing/Invoicing Plan Type
  • Client
  • I_BILLINGPLANSDDATA.BILLINGPLANTYPE == TFPLA.FPART
  • I_BILLINGPLANSDDATA.MANDT == TFPLA.MANDT
Currency Key
  • Client
  • Currency Key
  • I_BILLINGPLANSDDATA.MANDT == TCURC.MANDT
  • I_BILLINGPLANSDDATA.TRANSACTIONCURRENCY == TCURC.WAERS
Usage
  • Usage
  • Client
  • I_BILLINGPLANSDDATA.USAGECODE == T433.MLSTN
  • I_BILLINGPLANSDDATA.MANDT == T433.MANDT