GSEG_W_PR

Transparent Table System Table (transport)
19 Fields 1 CDS Views

Segmentation Profile

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
cds_gseg_w_pr_sua_ext view_entity from Ext. view on Seg. Profile Sub Appl

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY pr_id GSEG_V_PR_ID Segmentation Profile
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
ot_id GSEG_V_OBJ_TYPE Segm. Object
base_ds_alias GSEG_V_BASE_DS_ALIAS Data Source Alias
comm_area_id HPA_COMM_AREA_ID Comm. Area ID
ref_org_struc HPA_REF_ORG_STRUC Source Organization
curr_code GSEG_V_CURR_CODE Currency Code
pr_default GSEG_V_PR_DEFAULT Default Profile
pr_tzone GSEG_V_PR_TZONE Time Zone of Profile
lmi GSEG_V_LMI Change Indicator for Layers
sw_release GSEG_V_MD_SW_RELEASE Software Release
pr_id_main GSEG_V_PR_ID_MAIN Main Segm. Profile
ext_seq GSEG_V_MD_EXT_SEQ Sequence No.

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 Profile
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSEG_W_PR (
    PR_ID,            -- Segmentation Profile [GSEG_V_PR_ID]
    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]
    OT_ID,            -- Segm. Object [GSEG_V_OBJ_TYPE]
    BASE_DS_ALIAS,    -- Data Source Alias [GSEG_V_BASE_DS_ALIAS]
    COMM_AREA_ID,     -- Comm. Area ID [HPA_COMM_AREA_ID]
    REF_ORG_STRUC,    -- Source Organization [HPA_REF_ORG_STRUC]
    CURR_CODE,        -- Currency Code [GSEG_V_CURR_CODE]
    PR_DEFAULT,       -- Default Profile [GSEG_V_PR_DEFAULT]
    PR_TZONE,         -- Time Zone of Profile [GSEG_V_PR_TZONE]
    LMI,              -- Change Indicator for Layers [GSEG_V_LMI]
    SW_RELEASE,       -- Software Release [GSEG_V_MD_SW_RELEASE]
    PR_ID_MAIN,       -- Main Segm. Profile [GSEG_V_PR_ID_MAIN]
    EXT_SEQ,          -- Sequence No. [GSEG_V_MD_EXT_SEQ]
    PRIMARY KEY (PR_ID, APPL_ID, VERSION)
);

Learn More