DDCDS_BOE_VIEWSTACK_INFO_UNION

DDL: DDCDS_BOE_VIEWSTACK_INFO_UNION SQL: DDCDSBOEVWUNION Type: view

Union of dd26s and ddcds_fromclause data

DDCDS_BOE_VIEWSTACK_INFO_UNION is a CDS View that provides data about "Union of dd26s and ddcds_fromclause data" in SAP S/4HANA. It reads from 5 data sources (DDL_OBJECT_NAMES, DDCDS_BOE_VIEWSTACK_INFO, ddcds_fromclause, DDL_OBJECT_NAMES, DDL_OBJECT_NAMES) and exposes 5 fields with key fields dep_name, dep_objtype, dep_objtype, baseobj_name. It has 1 association to related views.

Data Sources (5)

SourceAliasJoin Type
DDL_OBJECT_NAMES baseobj_join left_outer
DDCDS_BOE_VIEWSTACK_INFO DDCDS_BOE_VIEWSTACK_INFO from
ddcds_fromclause ddcds_fromclause union
DDL_OBJECT_NAMES DDL_OBJECT_NAMES left_outer
DDL_OBJECT_NAMES dep_join left_outer

Associations (1)

CardinalityTargetAliasCondition
[*] DDCDS_BOE_VIEWSTACK_INFO_UNION _Parent $projection.dep_name = _Parent.baseobj_name

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName DDCDSBOEVWUNION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Union of dd26s and ddcds_fromclause data view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY dep_name dep_entityname CDS-Entity
KEY dep_objtype dep_objtype SRVC Source Type
KEY dep_objtype DDL_OBJECT_NAMES CDS_OBJECT_TYPE SRVC Source Type
KEY baseobj_name base_obj_name Object Name
_Parent _Parent

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_BOE_VIEWSTACK_INFO_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.
-- SQL view name: DDCDSBOEVWUNION

CREATE VIEW DDCDS_BOE_VIEWSTACK_INFO_UNION AS
SELECT
  dep_entityname AS dep_name,
  dep_objtype,
  base_obj_name AS baseobj_name
FROM DDCDS_BOE_VIEWSTACK_INFO
LEFT OUTER JOIN DDL_OBJECT_NAMES ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DDL_OBJECT_NAMES AS dep_join ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DDL_OBJECT_NAMES AS baseobj_join ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN DDCDS_BOE_VIEWSTACK_INFO_UNION AS _Parent ON dep_name = _Parent.baseobj_name  -- association [*]
-- UNION with additional select branch(es): ddcds_fromclause
;