demo_cds_scarr_spfli

DDL: DEMO_CDS_SCARR_SPFLI SQL: DEMO_CDS_JOIN Type: view

demo_cds_scarr_spfli is a CDS View in SAP S/4HANA. It reads from 1 data source (spfli) and exposes 5 fields with key fields carrid, carrname, connid.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
spfli spfli from

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName DEMO_CDS_JOIN view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY carrid spfli carrid
KEY carrname scarr carrname
KEY connid spfli connid
cityfrom spfli cityfrom
cityto spfli cityto 
@AbapCatalog.sqlViewName: 'DEMO_CDS_JOIN'
@AccessControl.authorizationCheck: #NOT_ALLOWED
define view demo_cds_scarr_spfli(
    id,
    carrier,
    flight,
    departure,
    destination
  )
  as select from spfli
    join         scarr on scarr.carrid = spfli.carrid
{
  key spfli.carrid,
  key scarr.carrname,
  key spfli.connid,
      spfli.cityfrom,
      spfli.cityto
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SCARR",
"SPFLI"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More