KSR_TS_MAIN

Transparent Table Temporary Data
58 Fields 2 CDS Views

KSR: Tenant Specific Main Records

KSR_TS_MAIN is an SAP database table in S/4HANA. KSR: Tenant Specific Main Records. It contains 58 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
KSR_I_TS_MAIN_R view from KSR: Tenant Single Main Records
KSR_I_TS_TRACESPAN_R view union KSR: Tenant Single Trace Span Subrecords

Fields (58)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY tenant_id slic_sysid System ID
KEY instance msname2 AS Instance
KEY record_number abap.int4 Single Record Number
KEY start_time timestampl Time Stamp
end_time timestampl Time Stamp
work_process_id abap.int4
root_context_id pfrootcontextid Root Context ID
transaction_id pftransid Tran.ID
user_id syst_uname User Name
user_id_epp pfuserid User ID
tenant_group ksr_cr_v_tenant_auth_group Tenant Authorization
user_group ksr_cr_v_user_group User Group
task_type ksr_v_task_type Task Type
task_priority ksr_v_task_priority Priority
program_name ksr_v_program_name Program Name
program_context ksr_v_program_context Type
transaction_code ksr_v_tcode Transaction
work_process_type ksr_v_work_process_type Work Process Type
number_of_db_requests ksr_v_value Value
number_of_db_rows ksr_v_value Value
processing_time_db_on_srv ksr_v_value Value
processing_time_db ksr_v_value Value
prepare_time_db ksr_v_value Value
network_time_db ksr_v_value Value
max_memory_db ksr_v_value Value
work_process_time ksr_v_value Value
server_response_time ksr_v_value Value
processing_time ksr_v_value Value
cpu_time ksr_v_value Value
rfc_time ksr_v_value Value
roll_wait_time ksr_v_value Value
enqueue_time ksr_v_value Value
load_times ksr_v_value Value
roll_times ksr_v_value Value
dispatcher_wait_time ksr_v_value Value
total_memory ksr_v_value Value
cpu_time_db ksr_v_value Value
retention_time abap.int4 Retention Time in Seconds
retention_timestamp timestamp Time Stamp
timestamp_id ksr_cr_v_timestamp_id Timestamp ID
extended_memory ksr_v_value Value
max_memory_ta ksr_v_value Value
max_memory_st ksr_v_value Value
heap_memory ksr_v_value Value
max_heap_memory ksr_v_value Value
page_memory ksr_v_value Value
request_entry_name ksr_v_request_entry_name Request Entry Name
request_entry_type ksr_v_request_entry_type Request Entry Type
request_entry_type_raw srequest_type Request Entry Type
encrypted ksr_v_encryption Encryption
session_id abap.char KSR: Session ID
dialog_step_number abap.int4
wl_rating ksr_v_rating Rating
wmpc_id ksr_v_wmpc_id WMPC ID
wmpc_variant ksr_v_wmpc_variant WMPC Variant
wmpc_create_ts timestampl Time Stamp
attributes_hash_value abap.char

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 Main Records
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_TS_MAIN (
    CLIENT,                     -- Client [mandt]
    TENANT_ID,                  -- System ID [slic_sysid]
    INSTANCE,                   -- AS Instance [msname2]
    RECORD_NUMBER,              -- Single Record Number [abap.int4]
    START_TIME,                 -- Time Stamp [timestampl]
    END_TIME,                   -- Time Stamp [timestampl]
    WORK_PROCESS_ID,            -- abap.int4
    ROOT_CONTEXT_ID,            -- Root Context ID [pfrootcontextid]
    TRANSACTION_ID,             -- Tran.ID [pftransid]
    USER_ID,                    -- User Name [syst_uname]
    USER_ID_EPP,                -- User ID [pfuserid]
    TENANT_GROUP,               -- Tenant Authorization [ksr_cr_v_tenant_auth_group]
    USER_GROUP,                 -- User Group [ksr_cr_v_user_group]
    TASK_TYPE,                  -- Task Type [ksr_v_task_type]
    TASK_PRIORITY,              -- Priority [ksr_v_task_priority]
    PROGRAM_NAME,               -- Program Name [ksr_v_program_name]
    PROGRAM_CONTEXT,            -- Type [ksr_v_program_context]
    TRANSACTION_CODE,           -- Transaction [ksr_v_tcode]
    WORK_PROCESS_TYPE,          -- Work Process Type [ksr_v_work_process_type]
    NUMBER_OF_DB_REQUESTS,      -- Value [ksr_v_value]
    NUMBER_OF_DB_ROWS,          -- Value [ksr_v_value]
    PROCESSING_TIME_DB_ON_SRV,  -- Value [ksr_v_value]
    PROCESSING_TIME_DB,         -- Value [ksr_v_value]
    PREPARE_TIME_DB,            -- Value [ksr_v_value]
    NETWORK_TIME_DB,            -- Value [ksr_v_value]
    MAX_MEMORY_DB,              -- Value [ksr_v_value]
    WORK_PROCESS_TIME,          -- Value [ksr_v_value]
    SERVER_RESPONSE_TIME,       -- Value [ksr_v_value]
    PROCESSING_TIME,            -- Value [ksr_v_value]
    CPU_TIME,                   -- Value [ksr_v_value]
    RFC_TIME,                   -- Value [ksr_v_value]
    ROLL_WAIT_TIME,             -- Value [ksr_v_value]
    ENQUEUE_TIME,               -- Value [ksr_v_value]
    LOAD_TIMES,                 -- Value [ksr_v_value]
    ROLL_TIMES,                 -- Value [ksr_v_value]
    DISPATCHER_WAIT_TIME,       -- Value [ksr_v_value]
    TOTAL_MEMORY,               -- Value [ksr_v_value]
    CPU_TIME_DB,                -- Value [ksr_v_value]
    RETENTION_TIME,             -- Retention Time in Seconds [abap.int4]
    RETENTION_TIMESTAMP,        -- Time Stamp [timestamp]
    TIMESTAMP_ID,               -- Timestamp ID [ksr_cr_v_timestamp_id]
    EXTENDED_MEMORY,            -- Value [ksr_v_value]
    MAX_MEMORY_TA,              -- Value [ksr_v_value]
    MAX_MEMORY_ST,              -- Value [ksr_v_value]
    HEAP_MEMORY,                -- Value [ksr_v_value]
    MAX_HEAP_MEMORY,            -- Value [ksr_v_value]
    PAGE_MEMORY,                -- Value [ksr_v_value]
    REQUEST_ENTRY_NAME,         -- Request Entry Name [ksr_v_request_entry_name]
    REQUEST_ENTRY_TYPE,         -- Request Entry Type [ksr_v_request_entry_type]
    REQUEST_ENTRY_TYPE_RAW,     -- Request Entry Type [srequest_type]
    ENCRYPTED,                  -- Encryption [ksr_v_encryption]
    SESSION_ID,                 -- KSR: Session ID [abap.char]
    DIALOG_STEP_NUMBER,         -- abap.int4
    WL_RATING,                  -- Rating [ksr_v_rating]
    WMPC_ID,                    -- WMPC ID [ksr_v_wmpc_id]
    WMPC_VARIANT,               -- WMPC Variant [ksr_v_wmpc_variant]
    WMPC_CREATE_TS,             -- Time Stamp [timestampl]
    ATTRIBUTES_HASH_VALUE,      -- abap.char
    PRIMARY KEY (CLIENT, TENANT_ID, INSTANCE, RECORD_NUMBER, START_TIME)
);

Learn More