KSR_I_TS_HTTP_CL_R

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_CL_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_ITSHTTPCLR

CREATE VIEW KSR_I_TS_HTTP_CL_R AS
SELECT
  ksr_ts_http_cl.client AS Client,
  ksr_ts_http_cl.instance AS Instance,
  ksr_ts_http_cl.record_number AS Record_Number,
  ksr_ts_http_cl.start_time AS Start_Time,
  ksr_ts_http_cl.subrecord_number AS Subrecord_Number,
  ksr_ts_http_cl.call_number AS Call_Number,
  ksr_ts_http_cl.connection_id AS Connection_Id,
  ksr_ts_http_cl.communication_step AS Communication_Step,
  ksr_ts_http_cl.destination_name AS Destination_Name,
  ksr_ts_http_cl.host_name AS Host_Name,
  ksr_ts_http_cl.port AS Port,
  ksr_ts_http_cl.protocol AS Protocol,
  ksr_ts_http_cl.path AS Path,
  ksr_ts_http_cl.method AS Method,
  ksr_ts_http_cl.status_code AS Status_Code,
  ksr_ts_http_cl.status_phrase AS Status_Phrase,
  ksr_ts_http_cl.calling_time AS Calling_Time,
  ksr_ts_http_cl.remote_execution_time AS Remote_Execution_Time,
  ksr_ts_http_cl.idle_time AS Idle_Time,
  ksr_ts_http_cl.data_send_time AS Data_Send_Time,
  ksr_ts_http_cl.data_receive_time AS Data_Receive_Time,
  ksr_ts_http_cl.data_sent AS Data_Sent,
  ksr_ts_http_cl.data_received AS Data_Received,
  ksr_ts_http_cl.data_transferred AS Data_Transferred,
  ksr_ts_http_cl.timestamp AS Timestamp,
  ksr_ts_http_cl.retention_timestamp AS Retention_Timestamp,
  ksr_ts_main.user_group AS User_Group,
  ksr_ts_main.tenant_group AS Tenant_Group,
  com_out.Service_Name AS Service_Name,
  com_out.Service_Type AS Service_Type,
  com_out.H2_Name AS H2_Name,
  com_out.H1_Name AS H1_Name,
  com_out.H1_Type AS H1_Type,
  com_out.H1_Description AS H1_Description
FROM ksr_ts_http_cl
LEFT OUTER JOIN ksr_i_tm_com_out_r AS com_out ON /* join condition not captured in parsed metadata */
;