KSR_I_TS_TRACESPAN_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_TRACESPAN_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_ITSTRCSPANR

CREATE VIEW KSR_I_TS_TRACESPAN_R AS
SELECT
  ksr_ts_tracespan.client AS Client,
  ksr_ts_tracespan.instance AS Instance,
  ksr_ts_tracespan.record_number AS Record_Number,
  ksr_ts_tracespan.start_time AS Start_Time,
  ksr_ts_tracespan.subrecord_number AS Subrecord_Number,
  ksr_ts_main.end_time AS End_Time,
  ksr_ts_tracespan.span_provider_id AS Span_Provider_Id,
  cast(ksr_ts_tracespan.span_name as abap.char(60) ) AS Span_Name,
  ksr_ts_tracespan.parent_span_id AS Parent_Span_Id,
  ksr_ts_tracespan.span_id AS Span_Id,
  _Dom_TSK.ddtext AS Span_Kind,
  ksr_ts_tracespan.span_start_time AS Span_Start_Time,
  ksr_ts_tracespan.span_end_time AS Span_End_Time,
  ksr_ts_tracespan.span_duration AS Span_Duration,
  ksr_ts_tracespan.num_entries AS Num_Entries,
  _Dom_TSS.ddtext AS Status_Code,
  ksr_ts_tracespan.attributes_hash_value AS Attributes_Hash_Value,
  ksr_ts_tracespan.retention_timestamp AS Retention_Timestamp,
  ksr_ts_tracespan.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 AS clientasClient,
  ksr_ts_main.user_group AS User_Group
FROM ksr_ts_tracespan
LEFT OUTER JOIN TMO_I_XM_DD07V_CONV_R AS _Dom_TSS ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN TMO_I_XM_DD07V_CONV_R AS _Dom_TSK ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): ksr_ts_main
;