DBC2ABAP_CDS_TABLES

DDL: DBC2ABAP_CDS_TABLES Type: view_entity Package: SABP_DBC2ABAP_RUNTIME

CDS Table Entities in SQL1 Service Bindings

DBC2ABAP_CDS_TABLES is a CDS View that provides data about "CDS Table Entities in SQL1 Service Bindings" in SAP S/4HANA. It reads from 3 data sources (DDCDS_ENTITY_HEADER, sql1_head, E_SRVD_RT_ENTITIES) and exposes 1 field. It has 1 association to related views. Part of development package SABP_DBC2ABAP_RUNTIME.

3 data source(s) 1 fields

Data Sources (3)

SourceAliasJoin Type
DDCDS_ENTITY_HEADER enti inner
sql1_head sql1 from
E_SRVD_RT_ENTITIES srvd inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] DDCDS_ENTITY_HEADER _cds_entity _cds_entity.state = 'A' and _cds_entity.entity_name = $projection.internal_entity_name

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label CDS Table 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 (1)

KeyFieldSource TableSource FieldDescription
_cds_entity _cds_entity 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'CDS Table Entities in SQL1 Service Bindings'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity DBC2ABAP_CDS_TABLES
  as select from sql1_head           as sql1
    inner join   E_SRVD_RT_ENTITIES  as srvd on  srvd.service               = sql1.service_def_name
                                             and srvd.exposed_artifact_type = 'E'
    inner join   DDCDS_ENTITY_HEADER as enti on  enti.entity_name = srvd.exposed_artifact
                                             and enti.state       = 'A'
  association [0..1] to DDCDS_ENTITY_HEADER as _cds_entity on  _cds_entity.state       = 'A'
                                                           and _cds_entity.entity_name = $projection.internal_entity_name
{
  key sql1.sql1_name                     as sql_service_name,
  key case when srvd.exposed_alias = ' '
        then srvd.exposed_artifact
        else srvd.exposed_alias      end as external_entity_name,
      sql1.sql1_name_raw                 as sql_service_name_raw,
      case when srvd.exposed_alias_raw = ' '
        then enti.entity_name_raw
        else srvd.exposed_alias_raw  end as external_entity_name_raw,
      srvd.exposed_artifact              as internal_entity_name,
      enti.entity_name_raw               as internal_entity_name_raw,
      enti.label_text                    as entity_label_text,
      sql1.enabled_for_replicate         as enabled_for_replicate,
      case sql1.disabled_for_select
        when 'X' then ' ' else 'X' end   as enabled_for_select,
      _cds_entity
}
where
      sql1.state     =  'A'
  and sql1.sql1_name <> 'S_PRIVILEGED'
  and enti.source_type = 'T' //only CDS table entities

Learn More