C_ChmlCmplncInfoIdfrSearch

DDL: C_CHMLCMPLNCINFOIDFRSEARCH Type: view_entity CONSUMPTION Package: EHFND_CNS_CCIDFR

Identifier Search for CCI

C_ChmlCmplncInfoIdfrSearch is a Consumption CDS View that provides data about "Identifier Search for CCI" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncIdfr) and exposes 5 fields with key field ChmlCmplncIdfrUUID. It has 2 associations to related views. Part of development package EHFND_CNS_CCIDFR.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncIdfr I_ChmlCmplncIdfr from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ChmlCmplncIdfrValue _ChmlCmplncIdfrValue _ChmlCmplncIdfrValue.ChmlCmplncIdfrUUID = $projection.ChmlCmplncIdfrUUID and _ChmlCmplncIdfrValue.ChmlCmplncIdfrParentType = 'CCI' and ( _ChmlCmplncIdfrValue.ChmlCmplncIdfrCategory = 'NUM' or _ChmlCmplncIdfrValue.Language = $session.system_language or _ChmlCmplncIdfrValue.Language = 'E' )
[0..1] I_ChmlCmplncInfo _ChmlCmplncInfo _ChmlCmplncInfo.ChmlCmplncInfoUUID = $projection.ChmlCmplncIdfrParentUUID

Annotations (7)

NameValueLevelField
EndUserText.label Identifier Search for CCI view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncIdfrUUID ChmlCmplncIdfrUUID
ChmlCmplncIdfrParentUUID ChmlCmplncIdfrParentUUID
ChmlCmplncIdfrParentType ChmlCmplncIdfrParentType
_ChmlCmplncIdfrValue _ChmlCmplncIdfrValue
_ChmlCmplncInfo _ChmlCmplncInfo 
@EndUserText.label: 'Identifier Search for CCI'

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED

@VDM.viewType: #CONSUMPTION
@ObjectModel: {
  semanticKey: ['ChmlCmplncIdfrUUID'],
  usageType: {
    serviceQuality: #A,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
  }
}
define root view entity C_ChmlCmplncInfoIdfrSearch
  as select from I_ChmlCmplncIdfr
 
  association [0..*] to I_ChmlCmplncIdfrValue as _ChmlCmplncIdfrValue on _ChmlCmplncIdfrValue.ChmlCmplncIdfrUUID       = $projection.ChmlCmplncIdfrUUID
                                                                     and _ChmlCmplncIdfrValue.ChmlCmplncIdfrParentType = 'CCI'
                                                                     and ( _ChmlCmplncIdfrValue.ChmlCmplncIdfrCategory = 'NUM'      or 
                                                                           _ChmlCmplncIdfrValue.Language = $session.system_language or 
                                                                           _ChmlCmplncIdfrValue.Language = 'E' )
  association [0..1] to I_ChmlCmplncInfo      as _ChmlCmplncInfo      on _ChmlCmplncInfo.ChmlCmplncInfoUUID            = $projection.ChmlCmplncIdfrParentUUID

{
      key ChmlCmplncIdfrUUID    as ChmlCmplncIdfrUUID,
      ChmlCmplncIdfrParentUUID  as ChmlCmplncIdfrParentUUID,
      ChmlCmplncIdfrParentType,

      /* Associations */
      _ChmlCmplncIdfrValue,
      _ChmlCmplncInfo      
}
where
    ( ChmlCmplncIdfrProcgStatus = 'IP' or ChmlCmplncIdfrProcgStatus = 'RE' )

Learn More