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