P_EngmntProjectUnitDataVersion

DDL: P_ENGMNTPROJECTUNITDATAVERSION SQL: PEPROJUNITDATVER Type: view COMPOSITE

P_EngmntProjectUnitDataVersion is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_EngmntProjectUnitDataVersion) and exposes 14 fields with key fields EngagementProject, WorkPackage, EngmtProjFinPlanVersion, EngagementProjectResourceType, EngagementProjectResource.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_EngmntProjectUnitDataVersion I_EngmntProjectUnitDataVersion from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PEPROJUNITDATVER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject EngagementProject
KEY WorkPackage WorkPackage
KEY EngmtProjFinPlanVersion EngmtProjFinPlanVersion
KEY EngagementProjectResourceType EngagementProjectResourceType
KEY EngagementProjectResource EngagementProjectResource
BillingControlCategory BillingControlCategory
EngagementProjectServiceOrg EngagementProjectServiceOrg
Currency Currency
UnitOfMeasure UnitOfMeasure
PlndCostAmt
PlndEffortQty
PlndRevnAmt
EngmntProjPlanLineType EngmntProjPlanLineType
IsUnitBased IsUnitBased 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PEPROJUNITDATVER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_EngmntProjectUnitDataVersion
  as select from I_EngmntProjectUnitDataVersion
{
  key EngagementProject,
  key WorkPackage,
  key EngmtProjFinPlanVersion,
  key EngagementProjectResourceType,
  key EngagementProjectResource,
      BillingControlCategory,
      EngagementProjectServiceOrg,
      Currency,
      UnitOfMeasure,
      sum(PlndCostAmt)   as PlndCostAmt,
      sum(PlndEffortQty) as PlndEffortQty,
      sum(PlndRevnAmt)   as PlndRevnAmt,
      EngmntProjPlanLineType,
      IsUnitBased

}
group by
  EngagementProject,
  WorkPackage,
  EngmtProjFinPlanVersion,
  EngagementProjectResourceType,
  EngagementProjectResource,
  BillingControlCategory,
  EngagementProjectServiceOrg,
  Currency,
  UnitOfMeasure,
  EngmntProjPlanLineType,
  IsUnitBased

Learn More