I_MstrProjInvoiceCube

Column Name Description
MasterProject Commercial Project ID
BillingDocument FK Commercial Project Invoice Number
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Master Project Summary Billed Amount
ItemGrossAmountOfBillingDoc Master Project Summary Received Amount
OverdueAmountInDisplayCrcy Master Project Invoice Amount Due
Column Name Description
📏 Sales unit (BillingQuantityUnit):
BillingQuantity null
Column Name Description
CreationDate Master Project Invoice Creation Date
ExchangeRateDate Translation date
BillingDocumentDate Billing Date
Column Name Description
InvoiceListStatus SD Billing Status Show values
Column Name Description Domain name
MasterProjectName Project Name /CPD/SHORT_TEXT
ControllingObjectExternalID Master Project Structure Element CHAR34
MaterialName Material Description TEXT40
CustomerName Name of Customer TEXT80
InvoiceListStatusDesc Status Description TEXT20
Master Data Relations Join Conditions
Sales unit
  • Sales unit
  • Client
  • I_MSTRPROJINVOICECUBE.BILLINGQUANTITYUNIT == T006.MSEHI
  • I_MSTRPROJINVOICECUBE.MANDT == T006.MANDT
Material Number
  • Material Number
  • Client
  • I_MSTRPROJINVOICECUBE.MATERIAL == MARA.MATNR
  • I_MSTRPROJINVOICECUBE.MANDT == MARA.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_MSTRPROJINVOICECUBE.SOLDTOPARTY == KNA1.KUNNR
  • I_MSTRPROJINVOICECUBE.MANDT == KNA1.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • I_MSTRPROJINVOICECUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_MSTRPROJINVOICECUBE.MANDT == TCURC.MANDT