DEMO_CDS_WRONG_TO_ONE_3_VE

DDL: DEMO_CDS_WRONG_TO_ONE_3_VE Type: view_entity
1 Fields 1 Data Sources

CDS view entity with join expression

DEMO_CDS_WRONG_TO_ONE_3_VE is a CDS View that provides data about "CDS view entity with join expression" in SAP S/4HANA. It reads from 1 data source (scarr) and exposes 1 field.

Data Sources (1)

SourceAliasJoin Type
scarr c from

Annotations (1)

NameValueLevelField
EndUserText.label CDS view entity with join expression view

Fields (1)

KeyFieldSource TableSource FieldDescription
cnt

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_3_VE.
-- 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.

CREATE VIEW DEMO_CDS_WRONG_TO_ONE_3_VE AS
SELECT
  count(*) AS cnt
FROM scarr AS c
;

Learn More