DDCDS_SELECTLIST

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BusEvtLogCDSEntityBasic view_entity from BASIC BEL Core Data Service Entity Detail
I_ProductProcModif view_entity inner BASIC Product Modification in a Process

Fields (48)

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 DD_CDS_SESSION_VARIABLE Session Variable
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
aspect_name DD_DRAS_NAME CDS Aspect Name
aspect_alias DD_ASPECT_BINDING_NAME Aspect Binding Name
aspect_element_name FIELDNAME Field Name
is_expanded_include_asterisk DD_CDS_INCLUDE_ASTERISK Expanded Include *
excluding_shortcut_id DD_EXCLUDING_SHORTCUT_ID Exclude shortcut ID
token_start_line INT4 INT4
token_start_column INT4 INT4
token_end_line INT4 INT4
token_end_column INT4 INT4
token_ddlname DDLNAME DDL Source 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.

-- 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,              -- Session Variable [DD_CDS_SESSION_VARIABLE]
    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]
    ASPECT_NAME,                   -- CDS Aspect Name [DD_DRAS_NAME]
    ASPECT_ALIAS,                  -- Aspect Binding Name [DD_ASPECT_BINDING_NAME]
    ASPECT_ELEMENT_NAME,           -- Field Name [FIELDNAME]
    IS_EXPANDED_INCLUDE_ASTERISK,  -- Expanded Include * [DD_CDS_INCLUDE_ASTERISK]
    EXCLUDING_SHORTCUT_ID,         -- Exclude shortcut ID [DD_EXCLUDING_SHORTCUT_ID]
    TOKEN_START_LINE,              -- INT4 [INT4]
    TOKEN_START_COLUMN,            -- INT4 [INT4]
    TOKEN_END_LINE,                -- INT4 [INT4]
    TOKEN_END_COLUMN,              -- INT4 [INT4]
    TOKEN_DDLNAME,                 -- DDL Source Name [DDLNAME]
    PRIMARY KEY (ENTITY_NAME, UNION_NUMBER, ELEMENT_ALIAS, ELEMENT_POS, STACK_LINE, AS4LOCAL)
);

Learn More