DDDRTY_SMPL_ENUM

Transparent Table System Table (transport)
25 Fields 20 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. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
dd_drty_st_enum_values view_entity inner CDS ST: Enumeration Values
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