C_EngmntProjReviewQuery

Column Name Description
Column Name Description
💲 Plan Currency (Currency):
PlndRevnAmt Planned Revenue
PlndCostAmt Planned Cost
ActualPlanDeviationCost Cost Deviation
ActualPlanDeviationExpnCost null
ActlCostAmt Actual Cost
PlannedEffortCostAmt null
AddlResourcePlannedCostAmount null
PlannedExpenseCost null
ActualExpenseCost null
PlannedCostUpToCurPerd null
PlannedRevnUpToCurPerd null
ActualCostUpToCurPerd null
ActlExpCostUpToCurPerd null
PlndExpCostUpToCurPerd null
PlndCostAmtUpToRevPerd null
PlndRevnAmtUpToRevPerd null
ActlCostAmtUpToRevPerd null
ActlExpenseCostUpToRevPerd null
PlndExpenseCostUpToRevPerd null
AdjustedRemainingEffortCost Actual Cost
AddlRsceEstToCmpltCostAmount Actual Cost
EstToCmpltEffCostUpToCurPerd Actual Cost
AddlRsceEtcCostUpToCurPerdAmt Actual Cost
EstToCmpltEffCostUpToRevPerd Actual Cost
AddlRsceEtcCostUpToRevPerdAmt Actual Cost
AdjustedRemainingExpnCost null
EstToCmpltExpnCostUpToCurPerd null
EstToCmpltExpnCostUpToRevPerd null
AdjustedRemainingCostPlnAmt Actual Cost
EstToCmpltCostUpToCurPerd Actual Cost
EstToCmpltCostUpToRevPerd Actual Cost
EstimateAtCompletionCost Actual Cost
EstAtCompltnCostUpToCurPerd Actual Cost
EstAtCompltnCostUpToRevPerd Actual Cost
EstimateAtCompletionExpnCost Actual Cost
💲 Plan Currency (TransactionCurrency):
RevenueAsSoldAmount Net Value of the Order Item in Document Currency
DerivedEstAtCompltnCostUpToCur Actual Cost
DerivedEstAtCompltnCostUpToRev Actual Cost
Column Name Description
📏 Cost Source Unit (UnitOfMeasure):
PlndEffortQty Planned Effort
AddlResourcePlannedQuantity null
ActualPlanDeviationEffort Effort Deviation
AddlRsceActlPlanDeviationQty null
ActlEffortQty Actual Effort
AddlResourceActualQuantity null
PlndEffortUpToCurPerd null
ActualEffortUpToCurPerd null
AddlRsceUpToCurPerdActlQty null
PlndEffortQtyUpToRevPerd null
ActlEffortQtyUpToRevPerd null
AddlRsceUpToRevPerdActlQty null
AdjustedRemainingEffort null
AddlRsceEstToCmpltQty null
EstToCmpltEffortUpToCurPerd null
AddlRsceEtcUpToCurPerdQty null
EstToCmpltEffortUpToRevPerd null
AddlRsceEtcUpToRevPerdQty null
EstimateAtCompletionEffort null
Column Name Description
ProjectStartDate Commercial Project: Start Date
ProjectEndDate Commercial Project: End Date
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
EngagementProjectCategory Project Type Show values
Column Name Description Domain name
EngagementProject Project /CPD/MP_ID
Ledger Ledger FINS_LEDGER
EngagementProjectName Customer Project Name /CPD/SHORT_TEXT
IsMyProject null
EngagementProjectStage Commercial Project: Stage /CPD/PWS_WS_MP_STG
Customer Customer Number KUNNR
CustomerName Name of Customer TEXT80
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
ProjectManager null
ProjectManagerExternalID null
ProjectManagerName null
ProjectAccountant null
ProjectAccountantExternalID null
ProjectAccountantName null
ProjectController null
ProjectControllerExternalID null
ProjectControllerName null
ProjectPartner null
ProjectPartnerExternalID null
ProjectPartnerName null
LastChangeDateTime Created On DEC15
ProjectLastChangedDateTime Changed On /CPD/SC_CHANGEDON
EngagementProjectStatus Status Key /CPD/PWS_WS_STATUS_KEY_FIG
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
CostVariance null
CurrentPeriodCostVariance null
CostVarianceUpToRevPerd null
EffortVariance null
AddlRsceVarcOfQty null
EffortVarianceUpToCurPerd null
AddlRsceVarcUpToCurPerdQty null
EffortVarianceUpToRevPerd null
AddlRsceVarcUpToRevPerdQty null
CostDeviation null
CostDvtnUpToCurrentPeriod null
CostDeviationUpToRevPerd null
EffortDeviation null
EffortDeviationUpToCurPerd null
EffortDeviationUpToRevPerd null
CostDeviationInPercent null
CostDvtnUpToCurPerdInPct null
CostDvtnUpToRevPerdInPct null
EffortDeviationInPercent null
EffortDvtnUpToCurPerdInPct null
EffortDvtnUpToRevPerdInPct null
CalculatedAdjustedRmngCost null
CalcdRmngCostUpToCurPerd null
CalcdRmngCostUpToRevPerd null
CalculatedAdjustedRmngEffort null
CalcdRmngEffortUpToCurPerd null
CalcdRmngEffortUpToRevPerd null
AddlRsceCalcdEstToCmpltQty null
AddlRsceCalcdEtcUpToCurPerdQty null
AddlRsceCalcdEtcUpToRevPerdQty null
CalculatedAdjustedRmngExpCost null
CalcdRmngExpnCostUpToCurPerd null
CalcdRmngExpnCostUpToRevPerd null
PlannedCostRate null
AddlResourcePlannedCostRate null
PctOfCompletionUpToCurPerd null
PctOfCompletionUpToRevPerd null
CompltnRateInPctUpToCurPerd null
CompltnRateInPctUpToRevPerd null
PlndMarginPct null
MarginAsSoldInPct null
MarginAtCompletionPct null
Master Data Relations Join Conditions
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_ENGMNTPROJREVIEWQUERY.FISCALYEARVARIANT == T009.PERIV
  • C_ENGMNTPROJREVIEWQUERY.MANDT == T009.MANDT