DHSQL_PARAM_VALUES

DDL: DHSQL_PARAM_VALUES Type: view_entity Package: SADI_SQL_CORE

Enumerated Parameter Values

DHSQL_PARAM_VALUES is a CDS View that provides data about "Enumerated Parameter Values" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field Value. Part of development package SADI_SQL_CORE.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Enumerated Parameter Values view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Value dd07l domvalue_l
Description dd07t ddtext 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Enumerated Parameter Values'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity DHSQL_PARAM_VALUES as select from dd07l
  left outer to one join dd07t on dd07t.domname    = dd07l.domname
                              and dd07t.valpos     = dd07l.valpos 
                              and dd07t.as4local   = 'A'
                              and dd07t.as4vers    = '0000'
                              and dd07t.ddlanguage = $session.system_language
{
  key cast( case 
      when dd07l.domname = 'DHSQL_PAR_LOAD_TYPE' then 'LOAD_TYPE'
      else dd07l.domname
      end as fieldname preserving type ) as Parameter_Name,
  key dd07l.domvalue_l as Value,
  case
      when dd07l.domname = 'DHSQL_PAR_LOAD_TYPE' and dd07l.domvalue_l = 'LOAD' then 'true'
      else 'false'
      end as Is_Default,
  dd07t.ddtext as Description
} where dd07l.domname    = 'DHSQL_PAR_LOAD_TYPE' 
    and dd07l.as4local   = 'A'
    and dd07l.as4vers    = '0000'

Learn More