P_ChmlCompsCompSumCT

DDL: P_CHMLCOMPSCOMPSUMCT Type: view CONSUMPTION

P_ChmlCompsCompSumCT is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ChmlComposition) and exposes 6 fields.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlComposition I_ChmlComposition from

Annotations (6)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
ChmlCompositionUUID
ChmlCompositionType _ChmlComposition ChmlCompositionType
ChmlCmplncInfoUUID _ChmlComposition ChmlCmplncInfoUUID
ChmlSuplrMatlUUID _ChmlComposition ChmlSuplrMatlUUID
ChmlCompositionStatus _ChmlComposition ChmlCompositionStatus
SumComponentCount 
@AbapCatalog:
{
  -- SQL view name (16 characters)
  sqlViewName: 'PCCCOMPSUMCT',

  --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: #CONSUMPTION
@VDM.private: true

define view P_ChmlCompsCompSumCT
  as select from    I_ChmlComposition _ChmlComposition
    left outer to many join I_ChmlComponent  as _Component on _Component.ChmlCompositionUUID = _ChmlComposition.ChmlCompositionUUID
{
      --Parent Composition UUID
  key _ChmlComposition.ChmlCompositionUUID,

      _ChmlComposition.ChmlCompositionType,
      _ChmlComposition.ChmlCmplncInfoUUID,
      _ChmlComposition.ChmlSuplrMatlUUID,
      _ChmlComposition.ChmlCompositionStatus,
      
      count( distinct _Component.ChmlCompUUID )                    as SumComponentCount
}
group by
  _ChmlComposition.ChmlCompositionUUID,
  _ChmlComposition.ChmlCmplncInfoUUID,
  _ChmlComposition.ChmlSuplrMatlUUID,
  _ChmlComposition.ChmlCompositionType,
  _ChmlComposition.ChmlCompositionStatus

Learn More