I_EngmtProjPlanReviewCube

Column Name Description
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
💲 Plan Currency (Currency):
ActlCostAmt Actual Cost
PlndCostAmt Planned Cost
PlndRevnAmt Planned Revenue
ActualPlanDeviationCost Cost Deviation
Column Name Description
📏 Base Unit of Measure (UnitOfMeasure):
ActlEffortQty Actual Effort
AddlResourceActualQuantity Actual Effort
PlndEffortQty Planned Effort
AddlResourcePlannedQuantity Planned Effort
ActualPlanDeviationEffort Effort Deviation
Column Name Description
ProjectStartDate Commercial Project: Start Date
ProjectEndDate Commercial Project: End Date
Column Name Description
EngagementProjectCategory Project Type Show values
EngmntProjPlanLineType Line type Show values
Column Name Description Domain name
EngagementProject Project /CPD/MP_ID
EngagementProjectName Customer Project Name /CPD/SHORT_TEXT
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
SalesOrder Item Key (Master Project) /CPD/MP_ITM_OKEY
ProjectLastChangedDateTime Changed On /CPD/SC_CHANGEDON
EngagementProjFinPlanUUID Financial Plan UUID /BOBF/CONF_KEY
EngmntProjReviewYearPeriod Review Year Period /CPD/FISCAL_YEAR_PERIOD
EngagementProjectReviewStatus Forecast Status ID /CPD/PFP_FORECAST_ST_ID
EngmntProjReviewYear Review Year GJAHR
EngmntProjReviewPeriod Review Period POPER
EngmtProjFinPlanVersion Plan Version ID /CPD/PFP_VERSION_ID
EngmtProjFinPlanVersionType Version Type ID /CPD/PFP_VER_TYPE_ID
EngagementProjectStatus Status Key /CPD/PWS_WS_STATUS_KEY_FIG
LastChangeDateTime Created On DEC15
CustomerName Name of Customer TEXT80
CityName City TEXT40
WorkPackage Work Package /CPD/PLAN_ITEM_ID
WorkItem Work Item /CPD/PFP_WORKITEM_ID
EngagementProjectResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
EngagementProjectResource Role / Expense /CPD/PFP_RESOURCE_ID
ProjectManager null
FiscalPeriod Period PERBL
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Review Year Period /CPD/FISCAL_YEAR_PERIOD
EngmntProjectDeliveryOrg null
UnitCompltnRateInPercent Completion Rate Percent /CPD/SC_COMPLETIONRATE
ResourceIsOfUnitWorkPackage null
IsUnitBased null
IsMyProject null
Master Data Relations Join Conditions
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_ENGMTPROJPLANREVIEWCUBE.MANDT == T009.MANDT
  • I_ENGMTPROJPLANREVIEWCUBE.FISCALYEARVARIANT == T009.PERIV
Currency in order header
  • Client
  • SD Document Currency
  • I_ENGMTPROJPLANREVIEWCUBE.MANDT == TCURC.MANDT
  • I_ENGMTPROJPLANREVIEWCUBE.TRANSACTIONCURRENCY == TCURC.WAERS