ksr_i_ts_dbcon_detail_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_dbcon_detail_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_ITSDBCONDETR

CREATE VIEW ksr_i_ts_dbcon_detail_r AS
SELECT
  client,
  Instance,
  Record_Number,
  Start_Time,
  Subrecord_Number,
  Connection_Name,
  Dir_Read_Request_Time + Seq_Read_Request_Time + Insert_Request_Time + Delete_Request_Time + Update_Request_Time + Other_Time AS request_time,
  Dir_Read_Row_Count + Seq_Read_Row_Count + Insert_Row_Count + Delete_Row_Count + Update_Row_Count AS db_row_count,
  User_Group,
  Tenant_Group,
  case when Dir_Read_Row_Count = 0 then 0 else Dir_Read_Request_Time / Dir_Read_Row_Count end AS request_Time_per_db_row
FROM KSR_I_TS_DBCON_R
-- UNION with additional select branch(es): KSR_I_TS_DBCON_R
;