dhadm_cds_all_ddic_obj

DDL: DHADM_CDS_ALL_DDIC_OBJ Type: view_entity Package: SADI_ADM_CDS

All Tables, Views and Data Definitions

dhadm_cds_all_ddic_obj is a CDS View that provides data about "All Tables, Views and Data Definitions" in SAP S/4HANA. It reads from 6 data sources and exposes 5 fields with key fields objtype, objname, objname, objname. Part of development package SADI_ADM_CDS.

Data Sources (6)

SourceAliasJoin Type
ddddlsrc d from
dd02l d union_all
dd25l d union_all
ddddlsrct t left_outer
dd02t t left_outer
dd25t t left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label All Tables, Views and Data Definitions view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY objtype
KEY objname
KEY objname
KEY objname
description dd25t ddtext Short text

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 dhadm_cds_all_ddic_obj.
-- 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 dhadm_cds_all_ddic_obj AS
SELECT
  cast( 'DDLS' as trobjtype ) AS objtype,
  cast( d.ddlname as ddobjname ) AS objname,
  t.ddtext AS description
FROM ddddlsrc AS d
LEFT OUTER JOIN ddddlsrct AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02t AS t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd25t AS t ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): dd02l, dd25l
;