GSEG_OT_DS_AT

Transparent Table Temporary Data
45 Fields 1 CDS Views

Segmentation Object Datasource Attributes

GSEG_OT_DS_AT is an SAP database table in S/4HANA. Segmentation Object Datasource Attributes. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
cds_gseg_ot_ds_at view_entity from Segm. Objects and Attributes with Labels

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY appl_id GSEG_V_APPL_ID Application ID
KEY ot_id GSEG_V_OBJ_TYPE Segm. Object
KEY ds_alias GSEG_V_DS_ALIAS DS Alias
KEY at_name GSEG_V_AT_NAME Attribute Name
at_type GSEG_V_AT_TYPE Attr Type
at_data_type GSEG_V_AT_DATA_TYPE Data Type
at_len GSEG_V_AT_LEN Attr Length
at_dec GSEG_V_AT_DEC Attr Decimals
at_as_dim GSEG_V_AT_AS_DIM Vis Dimension
at_mand_kf_dim GSEG_V_MAND_KF_DIM Mandatory
at_th_kind GSEG_V_AT_TH_KIND Type of Threshold
grp_name GSEG_V_GRP_NAME Group
at_vis GSEG_V_AT_VIS Visible Attrib
kf_aggr_type GSEG_V_KF_AGGR_TYPE Aggregation Type
at_sem_type GSEG_V_SEMANTIC_TYPE Semantic Type
kf_type_var GSEG_V_KF_TYPE_VAR Input Parameter
at_name_desc GSEG_V_AT_NAME_DESC Attrib. Descr.
at_pos GSEG_V_AT_POSITION Position
at_exp GSEG_V_AT_EXP Avlble Export
at_name_dep GSEG_V_AT_NAME_DEP Dependent Attribute
at_srid GSEG_V_SRID Spatial Ref ID
at_ml GSEG_V_AT_ML Visible
at_ml_pos GSEG_V_AT_ML_POS Position
at_ml_nav_url_1 GSEG_V_AT_ML_NAV_URL Part of Navig. URL
at_ml_nav_url_2 GSEG_V_AT_ML_NAV_URL Part of Navig. URL
at_ml_nav_url_3 GSEG_V_AT_ML_NAV_URL Part of Navig. URL
at_ml_nav_url_4 GSEG_V_AT_ML_NAV_URL Part of Navig. URL
at_tzone GSEG_V_AT_TZONE Attribute Time Zone
at_code_descr GSEG_V_AT_CODE_DESCR_DISPLAY C/D Type
at_case_sensitive GSEG_V_AT_CASE_SENSITIVITY Case Sensitivity
vh_ds_usage GSEG_V_VH_DS_USAGE Use for C/D
vh_ds_alias GSEG_V_VH_DS_ALIAS Data Source Alias
vh_at_name_code GSEG_V_VH_AT_NAME_CODE Code Attribute
vh_at_name_desc GSEG_V_VH_AT_NAME_DESC Descript. Attribute
vh_ds_mode GSEG_V_VH_DS_MODE Value Help Mode
vh_ds_opt GSEG_V_VH_DS_OPTION Use for Value Help
vh_val_chk GSEG_V_VH_VAL_CHK Attr Inp Check
ch_auth_bo /UI2/SEMANTIC_OBJECT Semantic Object
ch_auth_obj XUOBJECT Object
ch_auth_fld XUFIELD Field Name
lcs GSEG_V_MD_LCS State
ld_comp GSEG_V_AT_LD_COMP Software Component for Attribute Log Domain
ld_name GSEG_V_AT_LD_NAME Name for Attribute Log Domain
has_parent_at GSEG_V_AT_NAME Attribute 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 L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSEG_OT_DS_AT (
    CLIENT,             -- Client [MANDT]
    APPL_ID,            -- Application ID [GSEG_V_APPL_ID]
    OT_ID,              -- Segm. Object [GSEG_V_OBJ_TYPE]
    DS_ALIAS,           -- DS Alias [GSEG_V_DS_ALIAS]
    AT_NAME,            -- Attribute Name [GSEG_V_AT_NAME]
    AT_TYPE,            -- Attr Type [GSEG_V_AT_TYPE]
    AT_DATA_TYPE,       -- Data Type [GSEG_V_AT_DATA_TYPE]
    AT_LEN,             -- Attr Length [GSEG_V_AT_LEN]
    AT_DEC,             -- Attr Decimals [GSEG_V_AT_DEC]
    AT_AS_DIM,          -- Vis Dimension [GSEG_V_AT_AS_DIM]
    AT_MAND_KF_DIM,     -- Mandatory [GSEG_V_MAND_KF_DIM]
    AT_TH_KIND,         -- Type of Threshold [GSEG_V_AT_TH_KIND]
    GRP_NAME,           -- Group [GSEG_V_GRP_NAME]
    AT_VIS,             -- Visible Attrib [GSEG_V_AT_VIS]
    KF_AGGR_TYPE,       -- Aggregation Type [GSEG_V_KF_AGGR_TYPE]
    AT_SEM_TYPE,        -- Semantic Type [GSEG_V_SEMANTIC_TYPE]
    KF_TYPE_VAR,        -- Input Parameter [GSEG_V_KF_TYPE_VAR]
    AT_NAME_DESC,       -- Attrib. Descr. [GSEG_V_AT_NAME_DESC]
    AT_POS,             -- Position [GSEG_V_AT_POSITION]
    AT_EXP,             -- Avlble Export [GSEG_V_AT_EXP]
    AT_NAME_DEP,        -- Dependent Attribute [GSEG_V_AT_NAME_DEP]
    AT_SRID,            -- Spatial Ref ID [GSEG_V_SRID]
    AT_ML,              -- Visible [GSEG_V_AT_ML]
    AT_ML_POS,          -- Position [GSEG_V_AT_ML_POS]
    AT_ML_NAV_URL_1,    -- Part of Navig. URL [GSEG_V_AT_ML_NAV_URL]
    AT_ML_NAV_URL_2,    -- Part of Navig. URL [GSEG_V_AT_ML_NAV_URL]
    AT_ML_NAV_URL_3,    -- Part of Navig. URL [GSEG_V_AT_ML_NAV_URL]
    AT_ML_NAV_URL_4,    -- Part of Navig. URL [GSEG_V_AT_ML_NAV_URL]
    AT_TZONE,           -- Attribute Time Zone [GSEG_V_AT_TZONE]
    AT_CODE_DESCR,      -- C/D Type [GSEG_V_AT_CODE_DESCR_DISPLAY]
    AT_CASE_SENSITIVE,  -- Case Sensitivity [GSEG_V_AT_CASE_SENSITIVITY]
    VH_DS_USAGE,        -- Use for C/D [GSEG_V_VH_DS_USAGE]
    VH_DS_ALIAS,        -- Data Source Alias [GSEG_V_VH_DS_ALIAS]
    VH_AT_NAME_CODE,    -- Code Attribute [GSEG_V_VH_AT_NAME_CODE]
    VH_AT_NAME_DESC,    -- Descript. Attribute [GSEG_V_VH_AT_NAME_DESC]
    VH_DS_MODE,         -- Value Help Mode [GSEG_V_VH_DS_MODE]
    VH_DS_OPT,          -- Use for Value Help [GSEG_V_VH_DS_OPTION]
    VH_VAL_CHK,         -- Attr Inp Check [GSEG_V_VH_VAL_CHK]
    CH_AUTH_BO,         -- Semantic Object [/UI2/SEMANTIC_OBJECT]
    CH_AUTH_OBJ,        -- Object [XUOBJECT]
    CH_AUTH_FLD,        -- Field Name [XUFIELD]
    LCS,                -- State [GSEG_V_MD_LCS]
    LD_COMP,            -- Software Component for Attribute Log Domain [GSEG_V_AT_LD_COMP]
    LD_NAME,            -- Name for Attribute Log Domain [GSEG_V_AT_LD_NAME]
    HAS_PARENT_AT,      -- Attribute Name [GSEG_V_AT_NAME]
    PRIMARY KEY (CLIENT, APPL_ID, OT_ID, DS_ALIAS, AT_NAME)
);

Learn More