ddddls_viewstack_object_names

DDL: DDDDLS_VIEWSTACK_OBJECT_NAMES Type: view_entity

ddddls_viewstack_object_names is a CDS View in SAP S/4HANA. It reads from 3 data sources (ddldependency, ddldependency, ddddlsrc) and exposes 6 fields.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
ddldependency dep_db_view left_outer
ddldependency dep_entity inner
ddddlsrc src from

Fields (6)

KeyFieldSource TableSource FieldDescription
CDS_DDL ddddlsrc ddlname Name des DDL Quelltextes für die CDS-Datendefinition
CDS_ENTITY ddldependency objectname Name der CDS-Entität
objectnameendasCDS_DB_VIEW Name der SQL-View der CDS-Entität
CDS_PARENT_VIEW ddddlsrc parentname Name der Basis CDS-Entität für CDS-View-Erweiterungen
CDS_OBJECT_TYPE ddddlsrc source_type Typ des CDS-Objekts (View, Extend, Tabellenfunktion, ...)
STATE ddddlsrc as4local Aktivierungsstand des CDS-Objekts 


define view  entity ddddls_viewstack_object_names
  as select from    ddddlsrc      as src
    inner join      ddldependency as dep_entity  on  src.ddlname           = dep_entity.ddlname
                                                 and src.as4local          = dep_entity.state
                                                 and dep_entity.objecttype = 'STOB'

    left outer join ddldependency as dep_db_view on  src.ddlname            = dep_db_view.ddlname
                                                 and src.as4local           = dep_db_view.state
                                                 and dep_db_view.objecttype = 'VIEW'
{
  @EndUserText.label: 'Name des DDL Quelltextes für die CDS-Datendefinition'
  src.ddlname            as CDS_DDL,
  @EndUserText.label: 'Name der CDS-Entität'
  dep_entity.objectname  as CDS_ENTITY,
  @EndUserText.label: 'Name der SQL-View der CDS-Entität'
  case  when dep_db_view.objectname is not initial then dep_db_view.objectname
        else dep_entity.objectname end 
   as CDS_DB_VIEW,
  @EndUserText.label: 'Name der Basis CDS-Entität für CDS-View-Erweiterungen'
  src.parentname         as CDS_PARENT_VIEW,
  @EndUserText.label: 'Typ des CDS-Objekts (View, Extend, Tabellenfunktion, ...)'
  src.source_type        as CDS_OBJECT_TYPE,
  @EndUserText.label: 'Aktivierungsstand des CDS-Objekts'
  src.as4local           as STATE
}
where src.as4local = 'A'

Learn More