DD_DRTY_ST_ENUM_VALUES

CDS View

CDS ST: Enumeration Values

DD_DRTY_ST_ENUM_VALUES is a CDS View in S/4HANA. CDS ST: Enumeration Values. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
dd_drty_st_enum_values_t view_entity from CDS ST: Enum Values with Text

Fields (3)

KeyField CDS FieldsUsed in Views
KEY enumIdentifier enumIdentifier 1
KEY enumValue enumValue 1
KEY simpleType simpleType 1 
@AbapCatalog.entityBuffer.definitionAllowed: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS ST: Enumeration Values'
define root view entity dd_drty_st_enum_values
  as select from dddrty_smpl_type as type
    inner join   dddrty_smpl_enum as enum on type.type_name = enum.type_name
  composition [0..*] of dd_drty_st_enum_values_t as _Text
{
  key type.type_name as simpleType,
  key enum.enum_name as enumIdentifier,
  key
      case type.datatype
       when 'CHAR'
         then
           case type.leng
            when '000001' then cast( enum.value_char_1 as dd_drty_enum_value )
            when '000002' then cast( enum.value_char_2 as dd_drty_enum_value )
            when '000003' then cast( enum.value_char_3 as dd_drty_enum_value )
            when '000004' then cast( enum.value_char_4 as dd_drty_enum_value )
            when '000005' then cast( enum.value_char_5 as dd_drty_enum_value )
            when '000006' then cast( enum.value_char_6 as dd_drty_enum_value )
            when '000007' then cast( enum.value_char_7 as dd_drty_enum_value )
            when '000008' then cast( enum.value_char_8 as dd_drty_enum_value )
            else cast( enum.value_int4 as dd_drty_enum_value )
            end
       when 'NUMC'
       then
           case type.leng
            when '000001' then cast( enum.value_numc_1 as dd_drty_enum_value )
            when '000002' then cast( enum.value_numc_2 as dd_drty_enum_value )
            when '000003' then cast( enum.value_numc_3 as dd_drty_enum_value )
            when '000004' then cast( enum.value_numc_4 as dd_drty_enum_value )
            when '000005' then cast( enum.value_numc_5 as dd_drty_enum_value )
            when '000006' then cast( enum.value_numc_6 as dd_drty_enum_value )
            when '000007' then cast( enum.value_numc_7 as dd_drty_enum_value )
            when '000008' then cast( enum.value_numc_8 as dd_drty_enum_value )
            else cast( enum.value_int4 as dd_drty_enum_value )
            end
       when 'INT1'
        then cast( enum.value_int1 as dd_drty_enum_value )
       when 'INT2'
        then cast( enum.value_int2 as dd_drty_enum_value )
       when 'INT4'
        then cast( enum.value_int4 as dd_drty_enum_value )
       else cast( '' as dd_drty_enum_value )
       end           as enumValue,
      _Text
}

Learn More