demo_cds_system_fields

DDL: DEMO_CDS_SYSTEM_FIELDS SQL: DEMO_CDS_SYST Type: view
5 Fields 1 Data Sources

demo_cds_system_fields is a CDS View in SAP S/4HANA. It reads from 1 data source (demo_expressions) and exposes 5 fields.

Data Sources (1)

SourceAliasJoin Type
demo_expressions demo_expressions from

Parameters (5)

NameTypeDefault
p_mandt syst_mandt
p_datum syst_datum
p_uzeit syst_uzeit
p_langu syst_langu
p_uname syst_uname

Annotations (2)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
client
datum
uzeit
langu
uname

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_system_fields.
-- 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: DEMO_CDS_SYST
-- Parameters: p_mandt : syst_mandt, p_datum : syst_datum, p_uzeit : syst_uzeit, p_langu : syst_langu, p_uname : syst_uname

CREATE VIEW demo_cds_system_fields AS
SELECT
  :p_mandt AS client,
  :p_datum AS datum,
  :p_uzeit AS uzeit,
  :p_langu AS langu,
  :p_uname AS uname
FROM demo_expressions
;

Learn More