KSR_TS_MAIN

Transparent Table Temporary Data
56 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 56 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 (56)

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
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
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_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
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

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,              -- 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]
    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,             -- 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,                 -- 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]
    PRIMARY KEY (CLIENT, TENANT_ID, INSTANCE, RECORD_NUMBER, START_TIME)
);

Learn More