What is DEMO_CDS_EXPOSE_ASSOC_VE in SAP S/4HANA?

DEMO_CDS_EXPOSE_ASSOC_VE is a cds CDS view in SAP S/4HANA. It contains 5 fields.

Which tables does DEMO_CDS_EXPOSE_ASSOC_VE read from?

DEMO_CDS_EXPOSE_ASSOC_VE reads data from: scarr.

DEMO_CDS_EXPOSE_ASSOC_VE

DDL: DEMO_CDS_EXPOSE_ASSOC_VE Type: view_entity

5 Fields 1 Data Sources

DEMO_CDS_EXPOSE_ASSOC_VE is a CDS View in SAP S/4HANA. It reads from 1 data source (scarr) and exposes 5 fields with key field scarr_carrid.

Data Sources (1)

Source	Alias	Join Type
scarr	scarr	from

Annotations (1)

Name	Value	Level	Field
AccessControl.authorizationCheck	#NOT_REQUIRED	view

Fields (5)

Key	Field	Source Table	Source Field	Description
	_spfli		_spfli
KEY	scarr_carrid	scarr	carrid	Carrier
	_sflight	_spfli	_sflight
	carrid	_spfli	carrid	Carrier
	connid	_spfli	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_EXPOSE_ASSOC_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_EXPOSE_ASSOC_VE AS
SELECT
  scarr.carrid AS scarr_carrid,
  _spfli._sflight AS _sflight,
  _spfli.carrid AS carrid,
  _spfli.connid AS connid
FROM scarr
;

Depth:

DEMO_CDS_EXPOSE_ASSOC_VE view_entity

scarr