rsodp_abap_cds_odpname_sql

DDL: RSODP_ABAP_CDS_ODPNAME_SQL Type: view_entity
11 Fields 4 Data Sources

Derive ODP Name from SQL View

rsodp_abap_cds_odpname_sql is a CDS View that provides data about "Derive ODP Name from SQL View" in SAP S/4HANA. It reads from 4 data sources (ddldependency, ddldependency, ddddlsrc, tadir) and exposes 11 fields with key field cdsViewName.

Data Sources (4)

SourceAliasJoin Type
ddldependency d1 inner
ddldependency d2 inner
ddddlsrc s from
tadir t inner

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Derive ODP Name from SQL View view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY cdsViewName ddldependency objectname Object name
ddlName ddddlsrc ddlname DDL Source Name
sourceType ddddlsrc source_type SRVC Source Type
odpName ddldependency objectname Object name
length
devClass tadir devclass Package (Obsolete)
createdOnDate tadir created_on Variant created on
changedAtDate ddddlsrc as4date Date
changedAtTime ddddlsrc as4time Time
changedBy ddddlsrc as4user Person Respons.
_changedBy _changedBy

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 rsodp_abap_cds_odpname_sql.
-- 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 rsodp_abap_cds_odpname_sql AS
SELECT
  d1.objectname AS cdsViewName,
  s.ddlname AS ddlName,
  s.source_type AS sourceType,
  d2.objectname AS odpName,
  length( d2.objectname ) AS length,
  t.devclass AS devClass,
  t.created_on AS createdOnDate,
  s.as4date AS changedAtDate,
  s.as4time AS changedAtTime,
  s.as4user AS changedBy
FROM ddddlsrc AS s
INNER JOIN tadir AS t ON /* join condition not captured in parsed metadata */
INNER JOIN ddldependency AS d1 ON /* join condition not captured in parsed metadata */
INNER JOIN ddldependency AS d2 ON /* join condition not captured in parsed metadata */
;

Learn More