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
KEY start_time TIMESTAMPL Time Stamp
KEY subrecord_number abap.int4
connection_name KSR_CR_V_ID ID
hash KSR_CR_V_STATEMENT_HASH Statement Hash
type abap.char
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,          -- abap.int4
    START_TIME,             -- Time Stamp [TIMESTAMPL]
    SUBRECORD_NUMBER,       -- abap.int4
    CONNECTION_NAME,        -- ID [KSR_CR_V_ID]
    HASH,                   -- Statement Hash [KSR_CR_V_STATEMENT_HASH]
    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