C_OQ_QUEUE

DDL: C_OQ_QUEUE Type: view_entity Package: SOUT_IMPL

Consumption Output Queue

C_OQ_QUEUE is a CDS View that provides data about "Consumption Output Queue" in SAP S/4HANA. It reads from 1 data source (I_OQ_QUEUE) and exposes 21 fields with key field Qname. It is exposed through 1 OData service (OUTPUT_QUEUE_SD). Part of development package SOUT_IMPL.

Data Sources (1)

SourceAliasJoin Type
I_OQ_QUEUE I_OQ_QUEUE projection

Annotations (10)

NameValueLevelField
EndUserText.label Consumption Output Queue view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
UI.headerInfo.typeName Queue view
UI.headerInfo.typeNamePlural Queues view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value Qname view
UI.headerInfo.title.label Queue view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value Qdescription view

OData Services (1)

ServiceBindingVersionContractRelease
OUTPUT_QUEUE_SD UI_OUTPUT_QUEUE_O4 V4 C1 NOT_RELEASED

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Qname Qname Queue
Qdescription Qdescription Description
Qformat Qformat Format
QformatDescript QformatDescript Format Description
CommUserName CommUserName Queue Owner
Qstatus Qstatus Status
QstatusDescription _StatusDesc ddtext Status Description
StatusCriticality StatusCriticality
CreateTime CreateTime Time
CreatedBy CreatedBy User Name
CreatedByDescription _CreatedBy UserDescription Created By Name
LocalLastChangedAt LocalLastChangedAt Time Stamp
LocalLastChangedBy LocalLastChangedBy Changed By
LocalLastChangedByDescription _LastChangedBy UserDescription Changed By Name
CleanupPrd CleanupPrd Retention Period (Days)
IntegrationType IntegrationType Integration Type
Destination _Context destination RFC Destination
NotifyType NotifyType Transfer Type
NotifyTypeDescription _NotifyType ddtext Short text
ItemsCount ItemsCount Items
_QueueItemredirectedtoC_OQ_QUEUEITEM

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 C_OQ_QUEUE.
-- 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 C_OQ_QUEUE AS
SELECT
  Qname,
  Qdescription,
  Qformat,
  QformatDescript,
  CommUserName,
  Qstatus,
  _StatusDesc.ddtext AS QstatusDescription,
  StatusCriticality,
  CreateTime,
  CreatedBy,
  _CreatedBy.UserDescription AS CreatedByDescription,
  LocalLastChangedAt,
  LocalLastChangedBy,
  _LastChangedBy.UserDescription AS LocalLastChangedByDescription,
  CleanupPrd,
  IntegrationType,
  _Context.destination AS Destination,
  NotifyType,
  _NotifyType.ddtext AS NotifyTypeDescription,
  ItemsCount
FROM I_OQ_QUEUE
;