P_ChmlCmplncInfoCmpstnLastDate

DDL: P_CHMLCMPLNCINFOCMPSTNLASTDATE Type: view CONSUMPTION

CCI Composition Last Date

P_ChmlCmplncInfoCmpstnLastDate is a Consumption CDS View that provides data about "CCI Composition Last Date" in SAP S/4HANA. It reads from 2 data sources (I_ChmlCmplncInfo, I_ChmlComposition) and exposes 3 fields with key field ChmlCompositionType.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_ChmlCmplncInfo ChmlCmplncInfo inner
I_ChmlComposition ChmlCmplncInfoComposition from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCCICOMPLD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label CCI Composition Last Date view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ChmlCompositionType I_ChmlComposition ChmlCompositionType
ChmlCmplncInfoUUID I_ChmlCmplncInfo ChmlCmplncInfoUUID
LastChangeUTCDateTime 
@AbapCatalog: {
  sqlViewName: 'PCCICOMPLD',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'CCI Composition Last Date'
define view P_ChmlCmplncInfoCmpstnLastDate
  as select from I_ChmlComposition as ChmlCmplncInfoComposition

    inner join   I_ChmlCmplncInfo  as ChmlCmplncInfo on ChmlCmplncInfo.ChmlCmplncInfoUUID = ChmlCmplncInfoComposition.ChmlCmplncInfoUUID

{
  key ChmlCmplncInfoComposition.ChmlCompositionType        as ChmlCompositionType,
      ChmlCmplncInfo.ChmlCmplncInfoUUID                    as ChmlCmplncInfoUUID,
      max(ChmlCmplncInfoComposition.LastChangeUTCDateTime) as LastChangeUTCDateTime
}
group by
  ChmlCmplncInfoComposition.ChmlCompositionType,
  ChmlCmplncInfo.ChmlCmplncInfoUUID

Learn More