dhamb_base_dp_view

DDL: DHAMB_BASE_DP_VIEW Type: view_entity Package: LT_DHAMB_BASE

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. Part of development package LT_DHAMB_BASE.

8 data source(s) 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
clidep dd02l clidep
objectdescr dd25t ddtext
devclass tadir devclass
component df14l ps_posid
compdescr df14t name
basetable dd26s tabname
component_id tdevc component
dlvunit tdevc dlvunit
lastchange 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'DI meta data browser: list of DDIC views'
define view entity dhamb_base_dp_view 
with parameters iv_langu: abap.lang
as select from tadir
        inner join dd02l on
          dd02l.tabname    = tadir.obj_name
        inner join tdevc on
          tdevc.devclass   = tadir.devclass
        left outer join dd25t on
          dd25t.viewname   = tadir.obj_name and
          dd25t.ddlanguage = $parameters.iv_langu and
          dd25t.as4local   = 'A' and
          dd25t.as4vers    = '0000'
        left outer join dd26s on
          dd26s.viewname   = tadir.obj_name and
          dd26s.as4local   = 'A' and
          dd26s.as4vers    = '0000' and
          dd26s.tabpos     = '0001'
        left outer join df14l on
          df14l.fctr_id    = tdevc.component
        left outer join df14t on
          df14t.fctr_id    = tdevc.component and
          df14t.langu      = $parameters.iv_langu and
          df14t.as4local   = 'A'
        left outer join dhamb_base_dp_view_cds as cds on
          cds.objectname = tadir.obj_name

{
        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
  
}
where tadir.pgmid    = 'R3TR'
  and tadir.object   = 'VIEW'
  and dd02l.as4local = 'A' 
  and dd02l.as4vers  = '0000'
  and dd02l.tabclass = 'VIEW'
  and ( dd02l.viewclass = 'D'
     or dd02l.viewclass = 'P' )
  and ( cds.cnt is null or cds.cnt <= 0 )

Learn More