DDL_OBJECT_NAMES

CDS View

Zuordnung der Namen eines CDS-Objekts

DDL_OBJECT_NAMES is a CDS View in S/4HANA. Zuordnung der Namen eines CDS-Objekts. It contains 2 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 2 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
APS_V_CKE_USAGES_BY_CUST_VIEWS view inner List of views which are used by custom CDS Views
APS_V_GKE_VIEW_LIST_DRAFT view left_outer List of draft Custom CDS views
APS_V_GKE_VIEW_LIST_INACTIVE view left_outer List of inactive Custom CDS views
APS_V_GKE_VIEW_LIST_RELEASED view left_outer List of released CDS views)
Ars_V_Ddls_Extensions view_entity from API Release: CDS Extensions (DDLS)
Ars_V_Ddls_Extensions view_entity inner API Release: CDS Extensions (DDLS)
I_CCV_USAGES_BY_CCV view inner CCV Rework - Views which are used by CCV
I_CustomCDSViewDatasource_VH view_entity left_outer BASIC List of released CDS views

Fields (2)

KeyField CDS FieldsUsed in Views
KEY CDS_ENTITY cds_entity,view_name_2 3
CDS_DDL ddl_name 2 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Zuordnung der Namen eines CDS-Objekts'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #META

define view entity DDL_OBJECT_NAMES
  as select from                ddddlsrc      as src
    left outer many to one join ddldependency as dep_entity  on  src.ddlname           = dep_entity.ddlname
                                                             and src.as4local          = dep_entity.state
                                                             and dep_entity.objecttype = 'STOB'
    left outer many to one 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'
  -- Text
  association [0..1] to ddddlsrct as _text_active  on  _text_active.ddlname    = src.ddlname
                                                   and _text_active.as4local   = src.as4local
                                                   and _text_active.ddlanguage = $session.system_language
  -- Text English
  association [0..1] to ddddlsrct as _text_english on  _text_english.ddlname    = src.ddlname
                                                   and _text_english.as4local   = src.as4local
                                                   and _text_english.ddlanguage = 'E'

{
  @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,
  //  case when dep_entity.objectname is initial then src.ddlname else  dep_entity.objectname end as CDS_ENTITY,

  @EndUserText.label: 'Name der SQL-View der CDS-Entität'
  dep_db_view.objectname                                        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,
  coalesce( _text_active.ddlanguage, _text_english.ddlanguage ) as TEXT_LANGUAGE,
  coalesce( _text_active.ddtext, _text_english.ddtext )         as TEXT
}

Learn More