DDCDS_BASE_OBJECTS

DDL: DDCDS_BASE_OBJECTS Type: view_entity
7 Fields 3 Data Sources 1 Associations

Hierarchy of CDS VIEWS

DDCDS_BASE_OBJECTS is a CDS View that provides data about "Hierarchy of CDS VIEWS" in SAP S/4HANA. It reads from 3 data sources (ddcds_fromclause, DDCDS_VIEW_FROM_STOB, DDCDS_VIEW_FROM_STOB) and exposes 7 fields. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
ddcds_fromclause _hierarchy union
DDCDS_VIEW_FROM_STOB trinity from
DDCDS_VIEW_FROM_STOB trinity union

Associations (1)

CardinalityTargetAliasCondition
[1..1] DDCDS_VIEW_FROM_STOB _view_to_stobname _view_to_stobname.viewname = _joins.tabname

Annotations (2)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Hierarchy of CDS VIEWS view

Fields (7)

KeyFieldSource TableSource FieldDescription
source DDCDS_VIEW_FROM_STOB stobname Object name
target dd08b strucobjn_t Value
target _joins tabname Value
type
target Value
type
name

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 DDCDS_BASE_OBJECTS.
-- 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 DDCDS_BASE_OBJECTS AS
SELECT
  trinity.stobname AS source,
  dd08b.strucobjn_t AS target,
  'from' AS type,
  'child2parent' AS name
FROM DDCDS_VIEW_FROM_STOB AS trinity
LEFT OUTER JOIN DDCDS_VIEW_FROM_STOB AS _view_to_stobname ON _view_to_stobname.viewname = _joins.tabname  -- association [1..1]
-- UNION with additional select branch(es): DDCDS_VIEW_FROM_STOB, ddcds_fromclause
;

Learn More