DBC2ABAP_CDS_PARAMETERS

DDL: DBC2ABAP_CDS_PARAMETERS Type: view_entity Package: SABP_DBC2ABAP_RUNTIME

CDS Entity Parameters in SQL1 ServiceB

DBC2ABAP_CDS_PARAMETERS is a CDS View that provides data about "CDS Entity Parameters in SQL1 ServiceB" in SAP S/4HANA. It reads from 4 data sources (dd02b, DDCDS_ENTITY_PARAMETERS_INTERN, sql1_head, E_SRVD_RT_ENTITIES) and exposes 3 fields. Part of development package SABP_DBC2ABAP_RUNTIME.

4 data source(s) 3 fields

Data Sources (4)

SourceAliasJoin Type
dd02b enti inner
DDCDS_ENTITY_PARAMETERS_INTERN parm inner
sql1_head sql1 from
E_SRVD_RT_ENTITIES srvd inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label CDS Entity Parameters in SQL1 ServiceB view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
ddic_type DDCDS_ENTITY_PARAMETERS_INTERN data_type_d
ddic_length DDCDS_ENTITY_PARAMETERS_INTERN length
ddic_label 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_ALLOWED
@EndUserText.label: 'CDS Entity Parameters in SQL1 ServiceB '
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity DBC2ABAP_CDS_PARAMETERS
  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_PARAMETERS_INTERN as parm on  parm.entity_name  = srvd.exposed_artifact
                                                        and parm.entity_state = 'A'
    inner join   dd02b                          as enti on  enti.strucobjn     = srvd.exposed_artifact
                                                        and enti.as4local      = 'A'
                                                        and enti.strucobjclass = 'VIEWENTITY'
{
  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,
  key parm.parameter_name                           as parameter_name,
      srvd.exposed_artifact                         as internal_entity_name,
      sql1.sql1_name_raw                            as sql_service_name_raw,
      case when srvd.exposed_alias_raw = ' '
       then parm.entity_name_raw
       else srvd.exposed_alias_raw end              as external_entity_name_raw,
      parm.parameter_name_raw                       as parameter_name_raw,
      parm.parameter_position                       as parameter_position,
      parm.data_type_d                              as ddic_type,
      parm.length                                   as ddic_length,
      parm.decimals                                 as ddic_decimals,
      cast( parm.parameter_label as abap.char(250)) as ddic_label,
      case when parm._environment.name is null
        then 'FALSE' else 'TRUE' end                as is_optional
}
where
      sql1.state     =  'A'
  and sql1.sql1_name <> 'S_PRIVILEGED'

Learn More