dhamb_base_dp_table

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'DI meta data browser: list of DDIC tables'
define view entity dhamb_base_dp_table 
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 dd02t on
          dd02t.tabname    = tadir.obj_name and
          dd02t.ddlanguage = $parameters.iv_langu and
          dd02t.as4local   = 'A' and
          dd02t.as4vers    = '0000'
        left outer join dd09l on
          dd09l.tabname    = tadir.obj_name and
          dd09l.as4local   = 'A' and
          dd09l.as4vers    = '0000'
        left outer join df14l on
          df14l.fctr_id    = tdevc.component and
          df14l.as4local   = 'A'
        left outer join df14t on
          df14t.fctr_id    = tdevc.component and
          df14t.langu      = $parameters.iv_langu and
          df14t.as4local   = 'A'

{
        dd02l.tabname   as objectname,
        dd02l.clidep    as clidep,
        dd02t.ddtext    as objectdescr,
        dd02l.contflag  as contflag,
        dd09l.tabart    as tabart,
        tadir.devclass  as devclass,
        df14l.ps_posid  as component,
        df14t.name      as compdescr,
        tdevc.component as component_id,
        tdevc.dlvunit   as dlvunit,
        concat( dd02l.as4date, dd02l.as4time ) as lastchange
  
}
where tadir.pgmid    = 'R3TR' 
  and tadir.object   = 'TABL'
  and dd02l.as4local = 'A' 
  and dd02l.as4vers  = '0000'
  and ( dd02l.tabclass = 'TRANSP'
     or dd02l.tabclass = 'POOL'
     or dd02l.tabclass = 'CLUSTER' )
  and dd02l.is_gtt   = ' '


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD02L",
"DD02T",
"DD09L",
"DF14L",
"DF14T",
"TADIR",
"TDEVC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/