P_MstrProjHierCommitment

Column Name Description
MasterProjectUUID NodeID
MasterProject Commercial Project ID
ControllingObject null
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CmtmtCostInTransacCrcy Total Value in Transaction Currency
CmtmtCostInCCCrcy Total Value in Local Currency
CmtmtCostInGlobalCurrency Total Value in Controlling Area Currency
CmtmtCostInObjCrcy Total Value in Object Currency
CmtmtCostInPlnCrcy null
CmtmtCostInProjCrcy null
Column Name Description
📏 Unit of Measure (UnitOfMeasure):
MstrProjCmtmtOpnQty Total Quantity
📏 Posted Unit of Measure (BaseUnit):
MstrProjCmtmtOpnBaseQty Total quantity entered
Column Name Description
MstrProjPerdStrtDte Period KPI Start Date
MstrProjPerdEndDte Period KPI End Date
MstrProjCutOffDate Cut-Off Date
RequirementDate Expected Debit Date
DocumentDate Document Date
Column Name Description
ControllingValueType Value Type Show values
Column Name Description Domain name
MasterProjectName Project Name /CPD/SHORT_TEXT
MasterProjectIsConfidential Commercial Project Is Confidential CHAR1
MasterProjectOrganization Project Organization /CPD/PWS_WS_ORG_UNIT_ID
Project Project definition PS_PSPID
ProjectDescription Project Definition Name TEXT40
MstrProjAnchorObjectInternalID External Object Technical Key IAOM_OBJECT_KEY
ControllingObjectExternalID null
ControllingObjectType Master Project: Related Business Object Type /CPD/PWS_WS_MP_REL_OBJ
FinancialPlanID External ID for Financial Plan
FinancialPlanInternalID Plan ID /CPD/PFP_PLAN_ID
StatisticalKeyFigure null
CostElement Cost element SAKNR
FiscalYear Fiscal Year GJAHR
RefPurDocNmbr Reference Document Number BELNR
YearMonth null
Master Data Relations Join Conditions
Unit of measure
  • Posted Unit of Measure
  • Client
  • P_MSTRPROJHIERCOMMITMENT.BASEUNIT == T006.MSEHI
  • P_MSTRPROJHIERCOMMITMENT.MANDT == T006.MANDT
Company code
  • Company Code
  • Client
  • P_MSTRPROJHIERCOMMITMENT.COMPANYCODE == T001.BUKRS
  • P_MSTRPROJHIERCOMMITMENT.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Controlling Area Currency
  • Client
  • P_MSTRPROJHIERCOMMITMENT.COMPANYCODECURRENCY == TCURC.WAERS
  • P_MSTRPROJHIERCOMMITMENT.GLOBALCURRENCY == TCURC.WAERS
  • P_MSTRPROJHIERCOMMITMENT.MANDT == TCURC.MANDT
Controlling area
  • Controlling Area
  • Client
  • P_MSTRPROJHIERCOMMITMENT.CONTROLLINGAREA == TKA01.KOKRS
  • P_MSTRPROJHIERCOMMITMENT.MANDT == TKA01.MANDT
WBS element currency
  • Client
  • WBS element currency
  • P_MSTRPROJHIERCOMMITMENT.MANDT == TCURC.MANDT
  • P_MSTRPROJHIERCOMMITMENT.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Plan Currency
  • Plan Currency
  • Client
  • P_MSTRPROJHIERCOMMITMENT.FINANCIALPLANCURRENCY == TCURC.WAERS
  • P_MSTRPROJHIERCOMMITMENT.MANDT == TCURC.MANDT
Controlling Area Currency
  • Currency Key
  • Controlling Area Currency
  • Client
  • P_MSTRPROJHIERCOMMITMENT.COMPANYCODECURRENCY == TCURC.WAERS
  • P_MSTRPROJHIERCOMMITMENT.GLOBALCURRENCY == TCURC.WAERS
  • P_MSTRPROJHIERCOMMITMENT.MANDT == TCURC.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_MSTRPROJHIERCOMMITMENT.MASTERPROJECTFISCALYEARVARIANT == T009.PERIV
  • P_MSTRPROJHIERCOMMITMENT.MANDT == T009.MANDT
Material
  • Material Number
  • Client
  • P_MSTRPROJHIERCOMMITMENT.MATERIAL == MARA.MATNR
  • P_MSTRPROJHIERCOMMITMENT.MANDT == MARA.MANDT
Check for existence in table T006
  • Client
  • Unit for Statistical Key Figure
  • P_MSTRPROJHIERCOMMITMENT.MANDT == T006.MANDT
  • P_MSTRPROJHIERCOMMITMENT.STSTCKEYFIGQUANTITYUNIT == T006.MSEHI
Transaction currency
  • Client
  • Transaction Currency
  • P_MSTRPROJHIERCOMMITMENT.MANDT == TCURC.MANDT
  • P_MSTRPROJHIERCOMMITMENT.TRANSACTIONCURRENCY == TCURC.WAERS
Unit of measure
  • Unit of Measure
  • Client
  • P_MSTRPROJHIERCOMMITMENT.UNITOFMEASURE == T006.MSEHI
  • P_MSTRPROJHIERCOMMITMENT.MANDT == T006.MANDT