P_BasicDescForReldRglnMaxCRR

DDL: P_BASICDESCFORRELDRGLNMAXCRR Type: view COMPOSITE Package: EHDGM_CNS_UNPACKAGED_PRODUCT

Basic Description For Reld Reg Max Compl Requirment Results

P_BasicDescForReldRglnMaxCRR is a Composite CDS View that provides data about "Basic Description For Reld Reg Max Compl Requirment Results" in SAP S/4HANA. It reads from 2 data sources (I_CmplRqRslt, I_CmplRqRsltDngrsGdsBscDescT) and exposes 2 fields with key fields ChmlCmplncInfoUUID, CmplRqRsltUUID. Part of development package EHDGM_CNS_UNPACKAGED_PRODUCT.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_CmplRqRslt I_CmplRqRslt inner
I_CmplRqRsltDngrsGdsBscDescT I_CmplRqRsltDngrsGdsBscDescT from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PDGBDSCFRRMCRR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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

@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'    
{
  key I_CmplRqRslt.ChmlCmplncInfoUUID,
  key max( I_CmplRqRslt.CmplRqRsltUUID ) as CmplRqRsltUUID  
} 
where I_CmplRqRsltDngrsGdsBscDescT.Language = 'E'
group by I_CmplRqRslt.ChmlCmplncInfoUUID

Learn More