DDL_OBJECT_NAMES

DDL: DDL_OBJECT_NAMES Type: view_entity

Zuordnung der Namen eines CDS-Objekts

DDL_OBJECT_NAMES is a CDS View that provides data about "Zuordnung der Namen eines CDS-Objekts" in SAP S/4HANA. It reads from 3 data sources (ddldependency, ddldependency, ddddlsrc) and exposes 8 fields. It has 2 associations to related views.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
ddldependency dep_db_view left_outer
ddldependency dep_entity left_outer
ddddlsrc src from

Associations (2)

CardinalityTargetAliasCondition
[0..1] ddddlsrct _text_active _text_active.ddlname = src.ddlname and _text_active.as4local = src.as4local and _text_active.ddlanguage = $session.system_language -- Text English
[0..1] ddddlsrct _text_english _text_english.ddlname = src.ddlname and _text_english.as4local = src.as4local and _text_english.ddlanguage = 'E'

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Zuordnung der Namen eines CDS-Objekts view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #META view

Fields (8)

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
CDS_DB_VIEW ddldependency objectname 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
TEXT_LANGUAGE
TEXT 
@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 join ddldependency as dep_entity  on  src.ddlname           = dep_entity.ddlname
                                                 and src.as4local          = dep_entity.state
                                                 and dep_entity.objecttype = 'STOB'
  //    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'
  -- 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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDDDLSRC",
"DDDDLSRCT",
"DDLDEPENDENCY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More