dbc2abap_cds_elements

DDL: DBC2ABAP_CDS_ELEMENTS Type: view_entity

CDS Entities in SQL1 Service Bindings

dbc2abap_cds_elements is a CDS View that provides data about "CDS Entities in SQL1 Service Bindings" in SAP S/4HANA. It reads from 3 data sources (DDCDS_ENTITY_ELEMENTS_INTERN, sql1_head, srvd_rt_entities_direct) and exposes 5 fields with key fields ExposedAliasendasexternal_entity_name, element_name.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
DDCDS_ENTITY_ELEMENTS_INTERN elem inner
sql1_head sql1 from
srvd_rt_entities_direct srvd inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label CDS Entities in SQL1 Service Bindings view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ExposedAliasendasexternal_entity_name
KEY element_name DDCDS_ENTITY_ELEMENTS_INTERN element_name
is_key DDCDS_ENTITY_ELEMENTS_INTERN is_key
ddic_type DDCDS_ENTITY_ELEMENTS_INTERN data_type_d
ddic_length DDCDS_ENTITY_ELEMENTS_INTERN length 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'CDS Entities in SQL1 Service Bindings'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity dbc2abap_cds_elements
  as select from sql1_head                    as sql1
    inner join   srvd_rt_entities_direct      as srvd on  srvd.Service             = sql1.service_def_name
                                                      and srvd.ExposedArtifactType = 'E'
    inner join   DDCDS_ENTITY_ELEMENTS_INTERN as elem on  elem.entity_name  = srvd.ExposedArtifact
                                                      and elem.entity_state = 'A'
{
  key sql1.sql1_name                                       as sql_service_name,
  key case when srvd.ExposedAlias = ' '
       then srvd.ExposedArtifact
       else srvd.ExposedAlias end                          as external_entity_name,
  key elem.element_name                                    as element_name,
      srvd.ExposedArtifact                                 as internal_entity_name,
      sql1.sql1_name_raw                                   as sql_service_name_raw,
      case when srvd.ExposedAliasRaw = ' '
       then elem.entity_name_raw
       else srvd.ExposedAliasRaw end                       as external_entity_name_raw,
      elem.element_name_raw                                as element_name_raw,
      elem.element_position                                as element_position,
      elem.is_key                                          as is_key,
      elem.data_type_d                                     as ddic_type,
      elem.length                                          as ddic_length,
      elem.decimals                                        as ddic_decimals,
      coalesce( elem.direct_element_label,
                elem.data_element_label_m )                as ddic_label
}
where
      sql1.state     =  'A'
  and sql1.sql1_name <> 'S_PRIVILEGED'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDCDS_ENTITY_ELEMENTS_INTERN",
"SRVD_RT_ENTITIES_DIRECT",
"SQL1_HEAD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More