I_WorkPackageUnitKPI

DDL: I_WORKPACKAGEUNITKPI SQL: IWRKPCKGUNITKPI Type: view COMPOSITE

WorkPackage Unit KPI

I_WorkPackageUnitKPI is a Composite CDS View that provides data about "WorkPackage Unit KPI" in SAP S/4HANA. It reads from 1 data source (I_EngmntProjectUnitDataVersion) and exposes 26 fields with key fields EngagementProject, WorkPackage, EngagementProjFinPlanUUID, WorkPackageUUID, EngmtProjFinPlanVersion. It has 1 association to related views.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjectUnitDataVersion I_EngmntProjectUnitDataVersion from

Associations (1)

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

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IWRKPCKGUNITKPI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label WorkPackage Unit KPI view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject EngagementProject
KEY WorkPackage WorkPackage
KEY EngagementProjFinPlanUUID EngagementProjFinPlanUUID
KEY WorkPackageUUID WorkPackageUUID
KEY EngmtProjFinPlanVersion EngmtProjFinPlanVersion
KEY EngagementProjectResourceType EngagementProjectResourceType
KEY WorkPackageUnit EngagementProjectResource
KEY ResourceDemandUUID ResourceDemandUUID
BillingControlCategory BillingControlCategory
EngagementProjectServiceOrg EngagementProjectServiceOrg
Currency Currency
PlndCostAmt
WorkPackageUnitUoM UnitOfMeasure
PlanUnitQuantity
PlndRevnAmt
EngmntProjPlanLineType EngmntProjPlanLineType
_BillingControlCategory _BillingControlCategory
_Currency _Currency
_EngagementProject _EngagementProject
_EngagementProjectResource _EngagementProjectResource
_EngagementProjectServiceOrg _EngagementProjectServiceOrg
_EngagementProjFinancialPlan _EngagementProjFinancialPlan
_EngmntProjResourceType _EngmntProjResourceType
_EngmtProjFinPlanVersion _EngmtProjFinPlanVersion
_UnitOfMeasure _UnitOfMeasure
_WorkPackage _WorkPackage 
@AbapCatalog.sqlViewName: 'IWRKPCKGUNITKPI'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'WorkPackage Unit KPI'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view I_WorkPackageUnitKPI
  as select from I_EngmntProjectUnitDataVersion
  association [0..1] to I_Currency as _Currency on  $projection.Currency = _Currency.Currency  
{

      //I_EngmntProjectUnitDataVersion

  key EngagementProject,
  key WorkPackage,
  key EngagementProjFinPlanUUID,
  key WorkPackageUUID,
  key EngmtProjFinPlanVersion,
  key EngagementProjectResourceType,
  key EngagementProjectResource as WorkPackageUnit,
  key ResourceDemandUUID,
      BillingControlCategory,
      EngagementProjectServiceOrg,
@Semantics.currencyCode: true      
      Currency,
@Semantics.amount.currencyCode: 'Currency'      
      sum (PlndCostAmt)         as PlndCostAmt,
@Semantics.unitOfMeasure: true      
      UnitOfMeasure             as WorkPackageUnitUoM,
@Semantics.quantity.unitOfMeasure:'WorkPackageUnitUoM'      
      sum (PlndEffortQty)       as PlanUnitQuantity,
@Semantics.amount.currencyCode: 'Currency'      
      sum(PlndRevnAmt)          as PlndRevnAmt,
      EngmntProjPlanLineType,

      /* Associations */
      //I_EngmntProjectUnitDataVersion

      _BillingControlCategory,
      _Currency,
      _EngagementProject,
      _EngagementProjectResource,
      _EngagementProjectServiceOrg,
      _EngagementProjFinancialPlan,
      _EngmntProjResourceType,
      _EngmtProjFinPlanVersion,
      _UnitOfMeasure,
      _WorkPackage
      }
group by
  EngagementProject,
  WorkPackage,
  EngagementProjFinPlanUUID,
  WorkPackageUUID,
  EngmtProjFinPlanVersion,
  EngagementProjectResourceType,
  EngagementProjectResource,
  ResourceDemandUUID,
  BillingControlCategory,
  EngagementProjectServiceOrg,
  UnitOfMeasure,
  Currency,
  EngmntProjPlanLineType
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGMNTPROJECTUNITDATAVERSION"
],
"ASSOCIATED":
[
"I_BILLINGCONTROLCATEGORY",
"I_CURRENCY",
"I_ENGAGEMENTPROJECT",
"I_ENGAGEMENTPROJECTRESOURCE",
"I_ENGAGEMENTPROJECTSRVCORG",
"I_ENGAGEMENTPROJFINANCIALPLAN",
"I_ENGMNTPROJRESOURCETYPE",
"I_ENGMTPROJFINPLANVERSION",
"I_UNITOFMEASURE",
"I_WORKPACKAGE"
],
"BASE":
[
"I_ENGMNTPROJECTUNITDATAVERSION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More