ODQMON_REQUESTS

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 ODQMON_REQUESTS.
-- 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: ODQMONREQ

CREATE VIEW ODQMON_REQUESTS AS
SELECT
  modelname,
  queuename,
  _data.units AS units,
  _data.lines AS lines,
  _data.rawsize AS rawsize,
  _data.compsize AS compsize,
  realtime,
  rid,
  status_icon,
  taskid,
  jobname,
  jobcount,
  tsn_low,
  tsn_high,
  tabname
FROM ODQMON_REQUESTS_H3
LEFT OUTER JOIN ODQMON_REQUESTS_F3 AS _data ON _data.modelname = modelname AND _data.queuename = queuename AND _data.subscriber_type = subscriber_type AND _data.subscriber_id = subscriber_id AND _data.subscription_id = subscription_id AND _data.composite_rid = composite_rid AND _data.read_data_volume = read_data_volume AND _data.read_full_requests = read_full_requests  -- association [0..1]
LEFT OUTER JOIN ODQMON_MODELNAME AS _model ON _model.modelname = modelname  -- association [0..1]
LEFT OUTER JOIN ODQMON_QUEUENAME AS _queue ON _queue.modelname = modelname AND _queue.queuename = queuename  -- association [0..1]
LEFT OUTER JOIN ODQMON_SUBSCRIBER_TYPE AS _stype ON _stype.subscriber_type = subscriber_type  -- association [0..1]
LEFT OUTER JOIN ODQMON_READ_DATA_VOLUME AS _seldt ON _seldt.read_data_volume = read_data_volume  -- association [0..1]
LEFT OUTER JOIN ODQMON_READ_FULL_REQUESTS AS _selrq ON _selrq.read_full_requests = read_full_requests  -- association [0..1]
LEFT OUTER JOIN ODQMON_STATUS_ICON AS _cmpst ON _cmpst.status_icon = comp_status_icon  -- association [0..1]
LEFT OUTER JOIN ODQMON_EXTRACTION_MODE AS _xmode ON _xmode.extraction_mode = extraction_mode  -- association [0..1]
LEFT OUTER JOIN ODQMON_STATUS_ICON AS _xtrst ON _xtrst.status_icon = status_icon  -- association [0..1]
;