P_CmplRqRsltLtst

DDL: P_CMPLRQRSLTLTST SQL: PCRRLTST Type: view COMPOSITE

P_CmplRqRsltLtst is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_CmplRqRsltLtstCrtnDte, I_CmplRqRslt) and exposes 1 field with key field CmplRqRsltUUID.

2 data source(s) 1 fields

Data Sources (2)

SourceAliasJoin Type
P_CmplRqRsltLtstCrtnDte _CmplRqRsltLtstCrtnDte inner
I_CmplRqRslt crr from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCRRLTST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltUUID I_CmplRqRslt CmplRqRsltUUID 
@AbapCatalog.sqlViewName: 'PCRRLTST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
// Use this view to get the latest crr uuids

define view P_CmplRqRsltLtst as 
  select from I_CmplRqRslt as crr
    // filter on the latest creationdate for cci and crv    

    inner join P_CmplRqRsltLtstCrtnDte as _CmplRqRsltLtstCrtnDte on _CmplRqRsltLtstCrtnDte.chmlcmplncinfouuid = crr.ChmlCmplncInfoUUID
                                                              and _CmplRqRsltLtstCrtnDte.cmplrqversuuid = crr.CmplRqVersUUID
                                                              and _CmplRqRsltLtstCrtnDte.creationdatetime = crr.CreationDateTime
{
  key crr.CmplRqRsltUUID
}

Learn More