DDCDS_BOE_VIEWSTACK_INFO

DDL: DDCDS_BOE_VIEWSTACK_INFO SQL: DDCDSBOEINF Type: view

View stack heirarchy using entity names

DDCDS_BOE_VIEWSTACK_INFO is a CDS View that provides data about "View stack heirarchy using entity names" in SAP S/4HANA. It reads from 3 data sources (DDL_OBJECT_NAMES, dd26s, DDL_OBJECT_NAMES) and exposes 5 fields with key fields dep_viewname, dep_objtype, tab_viewname, CDS_ENTITYendastab_entityname, tab_objtype.

Data Sources (3)

SourceAliasJoin Type
DDL_OBJECT_NAMES baseobj_join left_outer
dd26s dd26s from
DDL_OBJECT_NAMES dep_join left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName DDCDSBOEINF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label View stack heirarchy using entity names view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY dep_viewname viewname View Name
KEY dep_objtype DDL_OBJECT_NAMES CDS_OBJECT_TYPE SRVC Source Type
KEY tab_viewname tabname Table/Constant Value
KEY CDS_ENTITYendastab_entityname
KEY tab_objtype DDL_OBJECT_NAMES CDS_OBJECT_TYPE SRVC Source Type

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.
-- 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: DDCDSBOEINF

CREATE VIEW DDCDS_BOE_VIEWSTACK_INFO AS
SELECT
  viewname AS dep_viewname,
  dep_join.CDS_OBJECT_TYPE AS dep_objtype,
  tabname AS tab_viewname,
  case when baseobj_join.CDS_DB_VIEW is null then tabname else baseobj_join.CDS_ENTITY end as tab_entityname AS CDS_ENTITYendastab_entityname,
  baseobj_join.CDS_OBJECT_TYPE AS tab_objtype
FROM dd26s
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 */
;