I_WorkPackageKPI

DDL: I_WORKPACKAGEKPI SQL: IWRKPCKGKPI Type: view COMPOSITE

WorkPackage KPI

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

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
P_EngmntProjPlanLineItemKPI P_EngmntProjPlanLineItemKPI from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency $projection.Currency = _Currency.Currency

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IWRKPCKGKPI 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
EndUserText.label WorkPackage KPI view

Fields (18)

KeyFieldSource TableSource FieldDescription
EngagementProject EngagementProject
WorkPackage WorkPackage
EngmtProjFinPlanVersion EngmtProjFinPlanVersion
Currency Currency
WorkPackageUnit
WorkPackageUnitUoM
SupplyCostAmt
SupplyEffortQty
SupplyRevnAmt
RemainingDemandCostAmt
RemainingDemandEffortQty
RemainingDemandRevnAmt
PlannedExpenseRevenue
PlannedExpenseCost
PlannedUnitRevenue
PlanUnitQuantity
_EngagementProject _EngagementProject
_Currency _Currency 
@AbapCatalog.sqlViewName: 'IWRKPCKGKPI'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'WorkPackage KPI'
define view I_WorkPackageKPI
  as select from P_EngmntProjPlanLineItemKPI
  association [0..1] to I_Currency as _Currency on  $projection.Currency = _Currency.Currency   
{

 // EngagementProjectUUID,

  EngagementProject,
  WorkPackage,
//  WorkPackageUUID,

  EngmtProjFinPlanVersion,
 @Semantics.currencyCode: true  
  Currency,
  max(WorkPackageUnit) as WorkPackageUnit,
@Semantics.unitOfMeasure: true  
  max(WorkPackageUnitUoM) as WorkPackageUnitUoM,
@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,
@Semantics.amount.currencyCode: 'Currency'  
  sum(PlannedUnitRevenue)                        as PlannedUnitRevenue,
@Semantics.quantity.unitOfMeasure:'WorkPackageUnitUoM'  
  sum(PlanUnitQuantity)                          as PlanUnitQuantity,

  _EngagementProject,
  _Currency
}
group by
  EngagementProject,
  WorkPackage,
//  WorkPackageUUID,

  EngmtProjFinPlanVersion,
  Currency

Learn More