I_MstrProjSummary

Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
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
  • Billing Type
  • Client
  • I_MSTRPROJSUMMARY.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_MSTRPROJSUMMARY.MANDT == TVFK.MANDT
Sales unit
  • Sales unit
  • Client
  • I_MSTRPROJSUMMARY.BILLINGQUANTITYUNIT == T006.MSEHI
  • I_MSTRPROJSUMMARY.MANDT == T006.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • I_MSTRPROJSUMMARY.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • I_MSTRPROJSUMMARY.MANDT == T077D.MANDT
Material: order item
  • Material Number
  • Client
  • I_MSTRPROJSUMMARY.MATERIAL == MARA.MATNR
  • I_MSTRPROJSUMMARY.MANDT == MARA.MANDT
Key of person
  • Client
  • ?
  • ?
  • Person Number
  • I_MSTRPROJSUMMARY.MANDT == ADRP.CLIENT
  • I_MSTRPROJSUMMARY.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_MSTRPROJSUMMARY.[column in domain "AD_NATION"] == ADRP.NATION
  • I_MSTRPROJSUMMARY.PERSON == ADRP.PERSNUMBER
Sales organization in order header
  • Sales Organization
  • Client
  • I_MSTRPROJSUMMARY.SALESORGANIZATION == TVKO.VKORG
  • I_MSTRPROJSUMMARY.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_MSTRPROJSUMMARY.SOLDTOPARTY == KNA1.KUNNR
  • I_MSTRPROJSUMMARY.MANDT == KNA1.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • I_MSTRPROJSUMMARY.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_MSTRPROJSUMMARY.MANDT == TCURC.MANDT