C_MasterProjectBillingPlan

Column Name Description
MasterProject Commercial Project ID
BillingPlan Unique ID
BillingPlanItem Item for billing plan/invoice plan/payment cards
SalesDocument Sales Document
SalesOrderItemConcatenatedID Commercial Project Sales Order Item
Column Name Description
💲 null (TransactionCurrency):
NetAmount Master Project Billing Value
Column Name Description
MstrProjResourceQuantity Billing Plan Quantity (Resources)
Column Name Description
BillingDate Billing Date
PostingDate Posting Date (To) for Resource-Related Billing Request
PricingDate Pricing Date (To)
Column Name Description
DocumentStatusName Billing status for the billing plan/invoice plan date Show values
IsBillingCreatedInAdvance Billing/Invoice Creation in Advance Show values
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
SalesOrder Sales Document VBELN
SalesOrderItem Sales Document Order POSNR
SalesDocumentItemText Short text for sales order item TEXT40
SalesDocumentItem null
SalesOrganizationName Sales Organization Description TEXT20
ControllingObjectExternalID Master Project Structure Element CHAR34
ControllingObjectDescription Master Project Structure Element Name TEXT40
MasterProjectName Project Name /CPD/SHORT_TEXT
EventType null
BillingEventTypeName Description of Billing Event Type
BillingPlanBillingDateText Short Description TEXT40
SDDocumentStatus null
DocumentStatusDesc Description of Billing Document Status
Material Material Number MATNR
MaterialName Description of Billing Material
BillingBlockReasonDescription Billing Block Description TEXT20
BillingPlanCategoryName Description of Date Category TEXT30
BillingPlanRuleName Short Text for Fixed Values DDTEXT
CustomerName Name of Customer TEXT80
UserIsInvolved null
Master Data Relations Join Conditions
Order type in order header
  • Client
  • Sales Document Type
  • C_MASTERPROJECTBILLINGPLAN.MANDT == TVAK.MANDT
  • C_MASTERPROJECTBILLINGPLAN.SALESDOCUMENTTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • C_MASTERPROJECTBILLINGPLAN.MANDT == TVKO.MANDT
  • C_MASTERPROJECTBILLINGPLAN.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • C_MASTERPROJECTBILLINGPLAN.SOLDTOPARTY == KNA1.KUNNR
  • C_MASTERPROJECTBILLINGPLAN.MANDT == KNA1.MANDT