I_MstrProjCreditSummary

Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
ItemNetAmountOfBillingDoc null
ItemGrossAmountOfBillingDoc null
TotalNetAmount null
PurchasingDocumentAmount null
Column Name Description
BillingQuantity null
Column Name Description
Column Name Description
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
MasterProject Commercial Project ID /CPD/MP_ID
MasterProjectName Project Name /CPD/SHORT_TEXT
ControllingObjectExternalID null
ControllingObjectDescription WBS Element Name TEXT40
UserIsInvolved null
AddressID Address ADRNR
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Billing Type
  • Client
  • Billing Type
  • I_MSTRPROJCREDITSUMMARY.MANDT == TVFK.MANDT
  • I_MSTRPROJCREDITSUMMARY.BILLINGDOCUMENTTYPE == TVFK.FKART
Sales unit
  • Client
  • Sales unit
  • I_MSTRPROJCREDITSUMMARY.MANDT == T006.MANDT
  • I_MSTRPROJCREDITSUMMARY.BILLINGQUANTITYUNIT == T006.MSEHI
Customer Account Group
  • Client
  • Customer Account Group
  • I_MSTRPROJCREDITSUMMARY.MANDT == T077D.MANDT
  • I_MSTRPROJCREDITSUMMARY.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Material: order item
  • Client
  • Material Number
  • I_MSTRPROJCREDITSUMMARY.MANDT == MARA.MANDT
  • I_MSTRPROJCREDITSUMMARY.MATERIAL == MARA.MATNR
Key of person
  • Client
  • ?
  • ?
  • Person Number
  • I_MSTRPROJCREDITSUMMARY.MANDT == ADRP.CLIENT
  • I_MSTRPROJCREDITSUMMARY.[column in domain "AD_NATION"] == ADRP.NATION
  • I_MSTRPROJCREDITSUMMARY.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_MSTRPROJCREDITSUMMARY.PERSON == ADRP.PERSNUMBER
Sales organization in order header
  • Client
  • Sales Organization
  • I_MSTRPROJCREDITSUMMARY.MANDT == TVKO.MANDT
  • I_MSTRPROJCREDITSUMMARY.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • I_MSTRPROJCREDITSUMMARY.MANDT == KNA1.MANDT
  • I_MSTRPROJCREDITSUMMARY.SOLDTOPARTY == KNA1.KUNNR
SD Document Currency
  • Client
  • SD Document Currency
  • I_MSTRPROJCREDITSUMMARY.MANDT == TCURC.MANDT
  • I_MSTRPROJCREDITSUMMARY.TRANSACTIONCURRENCY == TCURC.WAERS