GSEG_OT_KEY

Transparent Table Temporary Data

Segmentation Object Key

GSEG_OT_KEY is an SAP database table in S/4HANA. Segmentation Object Key. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CDS_GSEG_OT_KEY view_entity left_outer Segmentation Objects with Keys
CUAN_TG_CDS_OT_MAP_KEY_AND_SEM view_entity left_outer Semantics of Segmentation Object Keys

Fields (10)

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 ot_key GSEG_V_OT_KEY_NAME Object Key Field
ot_key_data_type GSEG_V_OT_KEY_DATA_TYPE Key Field Data Type
ot_key_len GSEG_V_OT_KEY_LEN Key Field Length
ot_key_dec GSEG_V_OT_KEY_DEC Key Decimals
ot_key_derived GSEG_V_OT_KEY_DERIVED Derived
ot_key_sem_type GSEG_V_SEM_TYPE_OT_KEY Semantic Type
semantic_object /UI2/SEMANTIC_OBJECT Semantic Object

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 Key
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GSEG_OT_KEY (
    CLIENT,            -- Client [MANDT]
    APPL_ID,           -- Application ID [GSEG_V_APPL_ID]
    OT_ID,             -- Segm. Object [GSEG_V_OBJ_TYPE]
    OT_KEY,            -- Object Key Field [GSEG_V_OT_KEY_NAME]
    OT_KEY_DATA_TYPE,  -- Key Field Data Type [GSEG_V_OT_KEY_DATA_TYPE]
    OT_KEY_LEN,        -- Key Field Length [GSEG_V_OT_KEY_LEN]
    OT_KEY_DEC,        -- Key Decimals [GSEG_V_OT_KEY_DEC]
    OT_KEY_DERIVED,    -- Derived [GSEG_V_OT_KEY_DERIVED]
    OT_KEY_SEM_TYPE,   -- Semantic Type [GSEG_V_SEM_TYPE_OT_KEY]
    SEMANTIC_OBJECT,   -- Semantic Object [/UI2/SEMANTIC_OBJECT]
    PRIMARY KEY (CLIENT, APPL_ID, OT_ID, OT_KEY)
);