KSR_I_TS_STMTHASH_R

CDS View
19 Fields 1 CDS Views

KSR: Tenant Single Statement Hashes

KSR_I_TS_STMTHASH_R is a CDS View in S/4HANA. KSR: Tenant Single Statement Hashes. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
ksr_i_ts_stmtresolved_r view from KSR: Tenant Single Statements

Fields (19)

KeyField CDS FieldsUsed in Views
KEY client Client 1
KEY Instance Instance 1
KEY Record_Number Record_Number 1
KEY Start_Time Start_Time 1
KEY Subrecord_Number Subrecord_Number 1
Connection_Name Connection_Name 1
Execution_Count Execution_Count 1
Hana_Cpu_Time Hana_Cpu_Time 1
Hana_Execution_Time Hana_Execution_Time 1
Hana_Max_Memory Hana_Max_Memory 1
Hana_Preparation_Time Hana_Preparation_Time 1
Hana_Processing_Time Hana_Processing_Time 1
Processing_Time Processing_Time 1
Record_Count Record_Count 1
Retention_Timestamp Retention_Timestamp 1
Statement_Hash Statement_Hash 1
Statement_Type Statement_Type 1
Tenant_Group Tenant_Group 1
User_Group User_Group 1

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 Single Statement Hashes
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_I_TS_STMTHASH_R (
    CLIENT,
    INSTANCE,
    RECORD_NUMBER,
    START_TIME,
    SUBRECORD_NUMBER,
    CONNECTION_NAME,
    EXECUTION_COUNT,
    HANA_CPU_TIME,
    HANA_EXECUTION_TIME,
    HANA_MAX_MEMORY,
    HANA_PREPARATION_TIME,
    HANA_PROCESSING_TIME,
    PROCESSING_TIME,
    RECORD_COUNT,
    RETENTION_TIMESTAMP,
    STATEMENT_HASH,
    STATEMENT_TYPE,
    TENANT_GROUP,
    USER_GROUP,
    PRIMARY KEY (CLIENT, INSTANCE, RECORD_NUMBER, START_TIME, SUBRECORD_NUMBER)
);

Learn More