DEMO_RAP_EXTENSIBLE_ROOT

DDL: DEMO_RAP_EXTENSIBLE_ROOT Type: view_entity
8 Fields 1 Data Sources

CDS root view entity, extensibility demo

DEMO_RAP_EXTENSIBLE_ROOT is a CDS View that provides data about "CDS root view entity, extensibility demo" in SAP S/4HANA. It reads from 1 data source (demo_dbtab_root) and exposes 8 fields with key field KeyField.

Data Sources (1)

SourceAliasJoin Type
demo_dbtab_root demo_dbtab_root from

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS root view entity, extensibility demo view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY KeyField demo_dbtab_root key_field Key field
DataField demo_dbtab_root data_field
CharField demo_dbtab_root char_field
CharField2 demo_dbtab_root char_field_2
DecField demo_dbtab_root dec_field
Timestamp demo_dbtab_root crea_date_time Time Stamp
LastChangedAt demo_dbtab_root lchg_date_time Time Stamp
_child _child

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_RAP_EXTENSIBLE_ROOT.
-- 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_RAP_EXTENSIBLE_ROOT AS
SELECT
  demo_dbtab_root.key_field AS KeyField,
  demo_dbtab_root.data_field AS DataField,
  demo_dbtab_root.char_field AS CharField,
  demo_dbtab_root.char_field_2 AS CharField2,
  demo_dbtab_root.dec_field AS DecField,
  demo_dbtab_root.crea_date_time AS Timestamp,
  demo_dbtab_root.lchg_date_time AS LastChangedAt
FROM demo_dbtab_root
;

Learn More