P_BasicDescForReldRglnMaxCRR

DDL: P_BASICDESCFORRELDRGLNMAXCRR Type: view COMPOSITE

P_BasicDescForReldRglnMaxCRR is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_CmplRqRslt, I_CmplRqRsltDngrsGdsBscDescT, I_CmplRqVers) and exposes 2 fields with key fields ChmlCmplncInfoUUID, CmplRqRsltUUID.

3 data source(s) 2 fields

Data Sources (3)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt inner
I_CmplRqRsltDngrsGdsBscDescT I_CmplRqRsltDngrsGdsBscDescT from
I_CmplRqVers I_CmplRqVers inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PDGBDSCFRRMCRR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_CmplRqRslt ChmlCmplncInfoUUID
KEY CmplRqRsltUUID 
@AbapCatalog:{
  sqlViewName: 'PDGBDSCFRRMCRR',
  compiler.compareFilter: true
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

@ObjectModel: {
  usageType: {
    serviceQuality: #C,
    sizeCategory: #L,
    dataClass: #MIXED
  }
}

@VDM: {
  private: true,
  viewType: #COMPOSITE
}

define view P_BasicDescForReldRglnMaxCRR 
  as select  from I_CmplRqRsltDngrsGdsBscDescT
    inner join I_CmplRqRslt on  I_CmplRqRsltDngrsGdsBscDescT.CmplRqRsltUUID = I_CmplRqRslt.CmplRqRsltUUID
                            and I_CmplRqRslt.CmplRqRsltProcessingStatus = 'RE'
    inner join I_CmplRqVers on  I_CmplRqRslt.CmplRqVersUUID = I_CmplRqVers.CmplRqVersUUID
                            and I_CmplRqVers.CmplRqApplicationComponent = 'DG'
{
  key I_CmplRqRslt.ChmlCmplncInfoUUID,
  key max( I_CmplRqRslt.CmplRqRsltUUID ) as CmplRqRsltUUID  
} 
where Language = 'E'
group by I_CmplRqRslt.ChmlCmplncInfoUUID 
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLT",
"I_CMPLRQRSLTDNGRSGDSBSCDESCT",
"I_CMPLRQVERS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More