KSR_I_TS_WS_PROVIDER_R

DDL: KSR_I_TS_WS_PROVIDER_R SQL: KSR_ITSWSPR Type: view

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)

SourceAliasJoin Type
ksr_ts_ws ksr_ts_ws from

Annotations (6)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
;