KSR_I_TA_TRACEHIST_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_TRACEHIST_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_ITATRCEHISTR

CREATE VIEW KSR_I_TA_TRACEHIST_R AS
SELECT
  TRACEHIST.client AS Client,
  TRACEHIST.tenant_id AS Tenant_Id,
  TRACEHIST.instance AS Instance,
  TRACEHIST.timestamp_id AS Timestamp_Id,
  TRACEHIST.user_group AS User_Group,
  TRACEHIST.tenant_group AS Tenant_Group,
  TRACEHIST.run_id AS Run_Id,
  TRACEHIST.api_type AS API_Type_raw,
  TRACEHIST.api_name AS API_Name,
  TRACEHIST.transaction_code AS Transaction_Code,
  TRACEHIST.request_entry_name AS Request_Entry_Name,
  TRACEHIST.request_entry_type_raw AS Request_Entry_Type_raw,
  _Dom_APT.ddtext AS API_Type,
  _Dom_RET.ddtext AS Request_Entry_Type,
  TRACEHIST.oda_package_id AS ODA_Package_ID,
  TRACEHIST.oda_assignment_id AS ODA_Assignment_ID,
  TRACEHIST.operation AS Operation,
  TRACEHIST.call_count AS Call_Count,
  TRACEHIST.call_time_sum AS Call_Time_Sum,
  TRACEHIST.call_time_max AS Call_Time_Max,
  TRACEHIST.call_size AS Call_Size,
  TRACEHIST.call_time_bucket_100 AS Call_Time_Bucket_100,
  TRACEHIST.call_time_bucket_250 AS Call_Time_Bucket_250,
  TRACEHIST.call_time_bucket_500 AS Call_Time_Bucket_500,
  TRACEHIST.call_time_bucket_1000 AS Call_Time_Bucket_1000,
  TRACEHIST.call_time_bucket_3000 AS Call_Time_Bucket_3000,
  TRACEHIST.call_time_bucket_5000 AS Call_Time_Bucket_5000,
  TRACEHIST.call_time_bucket_10000 AS Call_Time_Bucket_10000,
  TRACEHIST.call_time_bucket_20000 AS Call_Time_Bucket_20000,
  TRACEHIST.call_time_bucket_inf AS Call_time_Bucket_Inf,
  TRACEHIST.call_errors AS Call_Errors,
  _XTime.Time_Zone AS TIME_ZONE,
  _XTime.TimePeriod AS TIME_PERIOD,
  _XTime.TimeGranularity AS TIME_GRANULARITY,
  _XTime.TimestampUtc AS TIMESTAMP_UTC,
  _XTime.Calday AS Calday
FROM ksr_ta_tracehist AS TRACEHIST
LEFT OUTER JOIN TMO_I_XM_DD07V_R AS _Dom_APT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN TMO_I_XM_DD07V_R AS _Dom_RET ON /* join condition not captured in parsed metadata */
;