I_MasterProjectBillingPlanCube

Column Name Description
MasterProject Commercial Project ID
BillingPlan Unique ID
SalesDocument Sales Document
SalesDocumentItem Sales Document Order
Column Name Description
💲 null (TransactionCurrency):
NetAmount Master Project Billing Value
Column Name Description
📏 Unit of Measurement (UnitOfMeasure):
MstrProjResourceQuantity null
Column Name Description
BillingDate Billing Date
Column Name Description
IsBillingCreatedInAdvance Billing/Invoice Creation in Advance Show values
Column Name Description Domain name
MasterProjectName Project Name /CPD/SHORT_TEXT
ControllingObjectExternalID null
EventType null
BillingEventTypeName null
BillingPlanBillingDateText Short Description TEXT40
SDDocumentStatus null
DocumentStatusDesc Short Text for Fixed Values DDTEXT
Material Material Number MATNR
MaterialName Material Description TEXT40
BillingBlockReasonDescription Billing Block Description TEXT20
BillingPlanCategoryName Description of Date Category TEXT30
BillingPlanRuleName Short Text for Fixed Values DDTEXT
CustomerName Name of Customer TEXT80
Master Data Relations Join Conditions
Order type in order header
  • Sales Document Type
  • Client
  • I_MASTERPROJECTBILLINGPLANCUBE.SALESDOCUMENTTYPE == TVAK.AUART
  • I_MASTERPROJECTBILLINGPLANCUBE.MANDT == TVAK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • I_MASTERPROJECTBILLINGPLANCUBE.MANDT == TVKO.MANDT
  • I_MASTERPROJECTBILLINGPLANCUBE.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • I_MASTERPROJECTBILLINGPLANCUBE.MANDT == KNA1.MANDT
  • I_MASTERPROJECTBILLINGPLANCUBE.SOLDTOPARTY == KNA1.KUNNR