DDDDLS_VIEWSTACK_OBJECT_NAMES

CDS View

DDDDLS_VIEWSTACK_OBJECT_NAMES is a CDS View in S/4HANA. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ddddls_viewstack_union view_entity left_outer Viewstack Union

Fields (3)

KeyField CDS FieldsUsed in Views
KEY CDS_DB_VIEW baseobj_sql_name 1
KEY CDS_DDL baseobj_ddlname,dep_ddlname 1
KEY CDS_ENTITY dep_name 1 


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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDDDLSRC",
"DDLDEPENDENCY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More