I_OQ_QUEUEITEM

DDL: I_OQ_QUEUEITEM Type: view_entity
18 Fields 1 Data Sources 1 Associations

Output Queue Item

I_OQ_QUEUEITEM is a CDS View that provides data about "Output Queue Item" in SAP S/4HANA. It reads from 1 data source (oqqueueitem) and exposes 18 fields with key field ItemId. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
oqqueueitem QueueItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] dd07t _StatusText _StatusText.domname = 'OQ_ITEM_STATUS' and _StatusText.domvalue_l = $projection.ItemStatus and _StatusText.ddlanguage = $session.system_language and _StatusText.as4local = 'A'

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Output Queue Item view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ItemId oqqueueitem item_id Simulation Item ID
Qname oqqueueitem qname User
Username oqqueueitem username User who owns item
ItemStatus oqqueueitem item_status Transfer Status
int4endasStatusCriticality
StatusDescription oqqueueitem status_description Status Description
CreateTime oqqueueitem create_time Time
ChangedTime oqqueueitem changed_time Time Stamp
Bundle oqqueueitem bundle Bundle
Metadata oqqueueitem metadata Item Metadata
DocumentName oqqueueitem document_name Document Name
Filesize oqqueueitem filesize Safety Data Sheet File Size
Zipstatus oqqueueitem zipstatus Blob Zip Status
Data oqqueueitem data Read Data
SentCounter oqqueueitem sent_counter Resending Counter
_User _User
_StatusText _StatusText
_Queue _Queue

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 I_OQ_QUEUEITEM.
-- 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.

CREATE VIEW I_OQ_QUEUEITEM AS
SELECT
  QueueItem.item_id AS ItemId,
  QueueItem.qname AS Qname,
  QueueItem.username AS Username,
  QueueItem.item_status AS ItemStatus,
  case when QueueItem.item_status = 'N' then cast( 0 as abap.int4 ) when QueueItem.item_status = 'F' then cast( 1 as abap.int4 ) when QueueItem.item_status = 'S' then cast( 3 as abap.int4 ) when QueueItem.item_status = 'W' or QueueItem.item_status = 'E' then cast( 2 as abap.int4 ) else cast( 0 as abap.int4 ) end as StatusCriticality AS int4endasStatusCriticality,
  QueueItem.status_description AS StatusDescription,
  QueueItem.create_time AS CreateTime,
  QueueItem.changed_time AS ChangedTime,
  QueueItem.bundle AS Bundle,
  QueueItem.metadata AS Metadata,
  QueueItem.document_name AS DocumentName,
  QueueItem.filesize AS Filesize,
  QueueItem.zipstatus AS Zipstatus,
  QueueItem.data AS Data,
  QueueItem.sent_counter AS SentCounter
FROM oqqueueitem AS QueueItem
LEFT OUTER JOIN dd07t AS _StatusText ON _StatusText.domname = 'OQ_ITEM_STATUS' AND _StatusText.domvalue_l = ItemStatus AND _StatusText.ddlanguage = $session.system_language AND _StatusText.as4local = 'A'  -- association [0..1]
;

Learn More