DEMO_CDS_VIEW_KEY

DDL: DEMO_CDS_VIEW_KEY SQL: DEMOCDSKEY Type: view Package: SABAP_DEMOS_ABAP_CDS_CLOUD
4 Fields 1 Data Sources

CDS view with non-unique key

DEMO_CDS_VIEW_KEY is a CDS View that provides data about "CDS view with non-unique key" in SAP S/4HANA. It reads from 1 data source (spfli) and exposes 4 fields with key fields cityfrom, cityto. Part of development package SABAP_DEMOS_ABAP_CDS_CLOUD.

Data Sources (1)

SourceAliasJoin Type
spfli spfli from

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName DEMOCDSKEY view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY cityfrom cityfrom Departure City
KEY cityto cityto Destination City
carrid carrid Carrier
connid connid Flight Number

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view DEMO_CDS_VIEW_KEY.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: DEMOCDSKEY

CREATE VIEW DEMO_CDS_VIEW_KEY AS
SELECT
  cityfrom,
  cityto,
  carrid,
  connid
FROM spfli
;

Learn More