DDDRTY_SMPL_ENUM

Transparent Table System Table (transport)
25 Fields 19 CDS Views

CDS Types: Simple Type ENUM Definition

DDDRTY_SMPL_ENUM is an SAP database table in S/4HANA. CDS Types: Simple Type ENUM Definition. It contains 25 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
dd_drty_st_enum_values_char_1 view_entity inner CDS ST: Enumeration Values CHAR 1
dd_drty_st_enum_values_char_2 view_entity inner CDS ST: Enumeration Values CHAR 2
dd_drty_st_enum_values_char_3 view_entity inner CDS ST: Enumeration Values CHAR 3
dd_drty_st_enum_values_char_4 view_entity inner CDS ST: Enumeration Values CHAR 4
dd_drty_st_enum_values_char_5 view_entity inner CDS ST: Enumeration Values CHAR 5
dd_drty_st_enum_values_char_6 view_entity inner CDS ST: Enumeration Values CHAR 6
dd_drty_st_enum_values_char_7 view_entity inner CDS ST: Enumeration Values CHAR 7
dd_drty_st_enum_values_char_8 view_entity inner CDS ST: Enumeration Values CHAR 8
dd_drty_st_enum_values_int1 view_entity inner CDS ST: Enumeration Values INT1
dd_drty_st_enum_values_int2 view_entity inner CDS ST: Enumeration Values INT2
dd_drty_st_enum_values_int4 view_entity inner CDS ST: Enumeration Values INT4
dd_drty_st_enum_values_numc_1 view_entity inner CDS ST: Enumeration Values NUMC 1
dd_drty_st_enum_values_numc_2 view_entity inner CDS ST: Enumeration Values NUMC 2
dd_drty_st_enum_values_numc_3 view_entity inner CDS ST: Enumeration Values NUMC 3
dd_drty_st_enum_values_numc_4 view_entity inner CDS ST: Enumeration Values NUMC 4
dd_drty_st_enum_values_numc_5 view_entity inner CDS ST: Enumeration Values NUMC 5
dd_drty_st_enum_values_numc_6 view_entity inner CDS ST: Enumeration Values NUMC 6
dd_drty_st_enum_values_numc_7 view_entity inner CDS ST: Enumeration Values NUMC 7
dd_drty_st_enum_values_numc_8 view_entity inner CDS ST: Enumeration Values NUMC 8

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY type_name dd_drty_name CDS Type Name
KEY as4local as4local Activation State
KEY enum_name dd_drty_enum Enum of CDS Type
value_char_1 dd_drty_enum_value_char_1 Enum Value Char 1
value_char_2 dd_drty_enum_value_char_2 Enum Value Char 2
value_char_3 dd_drty_enum_value_char_3 Enum Value Char 3
value_char_4 dd_drty_enum_value_char_4 Enum Value Char 4
value_char_5 dd_drty_enum_value_char_5 Enum Value Char 5
value_char_6 dd_drty_enum_value_char_6 Enum Value Char 6
value_char_7 dd_drty_enum_value_char_7 Enum Value Char 7
value_char_8 dd_drty_enum_value_char_8 Enum Value Char 8
value_numc_1 dd_drty_enum_value_numc_1 Enum Value Numc 1
value_numc_2 dd_drty_enum_value_numc_2 Enum Value Numc 2
value_numc_3 dd_drty_enum_value_numc_3 Enum Value Numc 3
value_numc_4 dd_drty_enum_value_numc_4 Enum Value Numc 4
value_numc_5 dd_drty_enum_value_numc_5 Enum Value Numc 5
value_numc_6 dd_drty_enum_value_numc_6 Enum Value Numc 6
value_numc_7 dd_drty_enum_value_numc_7 Enum Value Numc 7
value_numc_8 dd_drty_enum_value_numc_8 Enum Value Numc 8
value_int1 dd_drty_enum_value_int1 Enum Value INT1
value_int2 dd_drty_enum_value_int2 Enum Value INT2
value_int4 dd_drty_enum_value_int4 Enum Value INT4
enum_name_raw dd_drty_enum_raw Enum Raw of CDS Type
is_initial_value dd_drty_enum_value_is_initial is initial
position ddfdpos DD: Marked Position in a Repeat Group

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- CDS Types: Simple Type ENUM Definition
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DDDRTY_SMPL_ENUM (
    TYPE_NAME,         -- CDS Type Name [dd_drty_name]
    AS4LOCAL,          -- Activation State [as4local]
    ENUM_NAME,         -- Enum of CDS Type [dd_drty_enum]
    VALUE_CHAR_1,      -- Enum Value Char 1 [dd_drty_enum_value_char_1]
    VALUE_CHAR_2,      -- Enum Value Char 2 [dd_drty_enum_value_char_2]
    VALUE_CHAR_3,      -- Enum Value Char 3 [dd_drty_enum_value_char_3]
    VALUE_CHAR_4,      -- Enum Value Char 4 [dd_drty_enum_value_char_4]
    VALUE_CHAR_5,      -- Enum Value Char 5 [dd_drty_enum_value_char_5]
    VALUE_CHAR_6,      -- Enum Value Char 6 [dd_drty_enum_value_char_6]
    VALUE_CHAR_7,      -- Enum Value Char 7 [dd_drty_enum_value_char_7]
    VALUE_CHAR_8,      -- Enum Value Char 8 [dd_drty_enum_value_char_8]
    VALUE_NUMC_1,      -- Enum Value Numc 1 [dd_drty_enum_value_numc_1]
    VALUE_NUMC_2,      -- Enum Value Numc 2 [dd_drty_enum_value_numc_2]
    VALUE_NUMC_3,      -- Enum Value Numc 3 [dd_drty_enum_value_numc_3]
    VALUE_NUMC_4,      -- Enum Value Numc 4 [dd_drty_enum_value_numc_4]
    VALUE_NUMC_5,      -- Enum Value Numc 5 [dd_drty_enum_value_numc_5]
    VALUE_NUMC_6,      -- Enum Value Numc 6 [dd_drty_enum_value_numc_6]
    VALUE_NUMC_7,      -- Enum Value Numc 7 [dd_drty_enum_value_numc_7]
    VALUE_NUMC_8,      -- Enum Value Numc 8 [dd_drty_enum_value_numc_8]
    VALUE_INT1,        -- Enum Value INT1 [dd_drty_enum_value_int1]
    VALUE_INT2,        -- Enum Value INT2 [dd_drty_enum_value_int2]
    VALUE_INT4,        -- Enum Value INT4 [dd_drty_enum_value_int4]
    ENUM_NAME_RAW,     -- Enum Raw of CDS Type [dd_drty_enum_raw]
    IS_INITIAL_VALUE,  -- is initial [dd_drty_enum_value_is_initial]
    POSITION,          -- DD: Marked Position in a Repeat Group [ddfdpos]
    PRIMARY KEY (TYPE_NAME, AS4LOCAL, ENUM_NAME)
);

Learn More