P_PlngDataAggrgnByDelivOrg

Planning Data Aggregation | view: PEPPLNGAGGDO | Extraction: Not supported | Component: S/4HANA Professional Services Cloud - CPM
Column Name Description
EngagementProject Engagement Project ID
Column Name Description
PlndCostAmt null
PlndRevnAmt null
RemainingDemandCostAmt null
SupplyCostAmt null
RemainingDemandRevnAmt null
SupplyRevnAmt null
PlannedExpenseCost null
PlannedExpenseRevenue null
DemandCostAmt null
PlannedUnitRevenue null
ActualPlanDeviationCost null
Column Name Description
PlndEffortQty null
RemainingDemandEffortQty null
SupplyEffortQty null
DemandEffortQty null
PlanUnitQuantity null
ActualPlanDeviationEffort null
RscePlannedQuantity null
Column Name Description
Column Name Description
EngagementProjectCategory Project Type Show values
BillingControlCategory Billing Control Category Show values
IsUnitBased Confirmation on Unit Based Planning Show values
ProjectVisibility Confidential Indicator for Commercial Project Show values
Column Name Description Domain name
EngmntProjReviewYearPeriod Review Year Period /CPD/FISCAL_YEAR_PERIOD
EngagementProjectReviewStatus Forecast Status ID /CPD/PFP_FORECAST_ST_ID
CurrentYearPeriod Current Year Period /CPD/SS_CURRENT_YEAR_PERIOD
ProjectManagerExternalID null
ProjectAccountantExternalID null
ProjectControllerExternalID null
ProjectPartnerExternalID null
ProjectManager null
ProjectAccountant null
ProjectController null
Projectpartner null
ProjectManagerName null
ProjectAccountantName null
ProjectControllerName null
ProjectPartnerName null
IsMyProject null
EngagementProjectServiceOrg Service Organization /CPD/PWS_WS_ORG_UNIT_ID
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
EngagementProjFinPlanUUID Financial Plan UUID /BOBF/CONF_KEY
EngmtProjFinPlanVersion Plan Version ID /CPD/PFP_VERSION_ID
WorkPackageUnit Resource ID /CPD/PFP_RESOURCE_ID
EngagementProjectResource Resource ID /CPD/PFP_RESOURCE_ID
EngagementProjectResourceType Resource Type ID /CPD/PFP_RES_TYPE_ID
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
FiscalYear Fiscal Year GJAHR
FiscalPeriod Period PERBL
ResourceDemandUUID Demand Key /CPD/DEMAND_KEY
ResourceDemand Resource Demand ID /CPD/DEMAND_ID
EngagementProjectCostCenter Organization Unit Key /CPD/PWS_WS_ORG_UNIT_KEY
ProfitCenter Profit Center PRCTR
DeliveryOrganization null
EngmntProjectDeliveryOrg null
Master Data Relations Join Conditions
Plan Currency
  • Client
  • Plan Currency
  • P_PLNGDATAAGGRGNBYDELIVORG.MANDT == TCURC.MANDT
  • P_PLNGDATAAGGRGNBYDELIVORG.CURRENCY == TCURC.WAERS
Company code
  • Client
  • Company code for the project
  • P_PLNGDATAAGGRGNBYDELIVORG.MANDT == T001.MANDT
  • P_PLNGDATAAGGRGNBYDELIVORG.ENGMNTPROJECTHEADERCOMPANYCODE == T001.BUKRS
Profile ID for project structure
  • Client
  • Project Profile
  • P_PLNGDATAAGGRGNBYDELIVORG.MANDT == TCJ41.MANDT
  • P_PLNGDATAAGGRGNBYDELIVORG.PROJECTPROFILECODE == TCJ41.PROFIDPROJ