ddddls_viewstack_union

DDL: DDDDLS_VIEWSTACK_UNION Type: view_entity

Viewstack Union

ddddls_viewstack_union is a CDS View that provides data about "Viewstack Union" in SAP S/4HANA. It reads from 7 data sources and exposes 7 fields with key fields dep_ddlname, dep_name, dep_sql_name, CDS_DDLasdep_ddlname, dep_name.

Data Sources (7)

SourceAliasJoin Type
ddddls_viewstack_object_names baseobj_join left_outer
ddddls_viewstack_object_names baseobj_join left_outer
dd02l dd02l left_outer
dd26s dd26s from
ddcds_fromclause ddcds_fromclause union
ddddls_viewstack_object_names dep_join left_outer
ddddls_viewstack_object_names dep_join left_outer

Annotations (2)

NameValueLevelField
EndUserText.label Viewstack Union view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY dep_ddlname ddddls_viewstack_object_names CDS_DDL DDL Source Name
KEY dep_name ddddls_viewstack_object_names CDS_ENTITY Table Name
KEY dep_sql_name dd26s viewname Table Name
KEY CDS_DDLasdep_ddlname
KEY dep_name ddcds_fromclause entity_name Table Name
KEY dep_sql_name ddcds_fromclause entity_name Table Name
KEY baseobj_name ddcds_fromclause base_obj_name Object 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 ddddls_viewstack_union.
-- 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 ddddls_viewstack_union AS
SELECT
  dep_join.CDS_DDL AS dep_ddlname,
  dep_join.CDS_ENTITY AS dep_name,
  dd26s.viewname AS dep_sql_name,
  cast( case when baseobj_join.CDS_OBJECT_TYPE is not initial then case baseobj_join.CDS_OBJECT_TYPE when 'V' then 'STOB' when 'W' then 'STVE' when 'A' then 'STAE' when 'C' then 'STCU' when 'T' then 'STTE' when 'F' then 'STTF' when 'P' then 'STPR' when 'H' then 'STHI' else baseobj_join.CDS_OBJECT_TYPE end else dd02l.tabclass end as abap.char(10) ) as baseobj_objtype AS CDS_DDLasdep_ddlname,
  ddcds_fromclause.base_obj_name AS baseobj_name
FROM dd26s
LEFT OUTER JOIN ddddls_viewstack_object_names AS dep_join ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddddls_viewstack_object_names AS baseobj_join ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02l ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): ddcds_fromclause
;