P_MstrProjHierSales

Column Name Description
MasterProjectUUID NodeID
Column Name Description
Column Name Description
Column Name Description
StartDate Commercial Project: Start Date
EndDate Commercial Project: End Date
Column Name Description
WorkType Type of Work Show values
Industry Industry Show values
FinancialRisk Financial Risk Show values
TechnicalRisk Technical Risk Show values
OverallRisk Overall Project Risk Show values
Column Name Description Domain name
MasterProject Commercial Project ID /CPD/MP_ID
MasterProjectName Project Name /CPD/SHORT_TEXT
MasterProjectOrganization Project Organization /CPD/PWS_WS_ORG_UNIT_ID
MasterProjectIsConfidential Commercial Project Is Confidential CHAR1
Country Country/Region LAND1
Region Region (State, Province, County) REGIO
ProjectRisk Commercial Project Risk CHAR1
MasterProjectItemUUID NodeID /BOBF/CONF_KEY
MasterProjectItem Item Key (Master Project) /CPD/MP_ITM_OKEY
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementInternalID WBS Element PS_S4_PSPNR
ControllingObjectInternalID null
ExternalId null
SalesDocumentItem Sales Document Item POSNR
Master Data Relations Join Conditions
Business area
  • Client
  • Business Area
  • P_MSTRPROJHIERSALES.MANDT == TGSB.MANDT
  • P_MSTRPROJHIERSALES.BUSINESSAREA == TGSB.GSBER
Company code
  • Client
  • Company Code
  • P_MSTRPROJHIERSALES.MANDT == T001.MANDT
  • P_MSTRPROJHIERSALES.COMPANYCODE == T001.BUKRS
Controlling area
  • Controlling Area
  • Client
  • P_MSTRPROJHIERSALES.CONTROLLINGAREA == TKA01.KOKRS
  • P_MSTRPROJHIERSALES.MANDT == TKA01.MANDT
Project currency
  • WBS currency (project definition)
  • Client
  • P_MSTRPROJHIERSALES.CONTROLLINGAREACURRENCY == TCURC.WAERS
  • P_MSTRPROJHIERSALES.MANDT == TCURC.MANDT