KSR_I_TS_WS_PROVIDER_R
KSR: Tenant Single Web Service Provider
KSR_I_TS_WS_PROVIDER_R is a CDS View that provides data about "KSR: Tenant Single Web Service Provider" in SAP S/4HANA. It reads from 1 data source (ksr_ts_ws) and exposes 20 fields with key fields Client, Instance, Record_Number, Start_Time, Subrecord_Number.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| ksr_ts_ws | ksr_ts_ws | from |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | KSR_ITSWSPR | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | KSR: Tenant Single Web Service Provider | view | |
| ClientHandling.type | #CLIENT_DEPENDENT | view |
Fields (20)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Client | ksr_ts_ws | client | Workflow definition: Client |
| KEY | Instance | ksr_ts_ws | instance | TaskCount |
| KEY | Record_Number | ksr_ts_ws | record_number | INT4 |
| KEY | Start_Time | ksr_ts_ws | start_time | Time Stamp |
| KEY | Subrecord_Number | ksr_ts_ws | subrecord_number | |
| Location | ksr_ts_ws | location | Text | |
| Protocol | ksr_ts_ws | protocol | Single-Character Flag | |
| Proxy_Object | ksr_ts_ws | proxy_object | Proxy Class | |
| Proxy_Object_Type | ksr_ts_ws | proxy_object_type | Proxy Object Type | |
| Operation | ksr_ts_ws | operation | Transaction | |
| Logical_Port | ksr_ts_ws | logical_port | Logical Port | |
| Message_ID | ksr_ts_ws | messageid | Message ID | |
| Synchronous | ksr_ts_ws | synchronous | Communication Type | |
| Esr_Modeled | ksr_ts_ws | esr_modeled | ESR Modeled | |
| Shortcut | ksr_ts_ws | shortcut | Shortcut Case | |
| Response_Time | ksr_ts_ws | response_time | Value | |
| Message_Size | ksr_ts_ws | message_size | Value | |
| Retention_Timestamp | ksr_ts_ws | retention_timestamp | Time Stamp | |
| Tenant_Group | ksr_ts_main | tenant_group | Tenant Authorization | |
| User_Group | ksr_ts_main | user_group | User Group |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view KSR_I_TS_WS_PROVIDER_R.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: KSR_ITSWSPR
CREATE VIEW KSR_I_TS_WS_PROVIDER_R AS
SELECT
ksr_ts_ws.client AS Client,
ksr_ts_ws.instance AS Instance,
ksr_ts_ws.record_number AS Record_Number,
ksr_ts_ws.start_time AS Start_Time,
ksr_ts_ws.subrecord_number AS Subrecord_Number,
ksr_ts_ws.location AS Location,
ksr_ts_ws.protocol AS Protocol,
ksr_ts_ws.proxy_object AS Proxy_Object,
ksr_ts_ws.proxy_object_type AS Proxy_Object_Type,
ksr_ts_ws.operation AS Operation,
ksr_ts_ws.logical_port AS Logical_Port,
ksr_ts_ws.messageid AS Message_ID,
ksr_ts_ws.synchronous AS Synchronous,
ksr_ts_ws.esr_modeled AS Esr_Modeled,
ksr_ts_ws.shortcut AS Shortcut,
ksr_ts_ws.response_time AS Response_Time,
ksr_ts_ws.message_size AS Message_Size,
ksr_ts_ws.retention_timestamp AS Retention_Timestamp,
ksr_ts_main.tenant_group AS Tenant_Group,
ksr_ts_main.user_group AS User_Group
FROM ksr_ts_ws
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA