C_MstrProjInvoice

Column Name Description
MasterProject Commercial Project ID
BillingDocument FK Commercial Project Invoice Number
SalesDocument FK Sales Document
SalesDocumentItem Commercial Project Sales Order Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
ItemNetAmountOfBillingDoc Net Value of Billing item in Document Currency
ItemGrossAmountOfBillingDoc Master Project Summary Received Amount
TotalNetAmount Master Project Summary Billed Amount
OverdueAmountInDisplayCrcy null
Column Name Description
📏 Sales unit (BillingQuantityUnit):
BillingQuantity Actual billed quantity
Column Name Description
CreationDate Master Project Invoice Creation Date
ExchangeRateDate Translation date
Column Name Description
OverallBillingStatus SD Billing Status Show values
SDDocumentCategory SD Document Category Show values
SubsequentDocumentCategory Document Category of Subsequent Document Show values
Column Name Description Domain name
MasterProjectUUID NodeID /BOBF/CONF_KEY
SalesOrderItem Sales Document Item POSNR
SalesDocumentItemText Short text for sales order item TEXT40
BillingDocumentTypeName Description TEXT40
SalesOrganizationName Sales Organization Description TEXT20
MasterProjectName Project Name /CPD/SHORT_TEXT
MaterialName Material Description TEXT40
SalesOrderItemConcatenatedID Commercial Project Sales Order Item CHAR17
OverallBillingStatusDesc Short Text for Fixed Values DDTEXT
ControllingObjectExternalID Master Project Structure Element CHAR34
ControllingObjectDescription Master Project Structure Element Name TEXT40
CustomerName Name of Customer TEXT80
UserIsInvolved null
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • C_MSTRPROJINVOICE.MANDT == TVFK.MANDT
  • C_MSTRPROJINVOICE.BILLINGDOCUMENTTYPE == TVFK.FKART
Sales unit
  • Client
  • Sales unit
  • C_MSTRPROJINVOICE.MANDT == T006.MANDT
  • C_MSTRPROJINVOICE.BILLINGQUANTITYUNIT == T006.MSEHI
Material Number
  • Material Number
  • Client
  • C_MSTRPROJINVOICE.MATERIAL == MARA.MATNR
  • C_MSTRPROJINVOICE.MANDT == MARA.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_MSTRPROJINVOICE.SALESORGANIZATION == TVKO.VKORG
  • C_MSTRPROJINVOICE.MANDT == TVKO.MANDT
Sold-to Party
  • Client
  • Sold-to Party
  • C_MSTRPROJINVOICE.MANDT == KNA1.MANDT
  • C_MSTRPROJINVOICE.SOLDTOPARTY == KNA1.KUNNR
SD Document Currency
  • SD Document Currency
  • Client
  • C_MSTRPROJINVOICE.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_MSTRPROJINVOICE.MANDT == TCURC.MANDT