DBC2ABAP_CDS_PARAMETERS

DDL: DBC2ABAP_CDS_PARAMETERS Type: view_entity

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 3 data sources (DDCDS_ENTITY_PARAMETERS_INTERN, sql1_head, srvd_rt_entities_direct) and exposes 4 fields with key field ExposedAliasendasexternal_entity_name.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
DDCDS_ENTITY_PARAMETERS_INTERN parm inner
sql1_head sql1 from
srvd_rt_entities_direct 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 (4)

KeyFieldSource TableSource FieldDescription
KEY ExposedAliasendasexternal_entity_name
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   srvd_rt_entities_direct        as srvd on  srvd.Service             = sql1.service_def_name
                                                        and srvd.ExposedArtifactType = 'E'
    inner join   DDCDS_ENTITY_PARAMETERS_INTERN as parm on  parm.entity_name  = srvd.ExposedArtifact
                                                        and parm.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 parm.parameter_name                           as parameter_name,
      srvd.ExposedArtifact                          as internal_entity_name,
      sql1.sql1_name_raw                            as sql_service_name_raw,
      case when srvd.ExposedAliasRaw = ' '
       then parm.entity_name_raw
       else srvd.ExposedAliasRaw 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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DDCDS_ENTITY_PARAMETERS_INTERN",
"SRVD_RT_ENTITIES_DIRECT",
"DDPARAMETERANNO",
"SQL1_HEAD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More