P_ChmlCmplncInfoAssmtLastDate

DDL: P_CHMLCMPLNCINFOASSMTLASTDATE Type: view CONSUMPTION Package: EHFND_CNS_CCI

CCI assmt last date

P_ChmlCmplncInfoAssmtLastDate is a Consumption CDS View that provides data about "CCI assmt last date" in SAP S/4HANA. It reads from 2 data sources (I_ChmlCmplncInfo, I_CmplRqRslt) and exposes 4 fields with key field ComplianceRequirement. Part of development package EHFND_CNS_CCI.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_ChmlCmplncInfo ChmlCmplncInfo inner
I_CmplRqRslt CmplRqRslt from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCCIASSMTLD 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 assmt last date view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ComplianceRequirement I_CmplRqRslt ComplianceRequirement
ChmlCmplncInfoUUID I_ChmlCmplncInfo ChmlCmplncInfoUUID
CmplRqPattern
CreationDateTime 
@AbapCatalog: {
  sqlViewName: 'PCCIASSMTLD',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

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

@EndUserText.label: 'CCI assmt last date'
define view P_ChmlCmplncInfoAssmtLastDate
  as select from I_CmplRqRslt     as CmplRqRslt

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


{
  key CmplRqRslt.ComplianceRequirement     as ComplianceRequirement,
      ChmlCmplncInfo.ChmlCmplncInfoUUID    as ChmlCmplncInfoUUID,
      CmplRqRslt._CmplRqVers.CmplRqPattern as CmplRqPattern,
      max(CmplRqRslt.CreationDateTime)     as CreationDateTime

}
where
     CmplRqRslt.CmplRqRsltProcessingStatus = 'IP'
  or CmplRqRslt.CmplRqRsltProcessingStatus = 'RE'
group by
  CmplRqRslt.ComplianceRequirement,
  CmplRqRslt._CmplRqVers.CmplRqPattern,
  ChmlCmplncInfo.ChmlCmplncInfoUUID

Learn More