I_MstrProjActlStatisticKeyFig

Column Name Description
MasterProjectUUID NodeID
MasterProject Commercial Project ID
Column Name Description
Column Name Description
📏 Unit of Measure: Statistical Key Figure (StstcKeyFigQuantityUnit):
StatisticalKeyFigureQuantity Statistical quantity
PerdStstcKeyFigQty null
StrtToDteStstcKeyFigQty null
Column Name Description
MstrProjCutOffDate Cut-Off Date
FinancialPlanStartDate Start Date
FinancialPlanEndDate End Date
MstrProjPerdStrtDte Period KPI Start Date
MstrProjPerdEndDte Period KPI End Date
DocumentDate Document Date
PostingDate Posting Date
Column Name Description
IsReversalDocument Indicator: Document was reversed Show values
Column Name Description Domain name
MasterProjectName Project Name /CPD/SHORT_TEXT
MasterProjectOrganization Project Organization /CPD/PWS_WS_ORG_UNIT_ID
MasterProjectIsConfidential Commercial Project Is Confidential CHAR1
Project Project definition PS_PSPID
ProjectDescription Project Definition Name TEXT40
ControllingObject null
ControllingObjectExternalID null
ControllingObjectType Master Project: Related Business Object Type /CPD/PWS_WS_MP_REL_OBJ
ObjectName WBS Element Name TEXT40
MstrProjAnchorObjectInternalID External Object Technical Key IAOM_OBJECT_KEY
FinancialPlanUUID NodeID /BOBF/CONF_KEY
FinancialPlanVersUUID NodeID /BOBF/CONF_KEY
FinancialPlanInternalID Plan ID /CPD/PFP_PLAN_ID
FinancialPlanID External ID for Financial Plan
FinancialPlanVersion Plan Version ID /CPD/PFP_VERSION_ID
AccountingDocument Document Number CO_BELNR
PostingPeriod Period PERBL
YearMonth null
StatisticalKeyFigure Statistical key figure STAGR
FiscalYear Fiscal Year GJAHR
PersonnelNumber null
Master Data Relations Join Conditions
Business area
  • Client
  • Business Area
  • I_MSTRPROJACTLSTATISTICKEYFIG.MANDT == TGSB.MANDT
  • I_MSTRPROJACTLSTATISTICKEYFIG.BUSINESSAREA == TGSB.GSBER
Company code
  • Company Code
  • Client
  • I_MSTRPROJACTLSTATISTICKEYFIG.COMPANYCODE == T001.BUKRS
  • I_MSTRPROJACTLSTATISTICKEYFIG.MANDT == T001.MANDT
Controlling area
  • Controlling Area
  • Client
  • I_MSTRPROJACTLSTATISTICKEYFIG.CONTROLLINGAREA == TKA01.KOKRS
  • I_MSTRPROJACTLSTATISTICKEYFIG.MANDT == TKA01.MANDT
Plan Currency
  • Plan Currency
  • Client
  • I_MSTRPROJACTLSTATISTICKEYFIG.FINANCIALPLANCURRENCY == TCURC.WAERS
  • I_MSTRPROJACTLSTATISTICKEYFIG.MANDT == TCURC.MANDT
Plan Type ID
  • Plan Type ID
  • Client
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_MSTRPROJACTLSTATISTICKEYFIG.MANDT == T009.MANDT
  • I_MSTRPROJACTLSTATISTICKEYFIG.MASTERPROJECTFISCALYEARVARIANT == T009.PERIV