rsodp_abap_cds_odpname_cds

DDL: RSODP_ABAP_CDS_ODPNAME_CDS Type: view_entity

Derive ODP Name

rsodp_abap_cds_odpname_cds is a CDS View that provides data about "Derive ODP Name" in SAP S/4HANA. It reads from 6 data sources and exposes 21 fields with key field cdsViewName.

Data Sources (6)

SourceAliasJoin Type
ddheadanno h left_outer
ddheadanno h inner
ddddlsrc s from
ddddlsrc s union_all
tadir t inner
tadir t inner

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Derive ODP Name view
Metadata.ignorePropagatedAnnotations true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY cdsViewName ddddlsrc ddlname DDL Source Name
ddlName ddddlsrc ddlname DDL Source Name
sourceType ddddlsrc source_type SRVC Source Type
odpName ddddlsrc ddlname ODP 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.
ddlnameascdsViewName
ddlName ddddlsrc ddlname DDL Source Name
sourceType ddddlsrc source_type SRVC Source Type
odpName
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_cds.
-- 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_cds AS
SELECT
  s.ddlname AS cdsViewName,
  s.ddlname AS ddlName,
  s.source_type AS sourceType,
  s.ddlname AS odpName,
  length( s.ddlname ) 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 */
LEFT OUTER JOIN ddheadanno AS h ON /* join condition not captured in parsed metadata */
INNER JOIN ddheadanno AS h ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): ddddlsrc
;