dbc2abap_cds_elements

DDL: DBC2ABAP_CDS_ELEMENTS Type: view_entity

CDS Entities in SQL1 Service Bindings

dbc2abap_cds_elements is a CDS View that provides data about "CDS Entities in SQL1 Service Bindings" in SAP S/4HANA. It reads from 3 data sources (DDCDS_ENTITY_ELEMENTS_INTERN, sql1_head, srvd_rt_entities_direct) and exposes 5 fields with key fields ExposedAliasendasexternal_entity_name, element_name.

Data Sources (3)

SourceAliasJoin Type
DDCDS_ENTITY_ELEMENTS_INTERN elem inner
sql1_head sql1 from
srvd_rt_entities_direct srvd inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label CDS Entities in SQL1 Service Bindings 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 ExposedAliasendasexternal_entity_name
KEY element_name DDCDS_ENTITY_ELEMENTS_INTERN element_name Element Name
is_key DDCDS_ENTITY_ELEMENTS_INTERN is_key Key field
ddic_type DDCDS_ENTITY_ELEMENTS_INTERN data_type_d
ddic_length DDCDS_ENTITY_ELEMENTS_INTERN length Text Length

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 dbc2abap_cds_elements.
-- 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 dbc2abap_cds_elements AS
SELECT
  case when srvd.ExposedAlias = ' ' then srvd.ExposedArtifact else srvd.ExposedAlias end as external_entity_name AS ExposedAliasendasexternal_entity_name,
  elem.element_name AS element_name,
  elem.is_key AS is_key,
  elem.data_type_d AS ddic_type,
  elem.length AS ddic_length
FROM sql1_head AS sql1
INNER JOIN srvd_rt_entities_direct AS srvd ON /* join condition not captured in parsed metadata */
INNER JOIN DDCDS_ENTITY_ELEMENTS_INTERN AS elem ON /* join condition not captured in parsed metadata */
;