KSR_XM_SQL_STMT

Transparent Table Temporary Data
12 Fields 1 CDS Views

KSR: SQL Statements

KSR_XM_SQL_STMT is an SAP database table in S/4HANA. KSR: SQL Statements. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
KSR_I_XM_SQL_STATEMENT_R view_entity from KSR: SQL Statement

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY statement_hash ksr_cr_v_statement_hash Statement Hash
KEY connection_name ksr_cr_v_id ID
schema_name abap.char
appl_source abap.char
keyword abap.char
pobj_type abap.char
obj_type abap.char
obj_name abap.char
devclass devclass Package
statement_string ksr_cr_v_string String
created_at abap.dats
last_used_at abap.dats

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: SQL Statements
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_XM_SQL_STMT (
    STATEMENT_HASH,    -- Statement Hash [ksr_cr_v_statement_hash]
    CONNECTION_NAME,   -- ID [ksr_cr_v_id]
    SCHEMA_NAME,       -- abap.char
    APPL_SOURCE,       -- abap.char
    KEYWORD,           -- abap.char
    POBJ_TYPE,         -- abap.char
    OBJ_TYPE,          -- abap.char
    OBJ_NAME,          -- abap.char
    DEVCLASS,          -- Package [devclass]
    STATEMENT_STRING,  -- String [ksr_cr_v_string]
    CREATED_AT,        -- abap.dats
    LAST_USED_AT,      -- abap.dats
    PRIMARY KEY (STATEMENT_HASH, CONNECTION_NAME)
);

Learn More