ksr_i_ts_stmtresolved_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_stmtresolved_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_ITSSTMTRESR

CREATE VIEW ksr_i_ts_stmtresolved_r AS
SELECT
  KSR_I_TS_STMTHASH_R.client AS Client,
  KSR_I_TS_STMTHASH_R.Instance AS Instance,
  KSR_I_TS_STMTHASH_R.Record_Number AS Record_Number,
  KSR_I_TS_STMTHASH_R.Start_Time AS Start_Time,
  KSR_I_TS_STMTHASH_R.Subrecord_Number AS Subrecord_Number,
  KSR_I_TS_STMTHASH_R.Connection_Name AS Connection_Name,
  KSR_I_XM_SQL_STATEMENT_R.statement_string AS Statement_String,
  KSR_I_TS_STMTHASH_R.Statement_Hash AS Statement_Hash,
  KSR_I_TS_STMTHASH_R.Statement_Type AS Statement_Type,
  KSR_I_TS_STMTHASH_R.Execution_Count AS Execution_Count,
  KSR_I_TS_STMTHASH_R.Record_Count AS Record_Count,
  KSR_I_TS_STMTHASH_R.Processing_Time AS Processing_Time,
  KSR_I_TS_STMTHASH_R.Hana_Cpu_Time AS Hana_Cpu_Time,
  KSR_I_TS_STMTHASH_R.Hana_Max_Memory AS Hana_Max_Memory,
  KSR_I_TS_STMTHASH_R.Hana_Processing_Time AS Hana_Processing_Time,
  KSR_I_TS_STMTHASH_R.Hana_Execution_Time AS Hana_Execution_Time,
  KSR_I_TS_STMTHASH_R.Hana_Preparation_Time AS Hana_Preparation_Time,
  KSR_I_TS_STMTHASH_R.Retention_Timestamp AS Retention_Timestamp,
  KSR_I_TS_STMTHASH_R.Tenant_Group AS Tenant_Group,
  KSR_I_TS_STMTHASH_R.User_Group AS User_Group
FROM KSR_I_TS_STMTHASH_R
LEFT OUTER JOIN KSR_I_XM_SQL_STATEMENT_R ON /* join condition not captured in parsed metadata */
;