P_EngmntProjReviewData

Column Name Description
Column Name Description
TotalNetAmount Net Value of the Order Item in Document Currency
ActlCostAmt Actual Cost
ActualCostUpToCurPerd null
ActlCostAmtUpToRevPerd null
ActualCostUpToFsclYrPerd null
ActlCostInCoCodeCrcy null
ActualExpenseCost null
ActlExpCostUpToCurPerd null
ActlExpenseCostUpToRevPerd null
ActlExpenseCostUpToFsclYrPerd null
PlndCostAmt Planned Cost
ActualPlanDeviationCost Cost Deviation
PlannedEffortCostAmt null
PlannedCostUpToCurPerd null
PlndCostAmtUpToRevPerd null
PlannedCostUpToFsclYrPerd null
AddlResourcePlannedCostAmount null
PlndRevnAmt Planned Revenue
PlndRevnAmtUpToRevPerd null
PlannedRevnUpToCurPerd null
PlannedRevnUpToFsclYrPerd null
PlannedExpenseCost null
PlndExpenseCostUpToRevPerd null
PlndExpCostUpToCurPerd null
PlndExpenseCostUpToFsclYrPerd null
ActualPlanDeviationExpnCost null
PlannedCostRate null
BaselinePlndCostAmt null
BaselinePlndRevnAmt null
AdjustedRemainingEffortCost Actual Cost
AdjustedRemainingExpnCost null
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
EstAtCmpltExpnUpToCurPerdAmt Actual Cost
EstAtCmpltExpnUpToRevPerdAmt Actual Cost
EstAtCmpltExpnUpToFsclPerdAmt Actual Cost
DerivedEstAtCompltnCostUpToCur Actual Cost
DerivedEstAtCompltnCostUpToRev Actual Cost
DerivdEstAtCompltnUpToFsclAmt Actual Cost
Column Name Description
ActlEffortQty Actual Effort
ActualEffortUpToFsclYrPerd null
ActualEffortUpToCurPerd null
ActlEffortQtyUpToRevPerd null
ActualUnitQty null
ActlUnitUpToCurPerdQty null
ActlUnitUpToRevPerdQty null
ActlUnitUpToFsclPerdQty null
AddlResourceActualQuantity null
AddlRsceUpToCurPerdActlQty null
AddlRsceUpToRevPerdActlQty null
AddlRsceUpToFsclPerdActlQty null
PlanUnitQuantity null
SupplyEffortQty null
PlndEffortQty Planned Effort
PlndEffortQtyUpToRevPerd null
PlndEffortUpToCurPerd null
PlndEffortUpToFsclYrPerd null
ActualPlanDeviationEffort Effort Deviation
AddlResourcePlannedQuantity null
AddlRsceActlPlanDeviationQty null
AdjustedOthRscePlndQty null
BaselinePlndEffortQty null
BaselinePlannedQuantity null
AdjustedRemainingEffort null
AdjustedRemngEffortToFsclPerd null
AddlRsceEstToCmpltQty null
AddlRsceEtcUpToCurPerdQty null
AddlRsceEtcUpToRevPerdQty null
AddlRsceEstToCmpltUpToFsclQty null
EstToCmpltEffortUpToRevPerd null
EstToCmpltEffortUpToCurPerd null
EstToCmpltUpToFsclPerdQty null
EstAtCompltnEffortUpToCurPerd null
EstAtCompltnEffortUpToRevPerd null
EstimateAtCompletionEffort null
EstAtCmpltUpToFsclPerdQty null
AddlRsceEstAtCompltnQty null
Column Name Description
ProjectStartDate Commercial Project: Start Date
ProjectEndDate Commercial Project: End Date
WorkPackageStartDate Start Date
WorkPackageEndDate End Date
Column Name Description
ProjectVisibility Confidential Indicator for Commercial Project Show values
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
Column Name Description Domain name
EngagementProject Project /CPD/MP_ID
EngagementProjectUUID Engagement Project UUID /BOBF/CONF_KEY
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
CityName City TEXT40
EngagementProjectStage Commercial Project: Stage /CPD/PWS_WS_MP_STG
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
EngagementProjectType Engagement Project Type /CPD/PWS_WS_MP_TYPE
ProjectLastChangedDateTime Changed On /CPD/SC_CHANGEDON
EngagementProjFinPlanUUID Financial Plan UUID /BOBF/CONF_KEY
EngmtProjFinPlanVersion null
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
SalesOrder Sales Document VBELN
SalesOrderItem Sales Document Item POSNR
SalesDocumentItemText 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
IsUnitBased null
ResourceIsOfUnitWorkPackage null
EngmntProjectDeliveryOrg null
EngagementProjectResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
EngagementProjectResource Role / Expense /CPD/PFP_RESOURCE_ID
AdjstdRemngEffortCstToFsclPerd null
CompltnRateInPctUpToCurPerd null
CompltnRateInPctUpToRevPerd null
PlndMarginPct null
IsMyProject null
ProjectManagerExternalID null
ProjectAccountantExternalID null
ProjectControllerExternalID null
ProjectPartnerExternalID null
ProjectManager null
ProjectAccountant null
ProjectController null
ProjectPartner null
ProjectManagerName null
ProjectAccountantName null
ProjectControllerName null
ProjectPartnerName 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
  • Fiscal Year Variant
  • Client
  • P_ENGMNTPROJREVIEWDATA.FISCALYEARVARIANT == T009.PERIV
  • P_ENGMNTPROJREVIEWDATA.MANDT == T009.MANDT
Sales document item category
  • Client
  • Sales document item category
  • P_ENGMNTPROJREVIEWDATA.MANDT == TVPT.MANDT
  • P_ENGMNTPROJREVIEWDATA.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
SD Document Currency
  • Client
  • SD Document Currency
  • P_ENGMNTPROJREVIEWDATA.MANDT == TCURC.MANDT
  • P_ENGMNTPROJREVIEWDATA.TRANSACTIONCURRENCY == TCURC.WAERS