ODQMON_SUBSCRIPTIONS

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_SUBSCRIPTIONS.
-- 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: ODQMONSSN

CREATE VIEW ODQMON_SUBSCRIPTIONS AS
SELECT
  modelname,
  queuename,
  _reqs.requests AS requests,
  _data.units AS units,
  _data.lines AS lines,
  _data.rawsize AS rawsize,
  _data.compsize AS compsize,
  queuestate,
  cre_user,
  cre_tstmp,
  mod_user,
  mod_tstmp,
  realtime
FROM ODQMON_SUBSCRIPTIONS_H3
LEFT OUTER JOIN ODQMON_SUBSCRIPTIONS_F1 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.read_data_volume = read_data_volume AND _data.read_full_requests = read_full_requests  -- association [0..1]
LEFT OUTER JOIN ODQMON_SUBSCRIPTIONS_F2 AS _reqs ON _reqs.modelname = modelname AND _reqs.queuename = queuename AND _reqs.subscriber_type = subscriber_type AND _reqs.subscriber_id = subscriber_id AND _reqs.subscription_id = subscription_id AND _reqs.read_data_volume = read_data_volume AND _reqs.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_QUEUESTATE AS _quest ON _quest.queuestate = queuestate  -- association [0..1]
;