KSR_TS_DBCON

Transparent Table Temporary Data
36 Fields 1 CDS Views

KSR: Tenant Specific Database Connection Subrecords

KSR_TS_DBCON is an SAP database table in S/4HANA. KSR: Tenant Specific Database Connection Subrecords. It contains 36 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
KSR_I_TS_DBCON_R view from KSR: Tenant Single DB Connection Subrecords

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY instance msname2 AS Instance
KEY record_number abap.int4 Single Record Number
KEY start_time timestampl Time Stamp
KEY subrecord_number abap.int4 Number of Sucrecord Belonging to One Single Record
connection_name ksr_cr_v_id ID
dir_read_request_count ksr_v_value Value
seq_read_request_count ksr_v_value Value
insert_request_count ksr_v_value Value
update_request_count ksr_v_value Value
delete_request_count ksr_v_value Value
physical_read_request_count ksr_v_value Value
physical_insert_request_count ksr_v_value Value
physical_update_request_count ksr_v_value Value
physical_delete_request_count ksr_v_value Value
dir_read_row_count ksr_v_value Value
seq_read_row_count ksr_v_value Value
insert_row_count ksr_v_value Value
update_row_count ksr_v_value Value
delete_row_count ksr_v_value Value
buffer_dir_read_row_count ksr_v_value Value
buffer_seq_read_row_count ksr_v_value Value
total_request_time ksr_v_value Value
dir_read_request_time ksr_v_value Value
seq_read_request_time ksr_v_value Value
insert_request_time ksr_v_value Value
update_request_time ksr_v_value Value
delete_request_time ksr_v_value Value
db_procedure_call_count ksr_v_value Value
db_procedure_time ksr_v_value Value
commit_time ksr_v_value Value
other_time ksr_v_value Value
hana_cpu_time_consumption ksr_v_value Value
hana_memory_consumption ksr_v_value Value
hana_processing_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 Database Connection Subrecords
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_TS_DBCON (
    CLIENT,                         -- Client [mandt]
    INSTANCE,                       -- AS Instance [msname2]
    RECORD_NUMBER,                  -- Single Record Number [abap.int4]
    START_TIME,                     -- Time Stamp [timestampl]
    SUBRECORD_NUMBER,               -- Number of Sucrecord Belonging to One Single Record [abap.int4]
    CONNECTION_NAME,                -- ID [ksr_cr_v_id]
    DIR_READ_REQUEST_COUNT,         -- Value [ksr_v_value]
    SEQ_READ_REQUEST_COUNT,         -- Value [ksr_v_value]
    INSERT_REQUEST_COUNT,           -- Value [ksr_v_value]
    UPDATE_REQUEST_COUNT,           -- Value [ksr_v_value]
    DELETE_REQUEST_COUNT,           -- Value [ksr_v_value]
    PHYSICAL_READ_REQUEST_COUNT,    -- Value [ksr_v_value]
    PHYSICAL_INSERT_REQUEST_COUNT,  -- Value [ksr_v_value]
    PHYSICAL_UPDATE_REQUEST_COUNT,  -- Value [ksr_v_value]
    PHYSICAL_DELETE_REQUEST_COUNT,  -- Value [ksr_v_value]
    DIR_READ_ROW_COUNT,             -- Value [ksr_v_value]
    SEQ_READ_ROW_COUNT,             -- Value [ksr_v_value]
    INSERT_ROW_COUNT,               -- Value [ksr_v_value]
    UPDATE_ROW_COUNT,               -- Value [ksr_v_value]
    DELETE_ROW_COUNT,               -- Value [ksr_v_value]
    BUFFER_DIR_READ_ROW_COUNT,      -- Value [ksr_v_value]
    BUFFER_SEQ_READ_ROW_COUNT,      -- Value [ksr_v_value]
    TOTAL_REQUEST_TIME,             -- Value [ksr_v_value]
    DIR_READ_REQUEST_TIME,          -- Value [ksr_v_value]
    SEQ_READ_REQUEST_TIME,          -- Value [ksr_v_value]
    INSERT_REQUEST_TIME,            -- Value [ksr_v_value]
    UPDATE_REQUEST_TIME,            -- Value [ksr_v_value]
    DELETE_REQUEST_TIME,            -- Value [ksr_v_value]
    DB_PROCEDURE_CALL_COUNT,        -- Value [ksr_v_value]
    DB_PROCEDURE_TIME,              -- Value [ksr_v_value]
    COMMIT_TIME,                    -- Value [ksr_v_value]
    OTHER_TIME,                     -- Value [ksr_v_value]
    HANA_CPU_TIME_CONSUMPTION,      -- Value [ksr_v_value]
    HANA_MEMORY_CONSUMPTION,        -- Value [ksr_v_value]
    HANA_PROCESSING_TIME,           -- Value [ksr_v_value]
    RETENTION_TIMESTAMP,            -- Time Stamp [timestamp]
    PRIMARY KEY (CLIENT, INSTANCE, RECORD_NUMBER, START_TIME, SUBRECORD_NUMBER)
);

Learn More