KSR_TS_STMTHASH

Transparent Table Temporary Data
16 Fields 1 CDS Views

KSR: Tenant Specific Statement Hash Subrecords

KSR_TS_STMTHASH is an SAP database table in S/4HANA. KSR: Tenant Specific Statement Hash Subrecords. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
KSR_I_TS_STMTHASH_R view from KSR: Tenant Single Statement Hashes

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY instance msname2 AS Instance
KEY record_number abap.int4 Single Record Number
KEY start_time timestampl Time Stamp
KEY subrecord_number abap.int4 Number of Sucrecord Belonging to One Single Record
connection_name ksr_cr_v_id ID
hash ksr_cr_v_statement_hash Statement Hash
type abap.char Statement Type
execution_count ksr_v_value Value
record_count ksr_v_value Value
processing_time ksr_v_value Value
hana_cpu_time ksr_v_value Value
hana_max_mem ksr_v_value Value
hana_processing_time ksr_v_value Value
hana_preparation_time ksr_v_value Value
retention_timestamp timestamp Time Stamp

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.

-- KSR: Tenant Specific Statement Hash Subrecords
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_TS_STMTHASH (
    CLIENT,                 -- Client [mandt]
    INSTANCE,               -- AS Instance [msname2]
    RECORD_NUMBER,          -- Single Record Number [abap.int4]
    START_TIME,             -- Time Stamp [timestampl]
    SUBRECORD_NUMBER,       -- Number of Sucrecord Belonging to One Single Record [abap.int4]
    CONNECTION_NAME,        -- ID [ksr_cr_v_id]
    HASH,                   -- Statement Hash [ksr_cr_v_statement_hash]
    TYPE,                   -- Statement Type [abap.char]
    EXECUTION_COUNT,        -- Value [ksr_v_value]
    RECORD_COUNT,           -- Value [ksr_v_value]
    PROCESSING_TIME,        -- Value [ksr_v_value]
    HANA_CPU_TIME,          -- Value [ksr_v_value]
    HANA_MAX_MEM,           -- Value [ksr_v_value]
    HANA_PROCESSING_TIME,   -- Value [ksr_v_value]
    HANA_PREPARATION_TIME,  -- Value [ksr_v_value]
    RETENTION_TIMESTAMP,    -- Time Stamp [timestamp]
    PRIMARY KEY (CLIENT, INSTANCE, RECORD_NUMBER, START_TIME, SUBRECORD_NUMBER)
);

Learn More