KSR_TS_WS_SUM

Transparent Table Temporary Data

KSR: Tenant Specific Gateway Subrecords (Totals)

KSR_TS_WS_SUM is an SAP database table in S/4HANA. KSR: Tenant Specific Gateway Subrecords (Totals). It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
KSR_I_TS_WS_SUM_R view from KSR: Tenant Single Web Service Totals

Fields (17)

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
number_of_calls ksr_v_value Value
total_response_time_consumer ksr_v_value Value
total_response_time_provider ksr_v_value Value
total_message_size_consumer ksr_v_value Value
total_message_size_provider ksr_v_value Value
calls_location_p ksr_v_value Value
calls_location_c ksr_v_value Value
calls_protocol_w ksr_v_value Value
calls_protocol_p ksr_v_value Value
synchronous_calls ksr_v_value Value
shortcut_calls 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 Gateway Subrecords (Totals)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_TS_WS_SUM (
    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]
    NUMBER_OF_CALLS,               -- Value [ksr_v_value]
    TOTAL_RESPONSE_TIME_CONSUMER,  -- Value [ksr_v_value]
    TOTAL_RESPONSE_TIME_PROVIDER,  -- Value [ksr_v_value]
    TOTAL_MESSAGE_SIZE_CONSUMER,   -- Value [ksr_v_value]
    TOTAL_MESSAGE_SIZE_PROVIDER,   -- Value [ksr_v_value]
    CALLS_LOCATION_P,              -- Value [ksr_v_value]
    CALLS_LOCATION_C,              -- Value [ksr_v_value]
    CALLS_PROTOCOL_W,              -- Value [ksr_v_value]
    CALLS_PROTOCOL_P,              -- Value [ksr_v_value]
    SYNCHRONOUS_CALLS,             -- Value [ksr_v_value]
    SHORTCUT_CALLS,                -- Value [ksr_v_value]
    RETENTION_TIMESTAMP,           -- Time Stamp [timestamp]
    PRIMARY KEY (CLIENT, INSTANCE, RECORD_NUMBER, START_TIME, SUBRECORD_NUMBER)
);