P_NmbrOfChmlCompInCmpst

DDL: P_NMBROFCHMLCOMPINCMPST Type: view BASIC

P_NmbrOfChmlCompInCmpst is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_ChmlComponent, I_ChmlComposition) and exposes 5 fields.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_ChmlComponent _Component inner
I_ChmlComposition _Composition from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PNCHMCMPIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
ChmlCmplncInfoUUID I_ChmlComponent ChmlCmplncInfoUUID
ChmlCompositionUUID I_ChmlComponent ChmlCompositionUUID
ChmlCompositionType I_ChmlComposition ChmlCompositionType
ChmlCompositionStatus I_ChmlComposition ChmlCompositionStatus
NmbrOfChmlComps 
@AbapCatalog:
{
  -- SQL view name (16 characters)
  sqlViewName: 'PNCHMCMPIC',

  --If it's true, the filter conditions are compared and, if they match, the associated join expression is evaluated only once
  compiler.compareFilter: true
}

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

--VDM view type
@VDM.viewType: #BASIC
@VDM.private: true
define view P_NmbrOfChmlCompInCmpst
 as select from I_ChmlComposition as _Composition
 inner join I_ChmlComponent as _Component
         on _Component.ChmlCompositionUUID = _Composition.ChmlCompositionUUID
 {
   _Component.ChmlCmplncInfoUUID,
   _Component.ChmlCompositionUUID,
   _Composition.ChmlCompositionType,
   _Composition.ChmlCompositionStatus,
   count(distinct _Component.ChmlCompUUID) as NmbrOfChmlComps 
 } 
 group by _Component.ChmlCmplncInfoUUID, 
          _Component.ChmlCompositionUUID,  
          _Composition.ChmlCompositionType,
          _Composition.ChmlCompositionStatus

Learn More