GSEG_W_DS
Segmentation Data Source
GSEG_W_DS is an SAP database table in S/4HANA. Segmentation Data Source. It contains 11 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| cds_gseg_w_ds_all | view_entity | from | Union of all segmentation data sources |
Fields (11)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | ds_alias | GSEG_V_DS_ALIAS | DS Alias | |||
| KEY | appl_id | GSEG_V_APPL_ID | Application ID | |||
| KEY | version | GSEG_V_MD_VERSION | Meta Data Version | |||
| layer | GSEG_V_MD_LAYER | Meta Data Layer | ||||
| created_by | SYUNAME | User Name | ||||
| created_at | TIMESTAMPL | Time Stamp | ||||
| last_changed_by | SYUNAME | User Name | ||||
| last_changed_at | TIMESTAMPL | Time Stamp | ||||
| ds_path | GSEG_V_DS_PATH_DB | Data Source Location | ||||
| lmi | GSEG_V_LMI | Change Indicator for Layers | ||||
| sw_release | GSEG_V_MD_SW_RELEASE | Software Release |
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 Data Source
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSEG_W_DS (
DS_ALIAS, -- DS Alias [GSEG_V_DS_ALIAS]
APPL_ID, -- Application ID [GSEG_V_APPL_ID]
VERSION, -- Meta Data Version [GSEG_V_MD_VERSION]
LAYER, -- Meta Data Layer [GSEG_V_MD_LAYER]
CREATED_BY, -- User Name [SYUNAME]
CREATED_AT, -- Time Stamp [TIMESTAMPL]
LAST_CHANGED_BY, -- User Name [SYUNAME]
LAST_CHANGED_AT, -- Time Stamp [TIMESTAMPL]
DS_PATH, -- Data Source Location [GSEG_V_DS_PATH_DB]
LMI, -- Change Indicator for Layers [GSEG_V_LMI]
SW_RELEASE, -- Software Release [GSEG_V_MD_SW_RELEASE]
PRIMARY KEY (DS_ALIAS, APPL_ID, VERSION)
);
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