SMN_TS_WORK_PRC

Transparent Table Temporary Data
45 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 45 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 (45)

KeyField Data ElementDescription DomainTypeLength
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 (
    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 (TENANT_ID, WP_INDEX)
);

Learn More