GSEG_OT_DS_AT
Segmentation Object Datasource Attributes
GSEG_OT_DS_AT is an SAP database table in S/4HANA. Segmentation Object Datasource Attributes. It contains 45 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| cds_gseg_ot_ds_at | view_entity | from | Segm. Objects and Attributes with Labels | |
| cuan_crp_seg_at_config | view | from | Attribute Visibility in Configuration | |
| cuan_crp_seg_at_config | view | union | Attribute Visibility in Configuration | |
| CUAN_PM_SCP_ADT | view | inner | Applicable Scope for ADT (Runtime) |
Fields (45)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | appl_id | gseg_v_appl_id | ||||
| KEY | ot_id | gseg_v_obj_type | ||||
| KEY | ds_alias | gseg_v_ds_alias | ||||
| KEY | at_name | gseg_v_at_name | ||||
| at_type | gseg_v_at_type | |||||
| at_data_type | gseg_v_at_data_type | |||||
| at_len | gseg_v_at_len | |||||
| at_dec | gseg_v_at_dec | |||||
| at_as_dim | gseg_v_at_as_dim | |||||
| at_mand_kf_dim | gseg_v_mand_kf_dim | |||||
| at_th_kind | gseg_v_at_th_kind | |||||
| grp_name | gseg_v_grp_name | |||||
| at_vis | gseg_v_at_vis | |||||
| kf_aggr_type | gseg_v_kf_aggr_type | |||||
| at_sem_type | gseg_v_semantic_type | |||||
| kf_type_var | gseg_v_kf_type_var | |||||
| at_name_desc | gseg_v_at_name_desc | |||||
| at_pos | gseg_v_at_position | |||||
| at_exp | gseg_v_at_exp | |||||
| at_name_dep | gseg_v_at_name_dep | |||||
| at_srid | gseg_v_srid | |||||
| at_ml | gseg_v_at_ml | |||||
| at_ml_pos | gseg_v_at_ml_pos | |||||
| at_ml_nav_url_1 | gseg_v_at_ml_nav_url | |||||
| at_ml_nav_url_2 | gseg_v_at_ml_nav_url | |||||
| at_ml_nav_url_3 | gseg_v_at_ml_nav_url | |||||
| at_ml_nav_url_4 | gseg_v_at_ml_nav_url | |||||
| at_tzone | gseg_v_at_tzone | |||||
| at_code_descr | gseg_v_at_code_descr_display | |||||
| at_case_sensitive | gseg_v_at_case_sensitivity | |||||
| vh_ds_usage | gseg_v_vh_ds_usage | |||||
| vh_ds_alias | gseg_v_vh_ds_alias | |||||
| vh_at_name_code | gseg_v_vh_at_name_code | |||||
| vh_at_name_desc | gseg_v_vh_at_name_desc | |||||
| vh_ds_mode | gseg_v_vh_ds_mode | |||||
| vh_ds_opt | gseg_v_vh_ds_option | |||||
| vh_val_chk | gseg_v_vh_val_chk | |||||
| ch_auth_bo | hpa_generic_object_type | |||||
| ch_auth_obj | xuobject | Object | ||||
| ch_auth_fld | xufield | Field Name | ||||
| lcs | gseg_v_md_lcs | |||||
| ld_comp | gseg_v_at_ld_comp | |||||
| ld_name | gseg_v_at_ld_name | |||||
| has_parent_at | gseg_v_at_name |
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 Object Datasource Attributes
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSEG_OT_DS_AT (
CLIENT, -- Client [mandt]
APPL_ID, -- gseg_v_appl_id
OT_ID, -- gseg_v_obj_type
DS_ALIAS, -- gseg_v_ds_alias
AT_NAME, -- gseg_v_at_name
AT_TYPE, -- gseg_v_at_type
AT_DATA_TYPE, -- gseg_v_at_data_type
AT_LEN, -- gseg_v_at_len
AT_DEC, -- gseg_v_at_dec
AT_AS_DIM, -- gseg_v_at_as_dim
AT_MAND_KF_DIM, -- gseg_v_mand_kf_dim
AT_TH_KIND, -- gseg_v_at_th_kind
GRP_NAME, -- gseg_v_grp_name
AT_VIS, -- gseg_v_at_vis
KF_AGGR_TYPE, -- gseg_v_kf_aggr_type
AT_SEM_TYPE, -- gseg_v_semantic_type
KF_TYPE_VAR, -- gseg_v_kf_type_var
AT_NAME_DESC, -- gseg_v_at_name_desc
AT_POS, -- gseg_v_at_position
AT_EXP, -- gseg_v_at_exp
AT_NAME_DEP, -- gseg_v_at_name_dep
AT_SRID, -- gseg_v_srid
AT_ML, -- gseg_v_at_ml
AT_ML_POS, -- gseg_v_at_ml_pos
AT_ML_NAV_URL_1, -- gseg_v_at_ml_nav_url
AT_ML_NAV_URL_2, -- gseg_v_at_ml_nav_url
AT_ML_NAV_URL_3, -- gseg_v_at_ml_nav_url
AT_ML_NAV_URL_4, -- gseg_v_at_ml_nav_url
AT_TZONE, -- gseg_v_at_tzone
AT_CODE_DESCR, -- gseg_v_at_code_descr_display
AT_CASE_SENSITIVE, -- gseg_v_at_case_sensitivity
VH_DS_USAGE, -- gseg_v_vh_ds_usage
VH_DS_ALIAS, -- gseg_v_vh_ds_alias
VH_AT_NAME_CODE, -- gseg_v_vh_at_name_code
VH_AT_NAME_DESC, -- gseg_v_vh_at_name_desc
VH_DS_MODE, -- gseg_v_vh_ds_mode
VH_DS_OPT, -- gseg_v_vh_ds_option
VH_VAL_CHK, -- gseg_v_vh_val_chk
CH_AUTH_BO, -- hpa_generic_object_type
CH_AUTH_OBJ, -- Object [xuobject]
CH_AUTH_FLD, -- Field Name [xufield]
LCS, -- gseg_v_md_lcs
LD_COMP, -- gseg_v_at_ld_comp
LD_NAME, -- gseg_v_at_ld_name
HAS_PARENT_AT, -- gseg_v_at_name
PRIMARY KEY (CLIENT, APPL_ID, OT_ID, DS_ALIAS, AT_NAME)
);
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