P_OpActyComponentAssignmentAgg

DDL: P_OPACTYCOMPONENTASSIGNMENTAGG SQL: PMPECMPAA Type: view COMPOSITE

P_OpActyComponentAssignmentAgg is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OpActyComponentAssignment) and exposes 3 fields with key fields OpActyNtwkInstance, OpActyNtwkElement.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_OpActyComponentAssignment I_OpActyComponentAssignment from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMPECMPAA view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance OpActyNtwkInstance
KEY OpActyNtwkElement OpActyNtwkElement
NumberOfAssignedComponents 
@AbapCatalog.sqlViewName: 'PMPECMPAA'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #CUSTOMIZING}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// Used in I_PROCGEXECOPERATIONACTIVITY to deliver number of components per OA

define view P_OpActyComponentAssignmentAgg as select from I_OpActyComponentAssignment 
{
key OpActyNtwkInstance, 
key OpActyNtwkElement, 
    count(*) as NumberOfAssignedComponents
}
group by OpActyNtwkInstance, OpActyNtwkElement;

Learn More