demo_cds_assoc_where

DDL: DEMO_CDS_ASSOC_WHERE Type: view_entity Package: SABAP_DEMOS_ABAP_CDS_CLOUD

CDS view entity, WHERE condition using an association

demo_cds_assoc_where is a CDS View that provides data about "CDS view entity, WHERE condition using an association" in SAP S/4HANA. It reads from 1 data source (scarr) and exposes 2 fields with key field carrid. It has 1 association to related views. Part of development package SABAP_DEMOS_ABAP_CDS_CLOUD.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
scarr scarr from

Associations (1)

CardinalityTargetAliasCondition
[1..1] demo_cds_assoc_spfli _spfli scarr.carrid = _spfli.carrid and _spfli.connid = '....'

Annotations (1)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY carrid carrid
carrname carrname 
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity demo_cds_assoc_where
  as select from scarr
  association [1..1] to demo_cds_assoc_spfli as _spfli 
    on  scarr.carrid = _spfli.carrid and _spfli.connid = '....'
{
  key carrid, 
      carrname
} where _spfli.connid = '....'

Learn More