P_WorkPackageWorkItemCount

DDL: P_WORKPACKAGEWORKITEMCOUNT Type: view COMPOSITE

P_WorkPackageWorkItemCount is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_WorkPackageWorkItem) and exposes 2 fields with key field WorkPackage.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkPackageWorkItem I_WorkPackageWorkItem from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PWPWRKITMCNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #NONE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY WorkPackage WorkPackage
NumberOfWorkItems 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
    sqlViewName: 'PWPWRKITMCNT',
    compiler.compareFilter: true,
    preserveKey: true
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
    usageType.serviceQuality: #D,
    usageType.sizeCategory: #XL,
    usageType.dataClass: #MIXED
}
@VDM: {
    private: true,
    viewType: #COMPOSITE,
    lifecycle.contract.type: #NONE
}

define view P_WorkPackageWorkItemCount
  as select from I_WorkPackageWorkItem
{

  key WorkPackage,
      count( distinct WorkItem ) as NumberOfWorkItems

}
group by
  WorkPackage

Learn More