ODQMON_REQUESTS_H1

DDL: ODQMON_REQUESTS_H1 SQL: ODQMONREQH1 Type: view
29 Fields 6 Data Sources

Monitor: Requests

ODQMON_REQUESTS_H1 is a CDS View that provides data about "Monitor: Requests" in SAP S/4HANA. It reads from 6 data sources and exposes 29 fields with key fields modelname, queuename, queuename, queuename.

Data Sources (6)

SourceAliasJoin Type
odqreqque q left_outer
odqreqque_v r from
odqreqque_v r union
odqreq r union
odqssnque s inner
odqssnque_v s inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ODQMONREQH1 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Monitor: Requests view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY modelname odqreq modelname Provider
KEY queuename odqreq queuename Queue Name
realtime realtime Real-Time Mode
rid rid Request
status_icon status_icon Status of PH
taskid taskid Task ID
jobname jobname Name of Send Process
jobcount jobcount Job number
tsn_low tsn_low Lower Limit for TSN
tsn_high tsn_high Upper Limit for TSN
KEY queuename queuename Queue Name
realtime realtime Real-Time Mode
rid rid Request
status_icon status_icon Status of PH
taskid taskid Task ID
jobname jobname Name of Send Process
jobcount jobcount Job number
tsn_low tsn_low Lower Limit for TSN
tsn_high tsn_high Upper Limit for TSN
modelname Provider
KEY queuename odqssnque_v queuename Queue Name
realtime odqreq realtime Real-Time Mode
rid odqreqque rid Request
status_icon odqreqque status_icon Status of PH
taskid odqreqque taskid Task ID
jobname odqreqque jobname Name of Send Process
jobcount odqreqque jobcount Job number
tsn_low odqreq tsn_low Lower Limit for TSN
tsn_high odqreq tsn_high Upper Limit for TSN

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_H1.
-- 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: ODQMONREQH1

CREATE VIEW ODQMON_REQUESTS_H1 AS
SELECT
  r.modelname AS modelname,
  r.queuename AS queuename,
  realtime,
  rid,
  status_icon,
  taskid,
  jobname,
  jobcount,
  tsn_low,
  tsn_high
FROM odqreqque_v AS r
INNER JOIN odqssnque AS s ON /* join condition not captured in parsed metadata */
INNER JOIN odqssnque_v AS s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN odqreqque AS q ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): odqreqque_v, odqreq
;

Learn More