DEMO_CDS_EXPOSE_ASSOC

DDL: DEMO_CDS_EXPOSE_ASSOC Type: view_entity Package: SABAP_DEMOS_ABAP_LANGU_CLOUD

CDS view entity, expose associations in SELECT list

DEMO_CDS_EXPOSE_ASSOC is a CDS View that provides data about "CDS view entity, expose associations in SELECT list" in SAP S/4HANA. It reads from 1 data source (scarr) and exposes 5 fields with key field scarr_carrid. It has 1 association to related views. Part of development package SABAP_DEMOS_ABAP_LANGU_CLOUD.

Data Sources (1)

SourceAliasJoin Type
scarr scarr from

Associations (1)

CardinalityTargetAliasCondition
[1..*] demo_cds_assoc_spfli _spfli scarr.carrid = _spfli.carrid

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
  as select from scarr
  association [1..*] to demo_cds_assoc_spfli as _spfli 
    on scarr.carrid = _spfli.carrid
{
      _spfli,
  key scarr.carrid as scarr_carrid,
      _spfli._sflight,
      _spfli.carrid,
      _spfli.connid  
}