KSR_TA_TRACEHIST

Transparent Table Temporary Data

KSR: Tenant Aggregate Trace Histograms

KSR_TA_TRACEHIST is an SAP database table in S/4HANA. KSR: Tenant Aggregate Trace Histograms. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
KSR_I_TA_TRACEHIST_R view from KSR: Tenant Aggregated Trace Histogram

Fields (34)

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 compound_key_id ksr_v_workload_id Workload ID
api_type tmo_cr_v_api_call_type
api_name tmo_cr_v_api_call_name
transaction_code ksr_v_tcode Transaction
request_entry_name ksr_v_request_entry_name Request Entry Name
request_entry_type_raw srequest_type Request Entry Type
wb_object_type trobjtype Object Type
wb_object_id sobj_name Object Name
wb_sub_object_type seu_objtyp Obj. Type
wb_sub_object_id aps_oda_sub_object_id Sub Object Name
oda_package_id tmo_cr_v_api_call_oda_pack_id
oda_assignment_id tmo_cr_v_api_call_oda_assgn_id
operation tmo_cr_v_api_call_operation
call_count ksr_v_value Value
call_time_sum ksr_v_value Value
call_time_max ksr_v_value Value
call_size ksr_v_value Value
call_time_bucket_100 ksr_v_value Value
call_time_bucket_250 ksr_v_value Value
call_time_bucket_500 ksr_v_value Value
call_time_bucket_1000 ksr_v_value Value
call_time_bucket_3000 ksr_v_value Value
call_time_bucket_5000 ksr_v_value Value
call_time_bucket_10000 ksr_v_value Value
call_time_bucket_20000 ksr_v_value Value
call_time_bucket_inf ksr_v_value Value
call_errors 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 Aggregate Trace Histograms
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_TA_TRACEHIST (
    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]
    COMPOUND_KEY_ID,         -- Workload ID [ksr_v_workload_id]
    API_TYPE,                -- tmo_cr_v_api_call_type
    API_NAME,                -- tmo_cr_v_api_call_name
    TRANSACTION_CODE,        -- Transaction [ksr_v_tcode]
    REQUEST_ENTRY_NAME,      -- Request Entry Name [ksr_v_request_entry_name]
    REQUEST_ENTRY_TYPE_RAW,  -- Request Entry Type [srequest_type]
    WB_OBJECT_TYPE,          -- Object Type [trobjtype]
    WB_OBJECT_ID,            -- Object Name [sobj_name]
    WB_SUB_OBJECT_TYPE,      -- Obj. Type [seu_objtyp]
    WB_SUB_OBJECT_ID,        -- Sub Object Name [aps_oda_sub_object_id]
    ODA_PACKAGE_ID,          -- tmo_cr_v_api_call_oda_pack_id
    ODA_ASSIGNMENT_ID,       -- tmo_cr_v_api_call_oda_assgn_id
    OPERATION,               -- tmo_cr_v_api_call_operation
    CALL_COUNT,              -- Value [ksr_v_value]
    CALL_TIME_SUM,           -- Value [ksr_v_value]
    CALL_TIME_MAX,           -- Value [ksr_v_value]
    CALL_SIZE,               -- Value [ksr_v_value]
    CALL_TIME_BUCKET_100,    -- Value [ksr_v_value]
    CALL_TIME_BUCKET_250,    -- Value [ksr_v_value]
    CALL_TIME_BUCKET_500,    -- Value [ksr_v_value]
    CALL_TIME_BUCKET_1000,   -- Value [ksr_v_value]
    CALL_TIME_BUCKET_3000,   -- Value [ksr_v_value]
    CALL_TIME_BUCKET_5000,   -- Value [ksr_v_value]
    CALL_TIME_BUCKET_10000,  -- Value [ksr_v_value]
    CALL_TIME_BUCKET_20000,  -- Value [ksr_v_value]
    CALL_TIME_BUCKET_INF,    -- Value [ksr_v_value]
    CALL_ERRORS,             -- Value [ksr_v_value]
    PRIMARY KEY (CLIENT, TENANT_ID, INSTANCE, TIMESTAMP_ID, USER_GROUP, TENANT_GROUP, RUN_ID, COMPOUND_KEY_ID)
);