P_EngmntProjDemandKPI

DDL: P_ENGMNTPROJDEMANDKPI SQL: PENGPRJDMDKPI Type: view COMPOSITE

P_EngmntProjDemandKPI is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_EngmntProjPlanLineItemKPI) and exposes 12 fields.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
P_EngmntProjPlanLineItemKPI A from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PENGPRJDMDKPI 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 (12)

KeyFieldSource TableSource FieldDescription
EngagementProject P_EngmntProjPlanLineItemKPI EngagementProject
WorkPackage P_EngmntProjPlanLineItemKPI WorkPackage
ResourceDemandUUID P_EngmntProjPlanLineItemKPI ResourceDemandUUID
EngmtProjFinPlanVersion P_EngmntProjPlanLineItemKPI EngmtProjFinPlanVersion
SupplyCostAmt
SupplyEffortQty
SupplyRevnAmt
RemainingDemandCostAmt
RemainingDemandEffortQty
RemainingDemandRevnAmt
PlannedExpenseCost
PlannedExpenseRevenue 
@AbapCatalog.sqlViewName: 'PENGPRJDMDKPI'
@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_EngmntProjDemandKPI
  as select from P_EngmntProjPlanLineItemKPI as A {
A.EngagementProject,
A.WorkPackage,
A.ResourceDemandUUID,
A.EngmtProjFinPlanVersion,
sum(A.SupplyCostAmt) as SupplyCostAmt,
sum(A.SupplyEffortQty) as SupplyEffortQty,
sum(A.SupplyRevnAmt) as SupplyRevnAmt,
sum(A.RemainingDemandCostAmt) as RemainingDemandCostAmt,
sum(A.RemainingDemandEffortQty) as RemainingDemandEffortQty,
sum(A.RemainingDemandRevnAmt) as RemainingDemandRevnAmt,
sum(A.PlannedExpenseCost) as PlannedExpenseCost,
sum(A.PlannedExpenseRevenue) as PlannedExpenseRevenue
} where A.IsUnitBased <> 'X'
  group by
  A.EngagementProject,
  A.WorkPackage,
  A.ResourceDemandUUID,
  A.EngmtProjFinPlanVersion
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ENGMNTPROJPLANLINEITEMKPI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More