KSR_I_TA_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_TA_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_ITAHTTPCLR

CREATE VIEW KSR_I_TA_HTTP_CL_R AS
SELECT
  HTTP.client AS Client,
  HTTP.tenant_id AS Tenant_Id,
  HTTP.instance AS Instance,
  HTTP.timestamp_id AS Timestamp_Id,
  HTTP.user_group AS User_Group,
  HTTP.tenant_group AS Tenant_Group,
  HTTP.run_id AS Run_Id,
  HTTP.destination_name AS Destination_Name,
  HTTP.host_name AS Host_Name,
  HTTP.port AS Port,
  HTTP.protocol AS Protocol,
  HTTP.path AS Path,
  HTTP.method AS Method,
  HTTP.request_entry_name AS Request_Entry_Name,
  HTTP.request_entry_type_raw AS Request_Entry_Type_Raw,
  HTTP.request_entry_type AS Request_Entry_Type,
  HTTP.call_count AS Call_Count,
  HTTP.calling_time AS Calling_Time,
  HTTP.max_calling_time AS Max_Calling_Time,
  HTTP.data_sent AS Data_Sent,
  HTTP.data_received AS Data_Received,
  HTTP.data_sent + HTTP.data_received AS Data_Transferred,
  HTTP.idle_time AS Idle_Time,
  HTTP.data_send_time AS Data_Send_Time,
  HTTP.data_receive_time AS Data_Receive_Time,
  coalesce(_XDest.Service_Name, 'Unknown' ) AS Service_Name,
  coalesce( _XDest.Service_Type, 'Unknown' ) AS Service_Type,
  coalesce( _XDest.H2_Name, 'Unknown' ) AS H2_Name,
  _XDest.Created_At AS Created_At,
  _XDest.Created_By AS Created_By,
  _XDest.Changed_At AS Changed_At,
  _XDest.Changed_By AS Changed_By,
  coalesce( _XDest.H1_Name, 'Unknown' ) AS H1_Name,
  coalesce( _XDest.H1_Description, 'Unknown' ) AS H1_Description,
  coalesce( _XDest.H1_Type, 'SAP_TECHNICAL' ) AS H1_Type,
  _XTime.Time_Zone AS TIME_ZONE,
  _XTime.TimePeriod AS TIME_PERIOD,
  _XTime.TimeGranularity AS TIME_GRANULARITY,
  _XTime.TimestampUtc AS TIMESTAMP_UTC
FROM ksr_ta_http_cl AS HTTP
;