C_MstrProjAgeDebt

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 null
TotalNetAmount Master Project Summary Billed Amount
Column Name Description
📏 Sales unit (BillingQuantityUnit):
BillingQuantity Actual billed quantity
Column Name Description
ExchangeRateDate Translation date
Column Name Description
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
SalesOrderItemConcatenatedID Commercial Project Sales Order Item CHAR17
MaterialName Material Description TEXT40
ControllingObjectExternalID Master Project Structure Element CHAR34
ControllingObjectDescription Master Project Structure Element Name TEXT40
CustomerName Name of Customer TEXT80
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • C_MSTRPROJAGEDEBT.MANDT == TVFK.MANDT
  • C_MSTRPROJAGEDEBT.BILLINGDOCUMENTTYPE == TVFK.FKART
Sales unit
  • Client
  • Sales unit
  • C_MSTRPROJAGEDEBT.MANDT == T006.MANDT
  • C_MSTRPROJAGEDEBT.BILLINGQUANTITYUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • C_MSTRPROJAGEDEBT.MANDT == MARA.MANDT
  • C_MSTRPROJAGEDEBT.MATERIAL == MARA.MATNR
Sales organization in order header
  • Client
  • Sales Organization
  • C_MSTRPROJAGEDEBT.MANDT == TVKO.MANDT
  • C_MSTRPROJAGEDEBT.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • C_MSTRPROJAGEDEBT.MANDT == KNA1.MANDT
  • C_MSTRPROJAGEDEBT.SOLDTOPARTY == KNA1.KUNNR
SD Document Currency
  • Client
  • SD Document Currency
  • C_MSTRPROJAGEDEBT.MANDT == TCURC.MANDT
  • C_MSTRPROJAGEDEBT.TRANSACTIONCURRENCY == TCURC.WAERS