P_EngmtProjDmndByPerdKPI

DDL: P_ENGMTPROJDMNDBYPERDKPI SQL: PENGPRJDMDPRKPI Type: view COMPOSITE Package: CPD_CDS

Engagement Project Demand By Period KPI

P_EngmtProjDmndByPerdKPI is a Composite CDS View that provides data about "Engagement Project Demand By Period KPI" in SAP S/4HANA. It reads from 2 data sources (I_EngmntProjAssgmtToSessionUsr, P_EngmntProjPlanLineItemKPI) and exposes 27 fields. Part of development package CPD_CDS.

2 data source(s) 27 fields

Data Sources (2)

SourceAliasJoin Type
I_EngmntProjAssgmtToSessionUsr A from
P_EngmntProjPlanLineItemKPI PlanData inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PENGPRJDMDPRKPI view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (27)

KeyFieldSource TableSource FieldDescription
EngagementProject P_EngmntProjPlanLineItemKPI EngagementProject
WorkPackage P_EngmntProjPlanLineItemKPI WorkPackage
ResourceDemandUUID P_EngmntProjPlanLineItemKPI ResourceDemandUUID
EngmtProjFinPlanVersion P_EngmntProjPlanLineItemKPI EngmtProjFinPlanVersion
FiscalPeriod P_EngmntProjPlanLineItemKPI FiscalPeriod
FiscalYear P_EngmntProjPlanLineItemKPI FiscalYear
CustomerProjectServiceOrg I_EngmntProjAssgmtToSessionUsr EngagementProjectServiceOrg
IsMyProject I_EngmntProjAssgmtToSessionUsr IsMyProject
EngagementProjectCategory I_EngmntProjAssgmtToSessionUsr EngagementProjectCategory
EngagementProjectType I_EngmntProjAssgmtToSessionUsr EngagementProjectType
Customer I_EngmntProjAssgmtToSessionUsr Customer
ProjectVisibility I_EngmntProjAssgmtToSessionUsr ProjectVisibility
EngagementProjectStage I_EngmntProjAssgmtToSessionUsr EngagementProjectStage
EngagementProjectCostCenter I_EngmntProjAssgmtToSessionUsr EngagementProjectCostCenter
EngmntProjectHeaderCompanyCode I_EngmntProjAssgmtToSessionUsr EngmntProjectHeaderCompanyCode
ProfitCenter I_EngmntProjAssgmtToSessionUsr ProfitCenter
ProjectProfileCode I_EngmntProjAssgmtToSessionUsr ProjectProfileCode
ControllingArea I_EngmntProjAssgmtToSessionUsr ControllingArea
LastChangeDateTime I_EngmntProjAssgmtToSessionUsr LastChangeDateTime
SupplyCostAmt
SupplyEffortQty
SupplyRevnAmt
RemainingDemandCostAmt
RemainingDemandEffortQty
RemainingDemandRevnAmt
PlannedExpenseCost
PlannedExpenseRevenue 
@AbapCatalog.sqlViewName: 'PENGPRJDMDPRKPI'
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_EngmtProjDmndByPerdKPI
  as select from I_EngmntProjAssgmtToSessionUsr as A
    inner join P_EngmntProjPlanLineItemKPI as PlanData on A.EngagementProject = PlanData.EngagementProject
{
  PlanData.EngagementProject,
  PlanData.WorkPackage,
  PlanData.ResourceDemandUUID,
  PlanData.EngmtProjFinPlanVersion,
  PlanData.FiscalPeriod,
  PlanData.FiscalYear,

  
  A.EngagementProjectServiceOrg as CustomerProjectServiceOrg,
  A.IsMyProject,
  A.EngagementProjectCategory,
  A.EngagementProjectType,
  A.Customer,
  A.ProjectVisibility,
  A.EngagementProjectStage,
  A.EngagementProjectCostCenter,
  A.EngmntProjectHeaderCompanyCode,
  A.ProfitCenter,
  A.ProjectProfileCode,
  A.ControllingArea,
  A.LastChangeDateTime,
      
  sum(SupplyCostAmt)            as SupplyCostAmt,
  sum(SupplyEffortQty)          as SupplyEffortQty,
  sum(SupplyRevnAmt)            as SupplyRevnAmt,
  sum(RemainingDemandCostAmt)   as RemainingDemandCostAmt,
  sum(RemainingDemandEffortQty) as RemainingDemandEffortQty,
  sum(RemainingDemandRevnAmt)   as RemainingDemandRevnAmt,
  //  sum(DemandEffortQty)          as DemandEffortQty,

  //  sum(DemandCostAmt)            as DemandCostAmt,

  sum(PlannedExpenseCost)       as PlannedExpenseCost,
  sum(PlannedExpenseRevenue)    as PlannedExpenseRevenue
  
}
where
  IsUnitBased <> 'X'
group by
  PlanData.EngagementProject,
  PlanData.WorkPackage,
  PlanData.ResourceDemandUUID,
  PlanData.EngmtProjFinPlanVersion,
  PlanData.FiscalPeriod,
  PlanData.FiscalYear,
  A.EngagementProjectServiceOrg,
  A.IsMyProject,
  A.EngagementProjectCategory,
  A.EngagementProjectType,
  A.Customer,
  A.ProjectVisibility,
  A.EngagementProjectStage,
  A.EngagementProjectCostCenter,
  A.EngmntProjectHeaderCompanyCode,
  A.ProfitCenter,
  A.ProjectProfileCode,
  A.ControllingArea,
  A.LastChangeDateTime

Learn More