KSR_TS_WS
KSR: Tenant Specific Web Service Records
KSR_TS_WS is an SAP database table in S/4HANA. KSR: Tenant Specific Web Service Records. It contains 21 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 Web Service Records
-- 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA