RV_C_ODQQUEUES

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 RV_C_ODQQUEUES.
-- 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: RVCODQQUEUE

CREATE VIEW RV_C_ODQQUEUES AS
SELECT
  queue_data.provider AS provider,
  queue_data.queue AS queue,
  queue_data.queueState AS queueState,
  cast(tstmp_to_dats(queue_data.tsnMax, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as sydatum preserving type ) AS tsnMax,
  cast(tstmp_to_dats(queue_data.tsnMin, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as sydatum preserving type ) AS tsnMin,
  queue_data.countSubscriptions AS countSubscriptions,
  queue_data.countRequests AS countRequests,
  queue_data.countUnits AS countUnits,
  queue_data.countRows AS countRows,
  queue_data.originalSize AS originalSize,
  queue_data.compressedSize AS compressedSize,
  queue_data.compressionRate AS compressionRate
FROM RV_I_ODQQueues AS queue_data
LEFT OUTER JOIN RV_I_ODQREADREQ AS _requestSelection ON _requestSelection.read_full_requests = requestSelection  -- association [0..1]
;