I_MstrProjStructureElement

Column Name Description
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
MasterProjectUUID NodeID /BOBF/CONF_KEY
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
CreatedByUser Created By XUBNAME
CreationDateTime Created On DEC15
LastChangedByUser Changed By XUBNAME
LastChangeDateTime Commercial Project Last Changed On DEC15
Project Project definition PS_PSPID
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
WBSElementInternalID WBS Element PS_S4_PSPNR
ControllingObjectInternalID null
Master Data Relations Join Conditions
Business area
  • Client
  • Business Area
  • I_MSTRPROJSTRUCTUREELEMENT.MANDT == TGSB.MANDT
  • I_MSTRPROJSTRUCTUREELEMENT.BUSINESSAREA == TGSB.GSBER
Company code
  • Client
  • Company Code
  • I_MSTRPROJSTRUCTUREELEMENT.MANDT == T001.MANDT
  • I_MSTRPROJSTRUCTUREELEMENT.COMPANYCODE == T001.BUKRS
Controlling area
  • Client
  • Controlling Area
  • I_MSTRPROJSTRUCTUREELEMENT.MANDT == TKA01.MANDT
  • I_MSTRPROJSTRUCTUREELEMENT.CONTROLLINGAREA == TKA01.KOKRS
Project currency
  • Client
  • WBS currency (project definition)
  • I_MSTRPROJSTRUCTUREELEMENT.MANDT == TCURC.MANDT
  • I_MSTRPROJSTRUCTUREELEMENT.CONTROLLINGAREACURRENCY == TCURC.WAERS