ksr_i_ts_http_srv_r

DDL: KSR_I_TS_HTTP_SRV_R SQL: KSR_ITSHTTPSRVR Type: view
27 Fields 1 Data Sources

KSR: Tenant Single HTTP Server

ksr_i_ts_http_srv_r is a CDS View that provides data about "KSR: Tenant Single HTTP Server" in SAP S/4HANA. It reads from 1 data source (ksr_ts_http_srv) and exposes 27 fields with key fields Client, Instance, Record_Number, Start_Time, Subrecord_Number.

Data Sources (1)

SourceAliasJoin Type
ksr_ts_http_srv ksr_ts_http_srv from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName KSR_ITSHTTPSRVR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label KSR: Tenant Single HTTP Server view
ClientHandling.type #CLIENT_DEPENDENT view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY Client ksr_ts_http_srv client Workflow definition: Client
KEY Instance ksr_ts_http_srv instance TaskCount
KEY Record_Number ksr_ts_http_srv record_number INT4
KEY Start_Time ksr_ts_http_srv start_time Time Stamp
KEY Subrecord_Number ksr_ts_http_srv subrecord_number
Timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
Call_Number call_number Value
Connection_Id connection_id Connection Id
Communication_Step communication_step Communication Step
Host_Name host_name IP Address
Virtual_Host_Number virtual_host_number Virtual Host Number
Port port Port rule
Protocol protocol Single-Character Flag
Path path Path rule
Method method Validation Method
Status_Code status_code Status Code
Status_Phrase status_phrase Status Phrase
Calling_Time calling_time Value
Local_Execution_Time local_execution_time Value
Idle_Time idle_time Value
Data_Send_Time data_send_time Value
Data_Receive_Time data_receive_time Value
Data_Sent data_sent Value
Data_Received data_received Value
Retention_Timestamp ksr_ts_http_srv retention_timestamp Time Stamp
User_Group ksr_ts_main user_group User Group
Tenant_Group ksr_ts_main tenant_group Tenant Authorization

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_http_srv_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_ITSHTTPSRVR

CREATE VIEW ksr_i_ts_http_srv_r AS
SELECT
  ksr_ts_http_srv.client AS Client,
  ksr_ts_http_srv.instance AS Instance,
  ksr_ts_http_srv.record_number AS Record_Number,
  ksr_ts_http_srv.start_time AS Start_Time,
  ksr_ts_http_srv.subrecord_number AS Subrecord_Number,
  Timestamp,
  Call_Number,
  Connection_Id,
  Communication_Step,
  Host_Name,
  Virtual_Host_Number,
  Port,
  Protocol,
  Path,
  Method,
  Status_Code,
  Status_Phrase,
  Calling_Time,
  Local_Execution_Time,
  Idle_Time,
  Data_Send_Time,
  Data_Receive_Time,
  Data_Sent,
  Data_Received,
  ksr_ts_http_srv.retention_timestamp AS Retention_Timestamp,
  ksr_ts_main.user_group AS User_Group,
  ksr_ts_main.tenant_group AS Tenant_Group
FROM ksr_ts_http_srv
;

Learn More