C_MPBillnRecvSummary

Column Name Description
MasterProject Commercial Project ID
SalesDocument null
SalesDocumentItem null
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
TotalNetAmount Master Project Summary Billed Amount
ItemNetAmountOfBillingDoc Master Project Summary Received Amount
ItemGrossAmountOfBillingDoc Master Project Summary Received Amount
OverdueAmountInDisplayCrcy null
Column Name Description
Column Name Description
Column Name Description
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
SalesOrderItem Sales Document Item POSNR
SalesDocumentItemText Short text for sales order item TEXT40
MasterProjectName Project Name /CPD/SHORT_TEXT
BillingDocumentTypeName Description TEXT40
SalesOrganizationName Sales Organization Description TEXT20
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 Customer TEXT80
AddressID Address ADRNR
EmailAddress E-Mail Address AD_SMTPADR
MobilePhoneNumber Cell (Customer) CHAR30
PhoneNumber Landline (Customer) CHAR40
UserIsInvolved null
Master Data Relations Join Conditions
Billing Type
  • Billing Type
  • Client
  • C_MPBILLNRECVSUMMARY.BILLINGDOCUMENTTYPE == TVFK.FKART
  • C_MPBILLNRECVSUMMARY.MANDT == TVFK.MANDT
Material: order item
  • Client
  • Material Number
  • C_MPBILLNRECVSUMMARY.MANDT == MARA.MANDT
  • C_MPBILLNRECVSUMMARY.MATERIAL == MARA.MATNR
Key of person
  • ?
  • Client
  • ?
  • Person Number
  • C_MPBILLNRECVSUMMARY.[column in domain "AD_NATION"] == ADRP.NATION
  • C_MPBILLNRECVSUMMARY.MANDT == ADRP.CLIENT
  • C_MPBILLNRECVSUMMARY.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • C_MPBILLNRECVSUMMARY.PERSON == ADRP.PERSNUMBER
Sales organization in order header
  • Sales Organization
  • Client
  • C_MPBILLNRECVSUMMARY.SALESORGANIZATION == TVKO.VKORG
  • C_MPBILLNRECVSUMMARY.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_MPBILLNRECVSUMMARY.SOLDTOPARTY == KNA1.KUNNR
  • C_MPBILLNRECVSUMMARY.MANDT == KNA1.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_MPBILLNRECVSUMMARY.MANDT == TCURC.MANDT
  • C_MPBILLNRECVSUMMARY.TRANSACTIONCURRENCY == TCURC.WAERS