ODQMON_UNITS_F2

DDL: ODQMON_UNITS_F2 SQL: ODQMONUNIF2 Type: view
35 Fields 9 Data Sources

Monitor: Dateneinheiten

ODQMON_UNITS_F2 is a CDS View that provides data about "Monitor: Dateneinheiten" in SAP S/4HANA. It reads from 9 data sources and exposes 35 fields with key fields modelname, queuename, tsn, unitno, queuename.

Data Sources (9)

SourceAliasJoin Type
odqdata_c c from
odqdata d union
odqdata_f f union
odqtsnlog l inner
odqreqque_v q inner
odqreqque_v q inner
odqreq r left_outer
odqssnque_v s inner
odqssnque_v s inner

Annotations (4)

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

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY modelname odqdata_c modelname Provider
KEY queuename odqdata_c queuename Queue Name
KEY tsn odqdata_c rid TSN
KEY unitno odqdata_c unitno Unit Number
lines odqdata_c lines Number of Lines
rawsize odqdata_c rawsize Original Size
compsize odqdata_c compsize Comp. Size in Bytes
dataformat odqdata_c dataformat Data Format
realtime_que
realtime_ssn odqssnque_v realtime Real-Time Mode
realtime_req Real-Time Mode
new_delta
modelname Provider
KEY queuename odqdata_f queuename Queue Name
KEY tsn odqdata_f rid TSN
KEY unitno odqdata_f unitno Unit Number
lines odqdata_f lines Number of Lines
rawsize odqdata_f rawsize Original Size
compsize odqdata_f compsize Comp. Size in Bytes
dataformat odqdata_f dataformat Data Format
realtime_que
realtime_ssn Real-Time Mode
realtime_req Real-Time Mode
new_delta
modelname Provider
KEY queuename odqdata queuename Queue Name
KEY tsn odqtsnlog tsn TSN
KEY unitno odqdata unitno Unit Number
lines odqdata lines Number of Lines
rawsize odqdata rawsize Original Size
compsize odqdata compsize Comp. Size in Bytes
dataformat odqdata dataformat Data Format
realtime_ssn odqssnque_v realtime Real-Time Mode
realtime_req odqreq realtime Real-Time Mode
tid odqdata tid Transaction ID for updating external tax system

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_F2.
-- 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: ODQMONUNIF2

CREATE VIEW ODQMON_UNITS_F2 AS
SELECT
  c.modelname AS modelname,
  c.queuename AS queuename,
  c.rid AS tsn,
  c.unitno AS unitno,
  c.lines AS lines,
  c.rawsize AS rawsize,
  c.compsize AS compsize,
  c.dataformat AS dataformat,
  cast( ' ' as odq_realtime preserving type ) AS realtime_que,
  s.realtime AS realtime_ssn,
  cast( ' ' as odq_realtime preserving type ) AS realtime_req,
  cast( 0 as odq_unit_state ) AS new_delta,
  d.tid AS tid
FROM odqdata_c AS c
INNER JOIN odqreqque_v AS q ON /* join condition not captured in parsed metadata */
INNER JOIN odqssnque_v AS s ON /* join condition not captured in parsed metadata */
INNER JOIN odqtsnlog AS l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN odqreq AS r ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): odqdata_f, odqdata
;

Learn More