GSEG_W_PR

Transparent Table System Table (transport)
18 Fields 2 CDS Views

Segmentation Profile

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

CDS Views using this table (2)

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

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY pr_id gseg_v_pr_id
KEY appl_id gseg_v_appl_id
KEY version gseg_v_md_version
layer gseg_v_md_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
base_ds_alias gseg_v_base_ds_alias
curr_code gseg_v_curr_code
pr_default gseg_v_pr_default
pr_deprecated gseg_v_pr_deprecated
pr_tzone gseg_v_pr_tzone
lmi gseg_v_lmi
sw_release gseg_v_md_sw_release
pr_id_main gseg_v_pr_id_main
ext_seq gseg_v_md_ext_seq

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,            -- gseg_v_pr_id
    APPL_ID,          -- gseg_v_appl_id
    VERSION,          -- gseg_v_md_version
    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,            -- gseg_v_obj_type
    BASE_DS_ALIAS,    -- gseg_v_base_ds_alias
    CURR_CODE,        -- gseg_v_curr_code
    PR_DEFAULT,       -- gseg_v_pr_default
    PR_DEPRECATED,    -- gseg_v_pr_deprecated
    PR_TZONE,         -- gseg_v_pr_tzone
    LMI,              -- gseg_v_lmi
    SW_RELEASE,       -- gseg_v_md_sw_release
    PR_ID_MAIN,       -- gseg_v_pr_id_main
    EXT_SEQ,          -- gseg_v_md_ext_seq
    PRIMARY KEY (PR_ID, APPL_ID, VERSION)
);

Learn More