KSR_TA_MAIN

Transparent Table Temporary Data
39 Fields 1 CDS Views

KSR: Tenant specific workload (basic metrics)

KSR_TA_MAIN is an SAP database table in S/4HANA. KSR: Tenant specific workload (basic metrics). It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
KSR_I_TA_WORKLOAD_R view from KSR: Tenant Aggregated Workload

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY tenant_id SLIC_SYSID System ID
KEY instance MSNAME2 AS Instance
KEY timestamp_id abap.char
KEY user_group KSR_CR_V_USER_GROUP User Group
KEY tenant_group KSR_CR_V_TENANT_AUTH_GROUP Tenant Authorization
KEY run_id KSR_V_RUN_ID Run ID
KEY workload_id KSR_V_WORKLOAD_ID Workload ID
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
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
work_process_type KSR_V_WORK_PROCESS_TYPE Work Process Type
encrypted KSR_V_ENCRYPTION Encryption
wmpc_id KSR_V_WMPC_ID WMPC ID
wmpc_variant KSR_V_WMPC_VARIANT WMPC Variant
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
number_of_main_records 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
dispatcher_wait_time KSR_V_VALUE Value
load_times KSR_V_VALUE Value
roll_times KSR_V_VALUE Value
cpu_time_db KSR_V_VALUE Value
max_server_response_time KSR_V_VALUE Value

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 workload (basic metrics)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_TA_MAIN (
    CLIENT,                     -- Client [MANDT]
    TENANT_ID,                  -- System ID [SLIC_SYSID]
    INSTANCE,                   -- AS Instance [MSNAME2]
    TIMESTAMP_ID,               -- abap.char
    USER_GROUP,                 -- User Group [KSR_CR_V_USER_GROUP]
    TENANT_GROUP,               -- Tenant Authorization [KSR_CR_V_TENANT_AUTH_GROUP]
    RUN_ID,                     -- Run ID [KSR_V_RUN_ID]
    WORKLOAD_ID,                -- Workload ID [KSR_V_WORKLOAD_ID]
    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]
    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]
    WORK_PROCESS_TYPE,          -- Work Process Type [KSR_V_WORK_PROCESS_TYPE]
    ENCRYPTED,                  -- Encryption [KSR_V_ENCRYPTION]
    WMPC_ID,                    -- WMPC ID [KSR_V_WMPC_ID]
    WMPC_VARIANT,               -- WMPC Variant [KSR_V_WMPC_VARIANT]
    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]
    NUMBER_OF_MAIN_RECORDS,     -- 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]
    DISPATCHER_WAIT_TIME,       -- Value [KSR_V_VALUE]
    LOAD_TIMES,                 -- Value [KSR_V_VALUE]
    ROLL_TIMES,                 -- Value [KSR_V_VALUE]
    CPU_TIME_DB,                -- Value [KSR_V_VALUE]
    MAX_SERVER_RESPONSE_TIME,   -- Value [KSR_V_VALUE]
    PRIMARY KEY (CLIENT, TENANT_ID, INSTANCE, TIMESTAMP_ID, USER_GROUP, TENANT_GROUP, RUN_ID, WORKLOAD_ID)
);

Learn More