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 3 fields. 11 CDS views read from this table.

Used by 11 CDS view(s) 3 fields

CDS Views using this table (11)

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)
DDCDS_BOE_FUNCTION_INPUT view left_outer viewstack hier base with tf input column
DDCDS_BOE_OBJINFO_PROCESSING_1 view left_outer Object Information Processing Level 1
DDCDS_BOE_VIEWSTACK_INFO view left_outer View stack heirarchy using entity names
DDCDS_BOE_VIEWSTACK_INFO_UNION view left_outer Union of dd26s and ddcds_fromclause data
I_CustomCDSViewDatasource_VH view_entity left_outer BASIC List of released CDS views

Fields (3)

KeyField CDS FieldsUsed in Views
KEY CDS_DDL baseobj_ddl,ddl_name,dep_ddl 2
KEY CDS_ENTITY cds_entity,dep_entityname,view_name_2 3
KEY CDS_OBJECT_TYPE baseobj_objtype,dep_objtype,tab_objtype 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 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