KSR_TA_SQL_STMT

Transparent Table Temporary Data
13 Fields 1 CDS Views

KSR: Tenant SQL Statements (basic metrics)

KSR_TA_SQL_STMT is an SAP database table in S/4HANA. KSR: Tenant SQL Statements (basic metrics). It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
KSR_I_TA_SQL_STMT_R view from KSR: Tenant Aggregated SQL Statements

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY tenant_id slic_sysid System ID
KEY instance msname2 AS Instance
KEY timestamp_id abap.char
KEY user_group ksr_cr_v_user_group User Group
KEY tenant_group ksr_cr_v_tenant_auth_group Tenant Authorization
KEY statement_hash ksr_cr_v_statement_hash Statement Hash
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

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 SQL Statements (basic metrics)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_TA_SQL_STMT (
    CLIENT,                -- Client [mandt]
    TENANT_ID,             -- System ID [slic_sysid]
    INSTANCE,              -- AS Instance [msname2]
    TIMESTAMP_ID,          -- abap.char
    USER_GROUP,            -- User Group [ksr_cr_v_user_group]
    TENANT_GROUP,          -- Tenant Authorization [ksr_cr_v_tenant_auth_group]
    STATEMENT_HASH,        -- Statement Hash [ksr_cr_v_statement_hash]
    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]
    PRIMARY KEY (CLIENT, TENANT_ID, INSTANCE, TIMESTAMP_ID, USER_GROUP, TENANT_GROUP, STATEMENT_HASH)
);

Learn More