KSR_TS_WS

Transparent Table Temporary Data

KSR: Tenant Specific Gateway Subrecords (Calls)

KSR_TS_WS is an SAP database table in S/4HANA. KSR: Tenant Specific Gateway Subrecords (Calls). It contains 21 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
KSR_I_TS_SERVICES_OUT_MAIN_R view union KSR: Tenant Single Outbound Services Main Records
KSR_I_TS_WS_CONSUMER_R view from KSR: Tenant Single Web Service Consumer
KSR_I_TS_WS_PROVIDER_R view from KSR: Tenant Single Web Service Provider

Fields (21)

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
location ksr_cr_v_ws_location Location
location_raw ksr_cr_v_ws_location_raw Location
protocol ksr_cr_v_ws_protocol Protocol
proxy_object ksr_cr_v_ws_proxy_class Proxy Class
proxy_object_type ksr_cr_v_ws_proxy_object_type Proxy Object Type
proxy_object_type_raw ksr_cr_v_ws_proxy_obj_type_raw Proxy Object Type
operation ksr_cr_v_ws_operation Operation
logical_port ksr_cr_v_ws_logical_port Logical Port
messageid ksr_cr_v_ws_message_id Message ID
synchronous ksr_cr_v_ws_communication_type Communication Type
esr_modeled ksr_cr_v_ws_esr_modeled ESR Modeled
shortcut ksr_cr_v_ws_shortcut Shortcut Case
response_time ksr_v_value Value
message_size ksr_v_value Value
retention_timestamp timestamp Time Stamp
end_time 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 Gateway Subrecords (Calls)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE KSR_TS_WS (
    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]
    LOCATION,               -- Location [ksr_cr_v_ws_location]
    LOCATION_RAW,           -- Location [ksr_cr_v_ws_location_raw]
    PROTOCOL,               -- Protocol [ksr_cr_v_ws_protocol]
    PROXY_OBJECT,           -- Proxy Class [ksr_cr_v_ws_proxy_class]
    PROXY_OBJECT_TYPE,      -- Proxy Object Type [ksr_cr_v_ws_proxy_object_type]
    PROXY_OBJECT_TYPE_RAW,  -- Proxy Object Type [ksr_cr_v_ws_proxy_obj_type_raw]
    OPERATION,              -- Operation [ksr_cr_v_ws_operation]
    LOGICAL_PORT,           -- Logical Port [ksr_cr_v_ws_logical_port]
    MESSAGEID,              -- Message ID [ksr_cr_v_ws_message_id]
    SYNCHRONOUS,            -- Communication Type [ksr_cr_v_ws_communication_type]
    ESR_MODELED,            -- ESR Modeled [ksr_cr_v_ws_esr_modeled]
    SHORTCUT,               -- Shortcut Case [ksr_cr_v_ws_shortcut]
    RESPONSE_TIME,          -- Value [ksr_v_value]
    MESSAGE_SIZE,           -- Value [ksr_v_value]
    RETENTION_TIMESTAMP,    -- Time Stamp [timestamp]
    END_TIME,               -- Time Stamp [timestampl]
    PRIMARY KEY (CLIENT, INSTANCE, RECORD_NUMBER, START_TIME, SUBRECORD_NUMBER)
);