I_MPBillingSummary

Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
BillingDocument FK Billing Document
Column Name Description
ItemNetAmountOfBillingDoc null
TotalNetAmount null
PurchasingDocumentAmount null
💲 SD Document Currency (TransactionCurrency):
ItemGrossAmountOfBillingDoc Gross Value of the Billing Item in Document Currency
BillDocItemTaxAmt Tax Amount in Document Currency
Column Name Description
📏 Sales unit (BillingQuantityUnit):
BillingQuantity Actual billed quantity
Column Name Description
BillingDocumentDate Billing Date
CreationDate Master Project Invoice Creation Date
ExchangeRateDate Translation date
Column Name Description
SDDocumentCategory SD Document Category Show values
InvoiceListStatus SD Billing Status Show values
SubsequentDocumentCategory Document Category of Subsequent Document Show values
Column Name Description Domain name
MasterProject Commercial Project ID /CPD/MP_ID
MasterProjectIsConfidential Commercial Project Is Confidential CHAR1
MasterProjectOrganization Project Organization /CPD/PWS_WS_ORG_UNIT_ID
MasterProjectUUID NodeID /BOBF/CONF_KEY
MasterProjectName Project Name /CPD/SHORT_TEXT
ControllingObjectExternalID null
ControllingObjectDescription WBS Element Name TEXT40
UserIsInvolved null
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MPBILLINGSUMMARY.BASEUNIT == T006.MSEHI
  • I_MPBILLINGSUMMARY.MANDT == T006.MANDT
Billing Type
  • Client
  • Billing Type
  • I_MPBILLINGSUMMARY.MANDT == TVFK.MANDT
  • I_MPBILLINGSUMMARY.BILLINGDOCUMENTTYPE == TVFK.FKART
Sales unit
  • Client
  • Sales unit
  • I_MPBILLINGSUMMARY.MANDT == T006.MANDT
  • I_MPBILLINGSUMMARY.BILLINGQUANTITYUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • I_MPBILLINGSUMMARY.MANDT == MARA.MANDT
  • I_MPBILLINGSUMMARY.MATERIAL == MARA.MATNR
Sales organization in order header
  • Client
  • Sales Organization
  • I_MPBILLINGSUMMARY.MANDT == TVKO.MANDT
  • I_MPBILLINGSUMMARY.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • I_MPBILLINGSUMMARY.SOLDTOPARTY == KNA1.KUNNR
  • I_MPBILLINGSUMMARY.MANDT == KNA1.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_MPBILLINGSUMMARY.MANDT == TCURC.MANDT
  • I_MPBILLINGSUMMARY.TRANSACTIONCURRENCY == TCURC.WAERS