C_MstrProjAgeDebtCurrency

Column Name Description
MasterProject Commercial Project ID
BillingDocument FK Commercial Project Invoice Number
SalesDocument null
SalesDocumentItem null
Column Name Description
💲 SD Document Currency (TransactionCurrency):
ItemNetAmountOfBillingDoc null
TotalNetAmount null
Column Name Description
📏 Sales unit (BillingQuantityUnit):
BillingQuantity null
Column Name Description
ExchangeRateDate Translation date
Column Name Description
Column Name Description Domain name
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
  • Billing Type
  • Client
  • C_MSTRPROJAGEDEBTCURRENCY.BILLINGDOCUMENTTYPE == TVFK.FKART
  • C_MSTRPROJAGEDEBTCURRENCY.MANDT == TVFK.MANDT
Sales unit
  • Sales unit
  • Client
  • C_MSTRPROJAGEDEBTCURRENCY.BILLINGQUANTITYUNIT == T006.MSEHI
  • C_MSTRPROJAGEDEBTCURRENCY.MANDT == T006.MANDT
Material Number
  • Material Number
  • Client
  • C_MSTRPROJAGEDEBTCURRENCY.MATERIAL == MARA.MATNR
  • C_MSTRPROJAGEDEBTCURRENCY.MANDT == MARA.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • C_MSTRPROJAGEDEBTCURRENCY.MANDT == TVKO.MANDT
  • C_MSTRPROJAGEDEBTCURRENCY.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • C_MSTRPROJAGEDEBTCURRENCY.SOLDTOPARTY == KNA1.KUNNR
  • C_MSTRPROJAGEDEBTCURRENCY.MANDT == KNA1.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • C_MSTRPROJAGEDEBTCURRENCY.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_MSTRPROJAGEDEBTCURRENCY.MANDT == TCURC.MANDT