DDCDS_SELECTLIST

Transparent Table System Table (transport)
38 Fields 1 CDS Views

DD: Select list of CDS Entity

DDCDS_SELECTLIST is an SAP database table in S/4HANA. DD: Select list of CDS Entity. It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BusEvtLogCDSEntityBasic view_entity from BASIC BEL Core Data Service Entity Detail

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY entity_name dd_cds_entity_name Entity Name
KEY union_number dd_union_number Union Select Number
KEY element_alias fieldname Field Name
KEY element_pos ddfdpos DD: Marked Position in a Repeat Group
KEY stack_line dd_stack_line Stackcode Line
KEY as4local as4local Activation State
expr_type dd_expr_type Type of a source based expression
expr_subtype dd_expr_subtype Subtype of Expressions
expr_param_count dd_expr_param_count Parameter Count
base_obj_alias dd_cds_object_name Object Name
base_obj_name dd_cds_object_name Object Name
base_obj_type dd_cds_object_type Object Type
base_element_name fieldname Field Name
base_element_name_raw fieldname Field Name
function_name dddbfuncname DD: Name of a Function on the Database
is_type_preserving as4flag Flag (X or Blank)
operator dd_expr_operator Operator for expressions (and, or, + -, ...)
literal_value dd_expr_literal Literal
parameter_name dd_parameter_name Parameter
session_var_expr char30 30 Characters
data_element rollname Data Element
keyflag keyflag Key field
is_virtual dd_cds_virtual Virtual
is_generated dd_cds_generated Generated
is_generated_localized dd_expr_bool bool value
assoc_name ddassociationname DD: Name of an Association
assoc_base_type int2 INT2
datatype datatype_d Data Type
length ddleng No. of Characters
decimals decimals Decimal Places
anno_name ddannotation_key DD: Key/Name for Annotation
anno_qualifier ddannotation_key DD: Key/Name for Annotation
anno_value ddannotation_val DD: Value of an Annotation
anno_value_unescaped ddannotation_val DD: Value of an Annotation
anno_type dd_annotation_type Annotation type in stackcode
is_path_field dd_cds_path_field Path Field
simple_type dd_drty_name CDS Type Name
enum_name dd_drty_enum Enum of CDS Type

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.

-- DD: Select list of CDS Entity
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DDCDS_SELECTLIST (
    ENTITY_NAME,             -- Entity Name [dd_cds_entity_name]
    UNION_NUMBER,            -- Union Select Number [dd_union_number]
    ELEMENT_ALIAS,           -- Field Name [fieldname]
    ELEMENT_POS,             -- DD: Marked Position in a Repeat Group [ddfdpos]
    STACK_LINE,              -- Stackcode Line [dd_stack_line]
    AS4LOCAL,                -- Activation State [as4local]
    EXPR_TYPE,               -- Type of a source based expression [dd_expr_type]
    EXPR_SUBTYPE,            -- Subtype of Expressions [dd_expr_subtype]
    EXPR_PARAM_COUNT,        -- Parameter Count [dd_expr_param_count]
    BASE_OBJ_ALIAS,          -- Object Name [dd_cds_object_name]
    BASE_OBJ_NAME,           -- Object Name [dd_cds_object_name]
    BASE_OBJ_TYPE,           -- Object Type [dd_cds_object_type]
    BASE_ELEMENT_NAME,       -- Field Name [fieldname]
    BASE_ELEMENT_NAME_RAW,   -- Field Name [fieldname]
    FUNCTION_NAME,           -- DD: Name of a Function on the Database [dddbfuncname]
    IS_TYPE_PRESERVING,      -- Flag (X or Blank) [as4flag]
    OPERATOR,                -- Operator for expressions (and, or, + -, ...) [dd_expr_operator]
    LITERAL_VALUE,           -- Literal [dd_expr_literal]
    PARAMETER_NAME,          -- Parameter [dd_parameter_name]
    SESSION_VAR_EXPR,        -- 30 Characters [char30]
    DATA_ELEMENT,            -- Data Element [rollname]
    KEYFLAG,                 -- Key field [keyflag]
    IS_VIRTUAL,              -- Virtual [dd_cds_virtual]
    IS_GENERATED,            -- Generated [dd_cds_generated]
    IS_GENERATED_LOCALIZED,  -- bool value [dd_expr_bool]
    ASSOC_NAME,              -- DD: Name of an Association [ddassociationname]
    ASSOC_BASE_TYPE,         -- INT2 [int2]
    DATATYPE,                -- Data Type [datatype_d]
    LENGTH,                  -- No. of Characters [ddleng]
    DECIMALS,                -- Decimal Places [decimals]
    ANNO_NAME,               -- DD: Key/Name for Annotation [ddannotation_key]
    ANNO_QUALIFIER,          -- DD: Key/Name for Annotation [ddannotation_key]
    ANNO_VALUE,              -- DD: Value of an Annotation [ddannotation_val]
    ANNO_VALUE_UNESCAPED,    -- DD: Value of an Annotation [ddannotation_val]
    ANNO_TYPE,               -- Annotation type in stackcode [dd_annotation_type]
    IS_PATH_FIELD,           -- Path Field [dd_cds_path_field]
    SIMPLE_TYPE,             -- CDS Type Name [dd_drty_name]
    ENUM_NAME,               -- Enum of CDS Type [dd_drty_enum]
    PRIMARY KEY (ENTITY_NAME, UNION_NUMBER, ELEMENT_ALIAS, ELEMENT_POS, STACK_LINE, AS4LOCAL)
);

Learn More