I_EngmntProjectReviewDataCube

Column Name Description
Column Name Description
💲 Plan Currency (Currency):
TotalNetAmount Net Value of the Order Item in Document Currency
ActlCostAmt Actual Cost
ActualCostUpToCurPerd null
ActlCostAmtUpToRevPerd null
ActualCostUpToFsclYrPerd null
ActualExpenseCost null
ActlExpCostUpToCurPerd null
ActlExpenseCostUpToRevPerd null
ActlExpenseCostUpToFsclYrPerd null
PlndCostAmt Planned Cost
ActualPlanDeviationCost Cost Deviation
PlannedCostUpToFsclYrPerd null
PlannedEffortCostAmt null
PlannedCostUpToCurPerd null
AddlResourcePlannedCostAmount null
PlndCostAmtUpToRevPerd null
PlndRevnAmt Planned Revenue
PlndRevnAmtUpToRevPerd null
PlannedRevnUpToCurPerd null
PlannedRevnUpToFsclYrPerd null
PlannedExpenseCost null
PlndExpenseCostUpToRevPerd null
PlndExpCostUpToCurPerd null
PlndExpenseCostUpToFsclYrPerd null
ActualPlanDeviationExpnCost null
BaselinePlndCostAmt null
BaselinePlndRevnAmt null
AdjustedRemainingExpnCost null
AdjustedRemainingEffortCost Actual Cost
AdjustedRemainingCostPlnAmt Actual Cost
AddlRsceEstToCmpltCostAmount Actual Cost
EstToCmpltCostUpToCurPerd Actual Cost
EstToCmpltCostUpToRevPerd Actual Cost
EstToCmpltUpToFsclPerdAmt Actual Cost
AddlRsceEtcCostUpToRevPerdAmt Actual Cost
AddlRsceEtcCostUpToCurPerdAmt Actual Cost
AddlRsceEstToCmpltUpToFsclAmt Actual Cost
EstToCmpltEffCostUpToCurPerd Actual Cost
EstToCmpltEffCostUpToRevPerd Actual Cost
EstToCmpltEffUpToFsclPerdAmt Actual Cost
EstToCmpltExpnCostUpToCurPerd null
EstToCmpltExpnCostUpToRevPerd null
EstToCmpltExpnUpToFsclPerdAmt null
EstimateAtCompletionCost Actual Cost
EstAtCompltnCostUpToCurPerd Actual Cost
EstAtCompltnCostUpToRevPerd Actual Cost
EstAtCompltnUpToFsclPerdAmt Actual Cost
EstimateAtCompletionExpnCost Actual Cost
EstAtCmpltExpnUpToFsclPerdAmt Actual Cost
EstAtCmpltExpnUpToCurPerdAmt Actual Cost
EstAtCmpltExpnUpToRevPerdAmt Actual Cost
DerivedEstAtCompltnCostUpToCur Actual Cost
DerivedEstAtCompltnCostUpToRev Actual Cost
DerivdEstAtCompltnUpToFsclAmt Actual Cost
Column Name Description
📏 Cost Source Unit (UnitOfMeasure):
ActlEffortQty Actual Effort
ActualEffortUpToFsclYrPerd null
ActualEffortUpToCurPerd null
ActlEffortQtyUpToRevPerd null
AddlResourceActualQuantity null
AddlRsceUpToCurPerdActlQty null
AddlRsceUpToRevPerdActlQty null
AddlRsceUpToFsclPerdActlQty null
SupplyEffortQty null
PlndEffortQty Planned Effort
PlndEffortQtyUpToRevPerd null
PlndEffortUpToCurPerd null
PlndEffortUpToFsclYrPerd null
ActualPlanDeviationEffort Effort Deviation
AddlResourcePlannedQuantity null
AddlRsceActlPlanDeviationQty null
BaselinePlndEffortQty null
AdjustedRemainingEffort null
AddlRsceEstToCmpltQty null
AddlRsceEtcUpToCurPerdQty null
AddlRsceEtcUpToRevPerdQty null
AddlRsceEstToCmpltUpToFsclQty null
EstToCmpltEffortUpToRevPerd null
EstToCmpltEffortUpToCurPerd null
EstToCmpltUpToFsclPerdQty null
EstAtCmpltEffortUpToCurPerdQty null
EstAtCmpltEffortUpToRevPerdQty null
EstAtCmpltUpToFsclPerdQty null
EstimateAtCompletionEffort null
AddlRsceEstAtCompltnQty null
📏 Unit of Measure (WorkPackageUnitUoM):
ActualUnitQty null
ActlUnitUpToFsclPerdQty null
PlanUnitQuantity null
BaselinePlannedQuantity null
Column Name Description
ProjectStartDate Commercial Project: Start Date
ProjectEndDate Commercial Project: End Date
WorkPackageStartDate Start Date
WorkPackageEndDate End Date
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
EngagementProjectCategory Project Type Show values
WorkPackageType Work Package Type Show values
IsDeleted Boolean Variable (X = True, - = False, Space = Unknown) Show values
ProjectVisibility Confidential Indicator for Commercial Project Show values
Column Name Description Domain name
EngagementProject Project /CPD/MP_ID
EngagementProjectName Customer Project Name /CPD/SHORT_TEXT
EngagementProjectType Engagement Project Type /CPD/PWS_WS_MP_TYPE
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
CityName City TEXT40
ProjectLastChangedDateTime Changed On /CPD/SC_CHANGEDON
EngagementProjectStage Commercial Project: Stage /CPD/PWS_WS_MP_STG
EngagementProjectStatus Status Key /CPD/PWS_WS_STATUS_KEY_FIG
LastChangeDateTime Created On DEC15
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
EngagementProjFinPlanUUID Financial Plan UUID /BOBF/CONF_KEY
EngmtProjFinPlanVersion null
EngmntProjReviewYearPeriod Review Year Period /CPD/FISCAL_YEAR_PERIOD
EngmntProjReviewYear Review Year GJAHR
EngmntProjReviewPeriod Review Period POPER
EngagementProjectReviewStatus Forecast Status ID /CPD/PFP_FORECAST_ST_ID
SalesOrder Sales Document VBELN
SalesOrderItem Sales Document Item POSNR
SalesOrderItemText Short text for sales order item TEXT40
WorkPackage Work Package /CPD/PLAN_ITEM_ID
WorkItem Work Item /CPD/PFP_WORKITEM_ID
WorkPackageName Plan Item Description /CPD/PLAN_ITEM_NAME
WBSElementIsBillingElement null
WorkPackageUnit Resource ID /CPD/PFP_RESOURCE_ID
WorkPackageUnitText Resource Description /CPD/PFP_DESCRIPTION
EngagementProjectResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
EngagementProjectResource Role / Expense /CPD/PFP_RESOURCE_ID
EngmntProjectDeliveryOrg null
IsUnitBased null
ResourceIsOfUnitWorkPackage null
PlannedCostRate null
IsMyProject null
ProjectManager null
ProjectManagerName null
ProjectManagerExternalID null
ProjectAccountant null
ProjectAccountantName null
ProjectAccountantExternalID null
ProjectController null
ProjectControllerName null
ProjectControllerExternalID null
ProjectPartner null
ProjectPartnerName null
ProjectPartnerExternalID null
Ledger Ledger FINS_LEDGER
ProjectProfileCode Project Profile PROFIDPROJ
EngmntProjectHeaderCompanyCode Company code for the project BUKRS
EngagementProjectCostCenter Organization Unit Key /CPD/PWS_WS_ORG_UNIT_KEY
ProfitCenter Profit Center PRCTR
Master Data Relations Join Conditions
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_ENGMNTPROJECTREVIEWDATACUBE.MANDT == T009.MANDT
  • I_ENGMNTPROJECTREVIEWDATACUBE.FISCALYEARVARIANT == T009.PERIV
Sales document item category
  • Client
  • Sales document item category
  • I_ENGMNTPROJECTREVIEWDATACUBE.MANDT == TVPT.MANDT
  • I_ENGMNTPROJECTREVIEWDATACUBE.SALESORDERITEMCATEGORY == TVPT.PSTYV