ODQMON_UNITS

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_UNITS.
-- 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: ODQMONUNI

CREATE VIEW ODQMON_UNITS AS
SELECT
  modelname,
  queuename,
  tsn,
  unitno,
  _data.lines AS lines,
  _data.rawsize AS rawsize,
  _data.compsize AS compsize,
  _data.dataformat AS dataformat,
  _data.tabname AS tabname,
  _data.tid AS tid
FROM ODQMON_UNITS_H3
LEFT OUTER JOIN ODQMON_UNITS_F1 AS _data ON _data.modelname = modelname AND _data.queuename = queuename AND _data.tsn = tsn AND _data.unitno = unitno  -- 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_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_EXTRACTION_MODE AS _xmode ON _xmode.extraction_mode = extraction_mode  -- association [0..1]
;