DEMO_CDS_EXPOSE_ASSOC_FILTER

DDL: DEMO_CDS_EXPOSE_ASSOC_FILTER Type: view_entity

DEMO_CDS_EXPOSE_ASSOC_FILTER is a CDS View in SAP S/4HANA. It reads from 1 data source (scarr) and exposes 7 fields with key field scarr_carrid.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
scarr scarr from

Annotations (1)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
airline
KEY scarr_carrid scarr carrid
_sflight
carrid
connid
airline_A
airport _spfli airpfrom 
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity DEMO_CDS_EXPOSE_ASSOC_FILTER
  as select from scarr 
  association of one to many demo_cds_assoc_spfli as _spfli  
    on scarr.carrid = _spfli.carrid 
{ 
//Association with filter condition

      _spfli[  carrid = ''  ] as airline, 
  key scarr.carrid as scarr_carrid, 
      _spfli[  carrid = ''  ]._sflight, 
      _spfli[  carrid = ''  ].carrid, 
      _spfli[  carrid = ''  ].connid,
      
//same association with different filter condition and new alias name

      _spfli[ carrid = 'A' ] as airline_A,
      _spfli.airpfrom as airport  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DEMO_CDS_ASSOC_SPFLI",
"SCARR"
],
"ASSOCIATED":
[
"DEMO_CDS_ASSOC_SPFLI",
"DEMO_CDS_SFLIGHT"
],
"BASE":
[
"DEMO_CDS_ASSOC_SPFLI"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More