DDDRTY_SMPL_TYPE

Transparent Table System Table (transport)
12 Fields 20 CDS Views

CDS Types: Simple Type Definition

DDDRTY_SMPL_TYPE is an SAP database table in S/4HANA. CDS Types: Simple Type Definition. It contains 12 fields. 20 CDS views read from this table.

CDS Views using this table (20)

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

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY type_name dd_drty_name CDS Type Name
KEY as4local as4local Activation State
datatype datatype_d Data Type
leng ddleng No. of Characters
decimals decimals Decimal Places
simple_type dd_drty_name CDS Type Name
data_element rollname Data Element
lowercase lowercase Case-Sensitive
convexit convexit Convers. Rout.
logflag logflag Change document
enum_origin dd_drty_name CDS Type Name
type_name_raw dd_drty_name_raw CDS Type Raw Name

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 Definition
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DDDRTY_SMPL_TYPE (
    TYPE_NAME,      -- CDS Type Name [dd_drty_name]
    AS4LOCAL,       -- Activation State [as4local]
    DATATYPE,       -- Data Type [datatype_d]
    LENG,           -- No. of Characters [ddleng]
    DECIMALS,       -- Decimal Places [decimals]
    SIMPLE_TYPE,    -- CDS Type Name [dd_drty_name]
    DATA_ELEMENT,   -- Data Element [rollname]
    LOWERCASE,      -- Case-Sensitive [lowercase]
    CONVEXIT,       -- Convers. Rout. [convexit]
    LOGFLAG,        -- Change document [logflag]
    ENUM_ORIGIN,    -- CDS Type Name [dd_drty_name]
    TYPE_NAME_RAW,  -- CDS Type Raw Name [dd_drty_name_raw]
    PRIMARY KEY (TYPE_NAME, AS4LOCAL)
);

Learn More