demo_cds_wrong_to_one_2

DDL: DEMO_CDS_WRONG_TO_ONE_2 SQL: DEMOCDSWTO2 Type: view
2 Fields 1 Data Sources

demo_cds_wrong_to_one_2 is a CDS View in SAP S/4HANA. It reads from 1 data source (scarr) and exposes 2 fields.

Data Sources (1)

SourceAliasJoin Type
scarr c from

Annotations (1)

NameValueLevelField
AbapCatalog.sqlViewName DEMOCDSWTO2 view

Fields (2)

KeyFieldSource TableSource FieldDescription
carrid scarr carrid Carrier
carrname scarr carrname Carrier

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_wrong_to_one_2.
-- 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: DEMOCDSWTO2

CREATE VIEW demo_cds_wrong_to_one_2 AS
SELECT
  c.carrid AS carrid,
  c.carrname AS carrname
FROM scarr AS c
;

Learn More