SMN_TS_SESSION

Transparent Table Temporary Data
30 Fields 1 CDS Views

SMN: Tenant Specific User Session Data

SMN_TS_SESSION is an SAP database table in S/4HANA. SMN: Tenant Specific User Session Data. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SMN_I_TS_Session_R view from SMN: Tenant Single Session Data

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY timestamp TIMESTAMP Time Stamp
KEY instance MSNAME2 AS Instance
KEY tenant_id SLIC_SYSID System ID
KEY logon_hdl SSI_LOGON_HDL Logon Key
KEY logon_id SSI_LOGON_ID Logon ID
KEY session_hdl SSI_SESSION_HDL Session Handle
timestamp_id KSR_CR_V_TIMESTAMP_ID Timestamp ID
tenant_group SMN_CR_V_TENANT_AUTH_GROUP Tenant Authorization
user_group SMN_CR_V_USER_GROUP User Group
user_name SSI_USER_NAME User ID
logon_type SSI_LOGON_TYPE Type
logon_sub_type SSI_LOGON_TYPE Type
location LVC_TXT132 Text
application LVC_TXT132 Text
application_info LVC_TXT132 Text
extended_memory SMN_V_VALUE Value
heap_memory SMN_V_VALUE Value
rfc_hdl LVC_TXT132 Text
rfc_type SSI_LOGON_TYPE Type
trace SSI_TRACE_LEVEL Trace Level
open_tasks SSI_OPEN_TASKS Open Tasks
act_program SSI_MAIN_PROGRAM Main Program
request_entry_name TMO_V_REQUEST_ENTRY_NAME Request Entry Name
request_entry_type_raw SREQUEST_TYPE Request Entry Type
wmpc_id abap.strg
wmpc_variant abap.strg
wmpc_created_at abap.strg
time_granularity INT1 INT1
time_period INT1 INT1

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.

-- SMN: Tenant Specific User Session Data
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SMN_TS_SESSION (
    CLIENT,                  -- Client [MANDT]
    TIMESTAMP,               -- Time Stamp [TIMESTAMP]
    INSTANCE,                -- AS Instance [MSNAME2]
    TENANT_ID,               -- System ID [SLIC_SYSID]
    LOGON_HDL,               -- Logon Key [SSI_LOGON_HDL]
    LOGON_ID,                -- Logon ID [SSI_LOGON_ID]
    SESSION_HDL,             -- Session Handle [SSI_SESSION_HDL]
    TIMESTAMP_ID,            -- Timestamp ID [KSR_CR_V_TIMESTAMP_ID]
    TENANT_GROUP,            -- Tenant Authorization [SMN_CR_V_TENANT_AUTH_GROUP]
    USER_GROUP,              -- User Group [SMN_CR_V_USER_GROUP]
    USER_NAME,               -- User ID [SSI_USER_NAME]
    LOGON_TYPE,              -- Type [SSI_LOGON_TYPE]
    LOGON_SUB_TYPE,          -- Type [SSI_LOGON_TYPE]
    LOCATION,                -- Text [LVC_TXT132]
    APPLICATION,             -- Text [LVC_TXT132]
    APPLICATION_INFO,        -- Text [LVC_TXT132]
    EXTENDED_MEMORY,         -- Value [SMN_V_VALUE]
    HEAP_MEMORY,             -- Value [SMN_V_VALUE]
    RFC_HDL,                 -- Text [LVC_TXT132]
    RFC_TYPE,                -- Type [SSI_LOGON_TYPE]
    TRACE,                   -- Trace Level [SSI_TRACE_LEVEL]
    OPEN_TASKS,              -- Open Tasks [SSI_OPEN_TASKS]
    ACT_PROGRAM,             -- Main Program [SSI_MAIN_PROGRAM]
    REQUEST_ENTRY_NAME,      -- Request Entry Name [TMO_V_REQUEST_ENTRY_NAME]
    REQUEST_ENTRY_TYPE_RAW,  -- Request Entry Type [SREQUEST_TYPE]
    WMPC_ID,                 -- abap.strg
    WMPC_VARIANT,            -- abap.strg
    WMPC_CREATED_AT,         -- abap.strg
    TIME_GRANULARITY,        -- INT1 [INT1]
    TIME_PERIOD,             -- INT1 [INT1]
    PRIMARY KEY (CLIENT, TIMESTAMP, INSTANCE, TENANT_ID, LOGON_HDL, LOGON_ID, SESSION_HDL)
);

Learn More