KSR_I_TA_SQL_STMT_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_SQL_STMT_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_ITASQLSTMTR

CREATE VIEW KSR_I_TA_SQL_STMT_R AS
SELECT
  ksr_ta_sql_stmt.client AS Client,
  ksr_ta_sql_stmt.tenant_id AS Tenant_Id,
  ksr_ta_sql_stmt.instance AS Instance,
  ksr_ta_sql_stmt.timestamp_id AS Timestamp_Id,
  ksr_ta_sql_stmt.user_group AS User_Group,
  ksr_ta_sql_stmt.statement_hash AS Statement_Hash,
  ksr_ta_sql_stmt.tenant_group AS Tenant_Group,
  ksr_ta_sql_stmt.execution_count AS Execution_Count,
  ksr_ta_sql_stmt.record_count AS Record_Count,
  ksr_ta_sql_stmt.processing_time AS Processing_Time,
  ksr_ta_sql_stmt.hana_cpu_time AS Hana_Cpu_Time,
  ksr_ta_sql_stmt.hana_max_mem AS Hana_Max_Mem,
  ksr_ta_sql_stmt.hana_processing_time AS Hana_Processing_Time,
  _XTime.Time_Zone AS TIME_ZONE,
  _XTime.TimePeriod AS TIME_PERIOD,
  _XTime.TimeGranularity AS TIME_GRANULARITY,
  _XTime.TimestampUtc AS TIMESTAMP_UTC
FROM ksr_ta_sql_stmt
LEFT OUTER JOIN KSR_I_XM_TIME_R AS _XTime ON Timestamp_Id = _XTime.TimestampId  -- association [1..1]
;