DEMO_CDS_CROSS_JOIN_VE

DDL: DEMO_CDS_CROSS_JOIN_VE Type: view_entity
6 Fields 2 Data Sources

CDS view entity with a cross join

DEMO_CDS_CROSS_JOIN_VE is a CDS View that provides data about "CDS view entity with a cross join" in SAP S/4HANA. It reads from 2 data sources (t000, t100) and exposes 6 fields with key field mandt.

Data Sources (2)

SourceAliasJoin Type
t000 t000 from
t100 t100 cross

Annotations (1)

NameValueLevelField
EndUserText.label CDS view entity with a cross join view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY mandt t000 mandt Editing Client
mtext t000 mtext Text
sprsl t100 sprsl Language Code
arbgb t100 arbgb Message ID
msgnr t100 msgnr Message
text t100 text User Group

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_CROSS_JOIN_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_CROSS_JOIN_VE AS
SELECT
  t000.mandt AS mandt,
  t000.mtext AS mtext,
  t100.sprsl AS sprsl,
  t100.arbgb AS arbgb,
  t100.msgnr AS msgnr,
  t100.text AS text
FROM t000
CROSS JOIN t100
;

Learn More