sdsh_ddl_obj_names

DDL: SDSH_DDL_OBJ_NAMES SQL: SSHDDLOBJNAMESV Type: view

List of all cds entities

sdsh_ddl_obj_names is a CDS View that provides data about "List of all cds entities" 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

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SSHDDLOBJNAMESV view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label List of all cds entities view

Fields (6)

KeyFieldSource TableSource FieldDescription
CDS_DDL ddddlsrc ddlname
CDS_ENTITY ddldependency objectname
CDS_DB_VIEW ddldependency objectname
CDS_PARENT_VIEW ddddlsrc parentname
CDS_OBJECT_TYPE ddddlsrc source_type
STATE ddddlsrc as4local 
@AbapCatalog.sqlViewName: 'SSHDDLOBJNAMESV'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'List of all cds entities '
define view sdsh_ddl_obj_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'
{
  src.ddlname            as CDS_DDL,
  dep_entity.objectname  as CDS_ENTITY,
  dep_db_view.objectname as CDS_DB_VIEW,
  src.parentname         as CDS_PARENT_VIEW,
  src.source_type        as CDS_OBJECT_TYPE,
  src.as4local           as STATE
  }
  //Correction for only list of cds views

//  define view DDL_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'

//   inner join dd02bnd as tf on src.ddlname = tf.strucobjn 

//                               and tf.with_parameters <> 'X'

//                                                 

//{

//  src.ddlname            as CDS_DDL,

//  dep_entity.objectname  as CDS_ENTITY,

//  dep_db_view.objectname as CDS_DB_VIEW,

//  src.parentname         as CDS_PARENT_VIEW,

//  src.source_type        as CDS_OBJECT_TYPE,

//  src.as4local           as STATE

//}

//where  src.as4local = 'A'

//       and src.source_type = 'V' 

//       or src.source_type =  'E'

  

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDDDLSRC",
"DDLDEPENDENCY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More