TMO_HTS_M_STS

Transparent Table Temporary Data
23 Fields 1 CDS Views

TMO_HTS: Replic.+Enriched Data from M_SERVICE_THREAD_SAMPLES

TMO_HTS_M_STS is an SAP database table in S/4HANA. TMO_HTS: Replic.+Enriched Data from M_SERVICE_THREAD_SAMPLES. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
tmo_i_ts_m_serv_thread_smps_r view from TMO-HTS: Data replicated from M_SERVICE_THREAD_SAMPLES

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY tenant_id slic_sysid System ID
KEY timestamp timestamp Time Stamp
KEY thread_id tmo_hts_v_thread_id
KEY host hdb_host Host
KEY port hdb_port Port
timestamp_id ksr_cr_v_timestamp_id Timestamp ID
thread_state char30 30 Characters
client_pid ssi_worker_pid Process ID
user_id syst_uname User Name
user_group smn_cr_v_user_group User Group
tenant_group smn_cr_v_tenant_auth_group Tenant Authorization
current_program_name ssi_program Executed Program
statement_hash ksr_cr_v_statement_hash Statement Hash
request_entry_name tmo_v_request_entry_name Request Entry Name
request_entry_type_raw srequest_type Request Entry Type
workload_class_name tmo_v_hana_workload_class
root_context_id pftransid Tran.ID
transaction_id pftransid Tran.ID
user_id_epp pfuserid User ID
cpu_time_self tmo_v_value
cpu_time_cumulative tmo_v_value
duration tmo_v_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.

-- TMO_HTS: Replic.+Enriched Data from M_SERVICE_THREAD_SAMPLES
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TMO_HTS_M_STS (
    CLIENT,                  -- Client [mandt]
    TENANT_ID,               -- System ID [slic_sysid]
    TIMESTAMP,               -- Time Stamp [timestamp]
    THREAD_ID,               -- tmo_hts_v_thread_id
    HOST,                    -- Host [hdb_host]
    PORT,                    -- Port [hdb_port]
    TIMESTAMP_ID,            -- Timestamp ID [ksr_cr_v_timestamp_id]
    THREAD_STATE,            -- 30 Characters [char30]
    CLIENT_PID,              -- Process ID [ssi_worker_pid]
    USER_ID,                 -- User Name [syst_uname]
    USER_GROUP,              -- User Group [smn_cr_v_user_group]
    TENANT_GROUP,            -- Tenant Authorization [smn_cr_v_tenant_auth_group]
    CURRENT_PROGRAM_NAME,    -- Executed Program [ssi_program]
    STATEMENT_HASH,          -- Statement Hash [ksr_cr_v_statement_hash]
    REQUEST_ENTRY_NAME,      -- Request Entry Name [tmo_v_request_entry_name]
    REQUEST_ENTRY_TYPE_RAW,  -- Request Entry Type [srequest_type]
    WORKLOAD_CLASS_NAME,     -- tmo_v_hana_workload_class
    ROOT_CONTEXT_ID,         -- Tran.ID [pftransid]
    TRANSACTION_ID,          -- Tran.ID [pftransid]
    USER_ID_EPP,             -- User ID [pfuserid]
    CPU_TIME_SELF,           -- tmo_v_value
    CPU_TIME_CUMULATIVE,     -- tmo_v_value
    DURATION,                -- tmo_v_value
    PRIMARY KEY (CLIENT, TENANT_ID, TIMESTAMP, THREAD_ID, HOST, PORT)
);

Learn More