ODQMON_UNITS_F1

DDL: ODQMON_UNITS_F1 SQL: ODQMONUNIF1 Type: view
25 Fields 7 Data Sources

Monitor: Dateneinheiten

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

Data Sources (7)

SourceAliasJoin Type
odqdata_c c from
odqdata d union
odqdata_f f union
odqtsnlog l inner
odqreqque_v q inner
odqreqque_v q inner
odqssnque s inner

Annotations (4)

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

Fields (25)

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
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
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
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_F1.
-- 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: ODQMONUNIF1

CREATE VIEW ODQMON_UNITS_F1 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,
  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 AS s ON /* join condition not captured in parsed metadata */
INNER JOIN odqtsnlog AS l ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): odqdata_f, odqdata
;

Learn More