KSR_I_TS_COMPTRACE_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_COMPTRACE_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_ITSCMPTRACER

CREATE VIEW KSR_I_TS_COMPTRACE_R AS
SELECT
  ksr_ts_comptrc78.client AS Client,
  ksr_ts_comptrc78.instance AS Instance,
  ksr_ts_comptrc78.record_number AS Record_Number,
  ksr_ts_comptrc78.start_time AS Start_Time,
  ksr_ts_comptrc78.subrecord_number AS Subrecord_Number,
  ksr_ts_main.end_time AS End_Time,
  ksr_ts_comptrc78.parent_span_id AS Parent_Span_Id,
  ksr_ts_comptrc78.span_id AS Span_Id,
  ksr_ts_comptrc78.span_name AS Span_Name,
  ksr_ts_comptrc78.span_kind AS Span_Kind,
  ksr_ts_comptrc78.span_start_time AS Span_Start_Time,
  ksr_ts_comptrc78.span_end_time AS Span_End_Time,
  ksr_ts_comptrc78.span_duration AS Span_Duration,
  ksr_ts_comptrc78.span_links AS Span_Links,
  ksr_ts_comptrc78.number_of_records AS Number_Of_Records,
  ksr_ts_comptrc78.status_code AS Status_Code,
  ksr_ts_comptrc78.retention_timestamp AS Retention_Timestamp,
  ksr_ts_comptrc78.span_start_time AS Timestamp_UTC,
  0 AS Time_Period,
  1 AS Time_Granularity,
  0 AS Time_Zone,
  ksr_ts_main.tenant_group AS Tenant_Group,
  ksr_ts_main.user_group AS User_Group
FROM ksr_ts_comptrc78
;