DHADM_CDS_ENTITY_EXTENDS

DDL: DHADM_CDS_ENTITY_EXTENDS Type: view_entity Package: SADI_ADM_CDS
4 Fields 2 Data Sources

All CDS Entities

DHADM_CDS_ENTITY_EXTENDS is a CDS View that provides data about "All CDS Entities" in SAP S/4HANA. It reads from 2 data sources (ddddlsrc, ddddlsrct) and exposes 4 fields with key fields parentname, ddlname. Part of development package SADI_ADM_CDS.

Data Sources (2)

SourceAliasJoin Type
ddddlsrc d from
ddddlsrct t left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label All CDS Entities view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY parentname ddddlsrc parentname Source Parent
KEY ddlname ddddlsrc ddlname DDL Source Name
source_type ddddlsrc source_type SRVC Source Type
ddtext ddddlsrct 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_ENTITY_EXTENDS.
-- 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_ENTITY_EXTENDS AS
SELECT
  d.parentname AS parentname,
  d.ddlname AS ddlname,
  d.source_type AS source_type,
  t.ddtext AS ddtext
FROM ddddlsrc AS d
LEFT OUTER JOIN ddddlsrct AS t ON /* join condition not captured in parsed metadata */
;

Learn More