GSEG_PROFILE

Transparent Table Temporary Data
10 Fields 9 CDS Views

Segmentation Profile

GSEG_PROFILE is an SAP database table in S/4HANA. Segmentation Profile. It contains 10 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
cds_gseg_pr_sua_ext view_entity from Ext. view on Seg. Profile Sub Appls
cuan_crp_expdef_at_usage view_entity left_outer Attribute Usage in Export Definition
cuan_crp_segmodel_at_usage view_entity left_outer Attribute Usage in Segmentation Models
CUAN_EXP_DEF_ATTRIBUTES view_entity inner Attributes of Export Definition
GSEG_CDS_SEG_MODEL_COLD view_entity left_outer Search Cold Segmentation Models
GSEG_CDS_SEG_MODEL_SRCH view_entity left_outer Search Segmentation Models
GSEG_CDS_SM_IP_USAGE view_entity left_outer Use of input params in seg models
I_IBCMsgSegmentationProfile view_entity from BASIC Message Segmentation Profile
I_MKT_CmpgnCntntReuseSegmtn view_entity from BASIC Campaign Content: Reusable Block Segmentation Profiles

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY appl_id GSEG_V_APPL_ID Application ID
KEY pr_id GSEG_V_PR_ID Segmentation Profile
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

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 L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSEG_PROFILE (
    CLIENT,         -- Client [MANDT]
    APPL_ID,        -- Application ID [GSEG_V_APPL_ID]
    PR_ID,          -- Segmentation Profile [GSEG_V_PR_ID]
    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]
    PRIMARY KEY (CLIENT, APPL_ID, PR_ID)
);

Learn More