I_EngagementProjectKPI

DDL: I_ENGAGEMENTPROJECTKPI SQL: IENGPRJKPI Type: view COMPOSITE

Engagement Project KPI

I_EngagementProjectKPI is a Composite CDS View that provides data about "Engagement Project KPI" in SAP S/4HANA. It reads from 1 data source (P_EngmntProjPlanLineItemKPI) and exposes 16 fields. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
P_EngmntProjPlanLineItemKPI PlanData from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EngagementProject _EngagementProject $projection.EngagementProject = _EngagementProject.EngagementProject

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IENGPRJKPI view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Engagement Project KPI view

Fields (16)

KeyFieldSource TableSource FieldDescription
EngagementProject EngagementProject
EngmtProjFinPlanVersion EngmtProjFinPlanVersion
Currency Currency
SupplyCostAmt
SupplyEffortQty
SupplyRevnAmt
RemainingDemandCostAmt
RemainingDemandEffortQty
RemainingDemandRevnAmt
PlannedExpenseRevenue
PlannedExpenseCost
DemandEffortQty
DemandCostAmt
PlannedUnitRevenue
RemainingRoleCostAmt
_EngagementProject _EngagementProject 
@AbapCatalog.sqlViewName: 'IENGPRJKPI'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Engagement Project KPI'
define view I_EngagementProjectKPI

  as select from P_EngmntProjPlanLineItemKPI as PlanData
  
  association [0..1] to I_EngagementProject    as _EngagementProject   on  $projection.EngagementProject = _EngagementProject.EngagementProject
{
  EngagementProject,  
  
  EngmtProjFinPlanVersion,
  
  @Semantics.currencyCode: true
  Currency,
     
  @Semantics.amount.currencyCode: 'Currency'
  sum(SupplyCostAmt)            as SupplyCostAmt,
  
  sum(SupplyEffortQty)          as SupplyEffortQty,
  
  @Semantics.amount.currencyCode: 'Currency'
  sum(SupplyRevnAmt)            as SupplyRevnAmt,
  
  @Semantics.amount.currencyCode: 'Currency'
  sum(RemainingDemandCostAmt)   as RemainingDemandCostAmt,
   
  sum(RscePlannedQuantity)      as RemainingDemandEffortQty,
  
  @Semantics.amount.currencyCode: 'Currency'
  sum(RemainingDemandRevnAmt)   as RemainingDemandRevnAmt,
  
  @Semantics.amount.currencyCode: 'Currency'
  sum(PlannedExpenseRevenue)    as PlannedExpenseRevenue,
  
  @Semantics.amount.currencyCode: 'Currency'
  sum(PlannedExpenseCost)       as PlannedExpenseCost,
  
  sum(DemandEffortQty)          as DemandEffortQty,
  
  @Semantics.amount.currencyCode: 'Currency'
  sum(DemandCostAmt)            as DemandCostAmt,
  
  @Semantics.amount.currencyCode: 'Currency'
  sum(PlannedUnitRevenue)       as PlannedUnitRevenue,
  
  @Semantics.amount.currencyCode: 'Currency'
  sum(RemainingRoleCostAmt)   as RemainingRoleCostAmt,
  
  _EngagementProject   
}
group by
  EngagementProject,  
  EngmtProjFinPlanVersion,
  Currency
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ENGMNTPROJPLANLINEITEMKPI"
],
"ASSOCIATED":
[
"I_ENGAGEMENTPROJECT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More