GSEG_D_SM_ROOT

Transparent Table Application Table
19 Fields 4 CDS Views

Segmentation Model

GSEG_D_SM_ROOT is an SAP database table in S/4HANA. Segmentation Model. It contains 19 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
CUAN_TG_WITH_NAMES_SEARCH view_entity left_outer AT_SEARCH_TARGET_GROUP_WITH_NAMES
GEN_RESULT_SET_W_O_MEM_COUNT view_entity left_outer Query Result Sets by Elements
GSEG_CDS_SEG_MODEL_COLD view_entity from Search Cold Segmentation Models
GSEG_CDS_SEG_MODEL_SRCH view_entity from Search Segmentation Models

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
application_id GSEG_V_APPL_ID Application ID
segmentation_model_id GSEG_V_SEGMENTATION_MODEL_ID Segm. Model ID
sm_vs_number GSEG_V_SM_VS_NUMBER Version Number
profile_id GSEG_V_PR_ID Segmentation Profile
name GSEG_V_SEGMENTATION_MODEL_NAME Segm. Model Name
comm_area_id HPA_COMM_AREA_ID Comm. Area ID
ref_org_struc HPA_REF_ORG_STRUC Source Organization
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
_dataaging DATA_TEMPERATURE Data Aging
sm_master_key_ref GSEG_V_SM_MASTER_KEY_REF S. M. Mstr Key
vs_crea_date_time TIMESTAMPL Time Stamp
vs_crea_uname UNAME User Name
seg_id_high GSEG_V_SEGMENT_ID Segment ID
gseg_e_sm_root DUMMY Dummy function in length 1

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.

-- Segmentation Model
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSEG_D_SM_ROOT (
    MANDT,                  -- Client [MANDT]
    DB_KEY,                 -- NodeID [/BOBF/CONF_KEY]
    APPLICATION_ID,         -- Application ID [GSEG_V_APPL_ID]
    SEGMENTATION_MODEL_ID,  -- Segm. Model ID [GSEG_V_SEGMENTATION_MODEL_ID]
    SM_VS_NUMBER,           -- Version Number [GSEG_V_SM_VS_NUMBER]
    PROFILE_ID,             -- Segmentation Profile [GSEG_V_PR_ID]
    NAME,                   -- Segm. Model Name [GSEG_V_SEGMENTATION_MODEL_NAME]
    COMM_AREA_ID,           -- Comm. Area ID [HPA_COMM_AREA_ID]
    REF_ORG_STRUC,          -- Source Organization [HPA_REF_ORG_STRUC]
    CREA_DATE_TIME,         -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,             -- User Name [UNAME]
    LCHG_DATE_TIME,         -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,             -- User Name [UNAME]
    _DATAAGING,             -- Data Aging [DATA_TEMPERATURE]
    SM_MASTER_KEY_REF,      -- S. M. Mstr Key [GSEG_V_SM_MASTER_KEY_REF]
    VS_CREA_DATE_TIME,      -- Time Stamp [TIMESTAMPL]
    VS_CREA_UNAME,          -- User Name [UNAME]
    SEG_ID_HIGH,            -- Segment ID [GSEG_V_SEGMENT_ID]
    GSEG_E_SM_ROOT,         -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More