P_MstrProjStructElmntActuals

Column Name Description
MasterProjectUUID NodeID
MasterProject Commercial Project ID
Column Name Description
StrtToDteActlCostInProjCrcy Amount in Company Code Currency
StrtToDteActlCostInPlnCrcy Amount in Company Code Currency
StrtToDteActlCostInCOCrcy Amount in Company Code Currency
StrtToDteActlCostInCCCrcy Amount in Company Code Currency
StrtToDteActlCostInObjCrcy Amount in Company Code Currency
StrtToDteActlCostInTC Amount in Company Code Currency
StrtToDteActlRevnInProjCrcy Amount in Company Code Currency
StrtToDteActlRevnInCOCrcy Amount in Company Code Currency
StrtToDteActlRevnInCCCrcy Amount in Company Code Currency
StrtToDteActlRevnInPlnCrcy Amount in Company Code Currency
StrtToDteActlRevnInObjCrcy Amount in Company Code Currency
StrtToDteActlRevnInTC Amount in Company Code Currency
StrtToDteStstcKeyFigQty Amount in Company Code Currency
StrtToDteActualQuantity Amount in Company Code Currency
ActlCostInProjCrcy Amount in Company Code Currency
ActlCostInPlnCrcy Amount in Company Code Currency
ActlCostInCoCodeCrcy Amount in Company Code Currency
ActualCostInObjectCrcy Amount in Company Code Currency
ActualCostInTransCrcy Amount in Company Code Currency
ActualCostAmount Amount in Company Code Currency
StatisticalKeyFigureQuantity Amount in Company Code Currency
ActlRevnInProjCrcy Amount in Company Code Currency
ActualRevenueInPlnCrcy Amount in Company Code Currency
ActlRevnInCoCodeCrcy Amount in Company Code Currency
ActualRevenueInObjectCrcy Amount in Company Code Currency
ActualRevenueInTransCrcy Amount in Company Code Currency
ActualRevenueAmount Amount in Company Code Currency
Quantity Amount in Company Code Currency
PerdActualQuantity Amount in Company Code Currency
PerdStstcKeyFigQty Amount in Company Code Currency
PerdActlCostInProjCrcy Amount in Company Code Currency
CmtmtCostInCOCrcy Amount in Company Code Currency
CmtmtCostInPlnCrcy Amount in Company Code Currency
CmtmtCostInObjCrcy Amount in Company Code Currency
CmtmtCostInTransacCrcy Amount in Company Code Currency
CmtmtCostInProjCrcy Amount in Company Code Currency
TotActlCostInProjCrcy null
Column Name Description
Column Name Description
DocumentDate Document Date in Document
PostingDate Document Date in Document
Column Name Description
MasterProjectIsConfidential Confidential Indicator for Commercial Project Show values
ControllingObjectDebitType Debit Type Show values
Column Name Description Domain name
MasterProjectType Commercial Project Type /CPD/PWS_WS_MP_TYPE
MasterProjectOrganization Service Organization /CPD/PWS_WS_ORG_UNIT_ID
YearMonth null
ControllingObject null
FinancialPlanID External ID for Financial Plan
FinancialPlanInternalID Plan ID /CPD/PFP_PLAN_ID
MstrProjKeyFigElmnt Key Figure Element /CPD/AVR_ELEM
MstrProjResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
MstrProjRsceID Resource ID /CPD/PFP_RESOURCE_ID
CompanyCode Company Code BUKRS
GLAccount G/L Account Number SAKNR
StatisticalKeyFigure null
AccountingDocument Document Number CO_BELNR
IsReversed null
PersonnelNumber Personnel Number PERNR
Plant Plant WERKS
Material Material Number MATNR
Master Data Relations Join Conditions
Check for existence in table T006
  • Unit for Statistical Key Figure
  • Client
  • P_MSTRPROJSTRUCTELMNTACTUALS.BASEUNIT == T006.MSEHI
  • P_MSTRPROJSTRUCTELMNTACTUALS.MANDT == T006.MANDT
Controlling Area
  • Client
  • Controlling Area
  • P_MSTRPROJSTRUCTELMNTACTUALS.MANDT == TKA01.MANDT
  • P_MSTRPROJSTRUCTELMNTACTUALS.CONTROLLINGAREA == TKA01.KOKRS
Plan Currency
  • Plan Currency
  • Client
  • P_MSTRPROJSTRUCTELMNTACTUALS.FINANCIALPLANCURRENCY == TCURC.WAERS
  • P_MSTRPROJSTRUCTELMNTACTUALS.MANDT == TCURC.MANDT