DEMO_CDS_EXPOSE_ASSOC_VE

DDL: DEMO_CDS_EXPOSE_ASSOC_VE Type: view_entity

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

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
scarr scarr from

Annotations (1)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (5)

KeyFieldSource TableSource FieldDescription
_spfli _spfli
KEY scarr_carrid scarr carrid
_sflight _spfli _sflight
carrid _spfli carrid
connid _spfli connid 
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity DEMO_CDS_EXPOSE_ASSOC_VE
  as select from scarr
  association of one to many demo_cds_assoc_spfli as _spfli 
    on scarr.carrid = _spfli.carrid
{
      _spfli,
  key scarr.carrid as scarr_carrid,
      _spfli._sflight,
      _spfli.carrid,
      _spfli.connid  
}
/*+[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