GSEG_D_SEG_SELRU

Transparent Table Application Table

Segment selection Rule

GSEG_D_SEG_SELRU is an SAP database table in S/4HANA. Segment selection Rule. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
cuan_crp_segmodel_at_usage view_entity left_outer Attribute Usage in Segmentation Models

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
root_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
log_op GSEG_V_LOG_EXPR_OPERATOR_TOKEN Operator/Token
data_src_alias GSEG_V_DS_ALIAS DS Alias
attr_name GSEG_V_AT_NAME Attribute Name
sel_opt GSEG_V_SEL_OPT Sel. Options
val_lo GSEG_V_AT_VALUE Low or High
val_hi GSEG_V_AT_VALUE Low or High
interval_type GSEG_V_INTERVAL_BOUNDARY_TYPE Intvl Bndry Tpe
currency_code GSEG_V_CURR_CODE Currency Code
kf_type_variable GSEG_V_KF_TYPE_VAR Input Parameter
date_pick_type GSEG_V_DATE_PICK_TYPE Date Picker
date_duration_type GSEG_V_DATE_DURATION_TYPE Duration Type
date_duration GSEG_V_DATE_DURATION Date Duration
date_offset GSEG_V_DATE_OFFSET Date Offset
sequence GSEG_V_SEG_SEL_RULE_SEQ Sel. Rule Seq.
sequence_sub GSEG_V_SEG_SEL_RULE_SEQ_SUB Subsequence
annotation GSEG_V_SELRU_ANNOTATION Annotation
val_lo_orig GSEG_V_AT_VALUE_ORIG Original Value
val_hi_orig GSEG_V_AT_VALUE_ORIG Original Value

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.

-- Segment selection Rule
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSEG_D_SEG_SELRU (
    MANDT,               -- Client [MANDT]
    DB_KEY,              -- NodeID [/BOBF/CONF_KEY]
    ROOT_KEY,            -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,          -- NodeID [/BOBF/CONF_KEY]
    LOG_OP,              -- Operator/Token [GSEG_V_LOG_EXPR_OPERATOR_TOKEN]
    DATA_SRC_ALIAS,      -- DS Alias [GSEG_V_DS_ALIAS]
    ATTR_NAME,           -- Attribute Name [GSEG_V_AT_NAME]
    SEL_OPT,             -- Sel. Options [GSEG_V_SEL_OPT]
    VAL_LO,              -- Low or High [GSEG_V_AT_VALUE]
    VAL_HI,              -- Low or High [GSEG_V_AT_VALUE]
    INTERVAL_TYPE,       -- Intvl Bndry Tpe [GSEG_V_INTERVAL_BOUNDARY_TYPE]
    CURRENCY_CODE,       -- Currency Code [GSEG_V_CURR_CODE]
    KF_TYPE_VARIABLE,    -- Input Parameter [GSEG_V_KF_TYPE_VAR]
    DATE_PICK_TYPE,      -- Date Picker [GSEG_V_DATE_PICK_TYPE]
    DATE_DURATION_TYPE,  -- Duration Type [GSEG_V_DATE_DURATION_TYPE]
    DATE_DURATION,       -- Date Duration [GSEG_V_DATE_DURATION]
    DATE_OFFSET,         -- Date Offset [GSEG_V_DATE_OFFSET]
    SEQUENCE,            -- Sel. Rule Seq. [GSEG_V_SEG_SEL_RULE_SEQ]
    SEQUENCE_SUB,        -- Subsequence [GSEG_V_SEG_SEL_RULE_SEQ_SUB]
    ANNOTATION,          -- Annotation [GSEG_V_SELRU_ANNOTATION]
    VAL_LO_ORIG,         -- Original Value [GSEG_V_AT_VALUE_ORIG]
    VAL_HI_ORIG,         -- Original Value [GSEG_V_AT_VALUE_ORIG]
    PRIMARY KEY (MANDT, DB_KEY)
);