KSR_I_TA_SERVICES_OUT_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_SERVICES_OUT_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_ITASRVOUTR

CREATE VIEW KSR_I_TA_SERVICES_OUT_R AS
SELECT
  client,
  Tenant_Id,
  Instance,
  Timestamp_Id,
  User_Group,
  Tenant_Group,
  Run_Id,
  Destination_Name,
  Request_Entry_Name,
  Request_Entry_Type_Raw,
  Request_Entry_Type,
  sum(Call_Count) AS Call_Count,
  sum(Calling_Time) AS Calling_Time,
  max(Max_Calling_Time) AS Max_Calling_Time,
  sum(Data_Transferred) AS Data_Transferred,
  Service_Name,
  Service_Type,
  H2_Name,
  Created_At,
  Created_By,
  Changed_At,
  Changed_By,
  H1_Name,
  H1_Description,
  H1_Type,
  TIME_ZONE,
  TIME_PERIOD,
  TIME_GRANULARITY,
  TIMESTAMP_UTC
FROM KSR_I_TA_HTTP_CL_R
-- UNION with additional select branch(es): KSR_I_TA_RFC_CL_R, KSR_I_TA_WS_CO_R
;