I_EngmntProjLineItemKPI

DDL: I_ENGMNTPROJLINEITEMKPI SQL: IEPROJLINEITMKPI Type: view COMPOSITE

Project Plan Line Item KPI

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

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
P_EngmntProjPlanLineItemKPI PlanData from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WorkPackage _WorkPackage $projection.WorkPackage = _WorkPackage.WorkPackage

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IEPROJLINEITMKPI 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 Project Plan Line Item KPI view

Fields (13)

KeyFieldSource TableSource FieldDescription
EngagementProject EngagementProject
WorkPackage WorkPackage
EngagementProjectResourceType EngagementProjectResourceType
EngagementProjectResource EngagementProjectResource
WorkItem WorkItem
EngagementProjectServiceOrg EngagementProjectServiceOrg
BillingControlCategory BillingControlCategory
UnitOfMeasure UnitOfMeasure
Currency Currency
DemandEffortQty
PlannedExpenseCost
PlannedExpenseRevenue
_WorkPackage _WorkPackage 
@AbapCatalog.sqlViewName: 'IEPROJLINEITMKPI'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Project Plan Line Item KPI'
define view I_EngmntProjLineItemKPI
  as select from P_EngmntProjPlanLineItemKPI as PlanData
  association [0..1] to I_WorkPackage as _WorkPackage on $projection.WorkPackage = _WorkPackage.WorkPackage
{
  EngagementProject,
  WorkPackage,
  EngagementProjectResourceType,
  EngagementProjectResource,
  WorkItem,
  EngagementProjectServiceOrg,
  BillingControlCategory,
  @Semantics.unitOfMeasure: true
  UnitOfMeasure,
  
  @Semantics.currencyCode: true
  Currency,
  @Semantics.quantity.unitOfMeasure:'UnitOfMeasure'
  sum(DemandEffortQty)          as DemandEffortQty,
  
  @Semantics.amount.currencyCode:'Currency'
  sum(PlannedExpenseCost)       as PlannedExpenseCost,
  
  @Semantics.amount.currencyCode:'Currency'
  sum(PlannedExpenseRevenue)    as PlannedExpenseRevenue,
  _WorkPackage
}
where
      EngmtProjFinPlanVersion = '1'
  and EngmntProjPlanLineType  = 'D'
group by
  EngagementProject,
  WorkPackage,
  EngagementProjectResourceType,
  EngagementProjectResource,
  WorkItem,
  EngagementProjectServiceOrg,
  BillingControlCategory,
  UnitOfMeasure,
  Currency
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ENGMNTPROJPLANLINEITEMKPI"
],
"ASSOCIATED":
[
"I_WORKPACKAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More