SMN_TS_WORK_PRC

Transparent Table Temporary Data
48 Fields 2 CDS Views

SMN: Tenant Specific Work Process Data

SMN_TS_WORK_PRC is an SAP database table in S/4HANA. SMN: Tenant Specific Work Process Data. It contains 48 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
SMN_I_TS_STACK_R view from SMN: Tenant Single Stack Trace Data
SMN_I_TS_WORK_PROC_R view from SMN: Tenant Single Work Process Data

Fields (48)

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 wp_index SSI_WORKER_INDEX WP Number
timestamp_id KSR_CR_V_TIMESTAMP_ID Timestamp ID
pid SSI_WORKER_PID Process ID
tenant_group SMN_CR_V_TENANT_AUTH_GROUP Tenant Authorization
user_id SYST_UNAME User Name
user_group SMN_CR_V_USER_GROUP User Group
sem_locked SSI_SEM_LOCKED_DISP Locked Semaphore
task_priority KSR_V_TASK_PRIORITY Priority
memsum SMN_V_VALUE Value
heap_memory SMN_V_VALUE Value
logon_type SSI_LOGON_TYPE Type
logon_sub_type SSI_LOGON_TYPE Type
wp_type_raw WPITYPE Process cat.
request_entry_name TMO_V_REQUEST_ENTRY_NAME Request Entry Name
request_entry_type_raw SREQUEST_TYPE Request Entry Type
wmpc_id TMO_V_WMPC_ID WMPC ID
wmpc_variant TMO_V_WMPC_VARIANT WMPC Varian
wmpc_create_ts TIMESTAMPL Time Stamp
btcjobname BTCJOB Job Name
btcjobcnt BTCJOBCNT Job No.
session_id PFCONTEXTID Context ID
start_time TIMESTAMPL Time Stamp
transid PFTRANSID Tran.ID
transaction_code KSR_V_TCODE Transaction
dialog_step PFDIALOGSTEP Dialog Step
current_program_name SSI_PROGRAM Executed Program
current_event abap.char
current_line INT4 INT4
logon_hdl SSI_LOGON_HDL Logon Key
logon_id SSI_LOGON_ID Logon ID
session_hdl SSI_SESSION_HDL Session Handle
stack_trace_hash HASH160X Hash Value
time_granularity INT1 INT1
time_period INT1 INT1
cpu_sys_ms SMN_V_VALUE Value
cpu_usr_ms SMN_V_VALUE Value
cpu_tot_ms SMN_V_VALUE Value
deltatimems SMN_V_VALUE Value
cpu_system SMN_V_VALUE Value
cpu_user SMN_V_VALUE Value
number_of_db_rows_read SMN_V_VALUE Value
number_of_db_rows_wrt SMN_V_VALUE Value
processing_time_db_on_srv_read SMN_V_VALUE Value
processing_time_db_on_srv_wrt SMN_V_VALUE Value

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 Work Process Data
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SMN_TS_WORK_PRC (
    CLIENT,                          -- Client [MANDT]
    TIMESTAMP,                       -- Time Stamp [TIMESTAMP]
    INSTANCE,                        -- AS Instance [MSNAME2]
    TENANT_ID,                       -- System ID [SLIC_SYSID]
    WP_INDEX,                        -- WP Number [SSI_WORKER_INDEX]
    TIMESTAMP_ID,                    -- Timestamp ID [KSR_CR_V_TIMESTAMP_ID]
    PID,                             -- Process ID [SSI_WORKER_PID]
    TENANT_GROUP,                    -- Tenant Authorization [SMN_CR_V_TENANT_AUTH_GROUP]
    USER_ID,                         -- User Name [SYST_UNAME]
    USER_GROUP,                      -- User Group [SMN_CR_V_USER_GROUP]
    SEM_LOCKED,                      -- Locked Semaphore [SSI_SEM_LOCKED_DISP]
    TASK_PRIORITY,                   -- Priority [KSR_V_TASK_PRIORITY]
    MEMSUM,                          -- Value [SMN_V_VALUE]
    HEAP_MEMORY,                     -- Value [SMN_V_VALUE]
    LOGON_TYPE,                      -- Type [SSI_LOGON_TYPE]
    LOGON_SUB_TYPE,                  -- Type [SSI_LOGON_TYPE]
    WP_TYPE_RAW,                     -- Process cat. [WPITYPE]
    REQUEST_ENTRY_NAME,              -- Request Entry Name [TMO_V_REQUEST_ENTRY_NAME]
    REQUEST_ENTRY_TYPE_RAW,          -- Request Entry Type [SREQUEST_TYPE]
    WMPC_ID,                         -- WMPC ID [TMO_V_WMPC_ID]
    WMPC_VARIANT,                    -- WMPC Varian [TMO_V_WMPC_VARIANT]
    WMPC_CREATE_TS,                  -- Time Stamp [TIMESTAMPL]
    BTCJOBNAME,                      -- Job Name [BTCJOB]
    BTCJOBCNT,                       -- Job No. [BTCJOBCNT]
    SESSION_ID,                      -- Context ID [PFCONTEXTID]
    START_TIME,                      -- Time Stamp [TIMESTAMPL]
    TRANSID,                         -- Tran.ID [PFTRANSID]
    TRANSACTION_CODE,                -- Transaction [KSR_V_TCODE]
    DIALOG_STEP,                     -- Dialog Step [PFDIALOGSTEP]
    CURRENT_PROGRAM_NAME,            -- Executed Program [SSI_PROGRAM]
    CURRENT_EVENT,                   -- abap.char
    CURRENT_LINE,                    -- INT4 [INT4]
    LOGON_HDL,                       -- Logon Key [SSI_LOGON_HDL]
    LOGON_ID,                        -- Logon ID [SSI_LOGON_ID]
    SESSION_HDL,                     -- Session Handle [SSI_SESSION_HDL]
    STACK_TRACE_HASH,                -- Hash Value [HASH160X]
    TIME_GRANULARITY,                -- INT1 [INT1]
    TIME_PERIOD,                     -- INT1 [INT1]
    CPU_SYS_MS,                      -- Value [SMN_V_VALUE]
    CPU_USR_MS,                      -- Value [SMN_V_VALUE]
    CPU_TOT_MS,                      -- Value [SMN_V_VALUE]
    DELTATIMEMS,                     -- Value [SMN_V_VALUE]
    CPU_SYSTEM,                      -- Value [SMN_V_VALUE]
    CPU_USER,                        -- Value [SMN_V_VALUE]
    NUMBER_OF_DB_ROWS_READ,          -- Value [SMN_V_VALUE]
    NUMBER_OF_DB_ROWS_WRT,           -- Value [SMN_V_VALUE]
    PROCESSING_TIME_DB_ON_SRV_READ,  -- Value [SMN_V_VALUE]
    PROCESSING_TIME_DB_ON_SRV_WRT,   -- Value [SMN_V_VALUE]
    PRIMARY KEY (CLIENT, TIMESTAMP, INSTANCE, TENANT_ID, WP_INDEX)
);

Learn More