I_MstrProjInvoice

Column Name Description
MasterProject Commercial Project ID
BillingDocument FK Commercial Project Invoice Number
SalesDocument FK Sales Document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
ItemNetAmountOfBillingDoc null
ItemGrossAmountOfBillingDoc null
BillDocItemTaxAmt null
TotalNetAmount Master Project Summary Billed Amount
PurchasingDocumentAmount null
Column Name Description
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
SubsequentDocumentCategory Document Category of Subsequent Document Show values
Column Name Description Domain name
SalesDocumentItem Sales Document Item POSNR
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
Billing Type
  • Billing Type
  • Client
  • I_MSTRPROJINVOICE.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_MSTRPROJINVOICE.MANDT == TVFK.MANDT
Sales unit
  • Client
  • Sales unit
  • I_MSTRPROJINVOICE.MANDT == T006.MANDT
  • I_MSTRPROJINVOICE.BILLINGQUANTITYUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • I_MSTRPROJINVOICE.MANDT == MARA.MANDT
  • I_MSTRPROJINVOICE.MATERIAL == MARA.MATNR
Sales organization in order header
  • Client
  • Sales Organization
  • I_MSTRPROJINVOICE.MANDT == TVKO.MANDT
  • I_MSTRPROJINVOICE.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • I_MSTRPROJINVOICE.MANDT == KNA1.MANDT
  • I_MSTRPROJINVOICE.SOLDTOPARTY == KNA1.KUNNR
SD Document Currency
  • Client
  • SD Document Currency
  • I_MSTRPROJINVOICE.MANDT == TCURC.MANDT
  • I_MSTRPROJINVOICE.TRANSACTIONCURRENCY == TCURC.WAERS