dhamb_base_dp_view

DDL: DHAMB_BASE_DP_VIEW Type: view_entity

DI meta data browser: list of DDIC views

dhamb_base_dp_view is a CDS View that provides data about "DI meta data browser: list of DDIC views" in SAP S/4HANA. It reads from 8 data sources and exposes 10 fields.

Data Sources (8)

SourceAliasJoin Type
dhamb_base_dp_view_cds cds left_outer
dd02l dd02l inner
dd25t dd25t left_outer
dd26s dd26s left_outer
df14l df14l left_outer
df14t df14t left_outer
tadir tadir from
tdevc tdevc inner

Parameters (1)

NameTypeDefault
iv_langu abap.lang

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label DI meta data browser: list of DDIC views view

Fields (10)

KeyFieldSource TableSource FieldDescription
objectname dd02l tabname Table/Constant Value
clidep dd02l clidep Client-specific
objectdescr dd25t ddtext Short text
devclass tadir devclass Package (Obsolete)
component df14l ps_posid WBS Element
compdescr df14t name Zone name
basetable dd26s tabname Table/Constant Value
component_id tdevc component Softw. Comp.
dlvunit tdevc dlvunit Softw. Comp.
lastchange

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 dhamb_base_dp_view.
-- 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.
-- Parameters: iv_langu : abap.lang

CREATE VIEW dhamb_base_dp_view AS
SELECT
  dd02l.tabname AS objectname,
  dd02l.clidep AS clidep,
  dd25t.ddtext AS objectdescr,
  tadir.devclass AS devclass,
  df14l.ps_posid AS component,
  df14t.name AS compdescr,
  dd26s.tabname AS basetable,
  tdevc.component AS component_id,
  tdevc.dlvunit AS dlvunit,
  concat( dd02l.as4date, dd02l.as4time ) AS lastchange
FROM tadir
INNER JOIN dd02l ON /* join condition not captured in parsed metadata */
INNER JOIN tdevc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd25t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd26s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN df14t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dhamb_base_dp_view_cds AS cds ON /* join condition not captured in parsed metadata */
;