GSEG_PROFILE
Segmentation Profile
GSEG_PROFILE is an SAP database table in S/4HANA. Segmentation Profile. It contains 9 fields. 13 CDS views read from this table.
CDS Views using this table (13)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| cds_gseg_pr_sua_ext | view_entity | from | Ext. view on Seg. Profile Sub Appls | |
| cds_gseg_pr_sua_ext | view_entity | union_all | Ext. view on Seg. Profile Sub Appls | |
| CUAN_CDS_TARGET_GROUP_SRCH | view | left_outer | Search Target Groups | |
| cuan_crp_expdef_at_usage | view | left_outer | Attribute Usage in Export Definition | |
| cuan_crp_segmodel_at_usage | view | left_outer | Attribute Usage in Segmentation Models | |
| CUAN_EXP_DEF_ATTRIBUTES | view | inner | Attributes of Export Definition | |
| CUAN_PM_SCP_ADT | view | inner | Applicable Scope for ADT (Runtime) | |
| CUAN_PREDICTIVE_SCENARIO | view | left_outer | AT_SEARCH_PRED_SCENARIO | |
| CUAN_TG_WITH_NAMES_SEARCH | view | left_outer | AT_SEARCH_TARGET_GROUP_WITH_NAMES | |
| 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_MKT_CmpgnCntntReuseSegmtn | view | from | BASIC | Campaign Content: Reusable Block Segmentation Profiles |
Fields (9)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | appl_id | gseg_v_appl_id | ||||
| KEY | pr_id | gseg_v_pr_id | ||||
| 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 |
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 G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSEG_PROFILE (
CLIENT, -- Client [mandt]
APPL_ID, -- gseg_v_appl_id
PR_ID, -- gseg_v_pr_id
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
PRIMARY KEY (CLIENT, APPL_ID, PR_ID)
);
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