GSEG_D_SEG_SELRU
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| cuan_crp_segmodel_at_usage | view_entity | left_outer | Attribute Usage in Segmentation Models |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA