PQPRINTQUEUE

Transparent Table Application Table
16 Fields 4 CDS Views

Print queue

PQPRINTQUEUE is an SAP database table in S/4HANA. Print queue. It contains 16 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_APSOMPQNAME view from BASIC Print Queue Names
I_FinSEPAMandatePrintQueueVH view_entity from BASIC SEPA Mandate Print Queue
PQPRINT_QUEUE view from Print Queue
Pqprint_Queue_Tsp03 view from Print queue with bound printer

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY qname PQ_QNAME Unique ID of a Queue
qdescription PQ_QDESCRIPTION Queue Description
qformat PQ_QFORMAT Technical Format ID
qformat_descript PQ_QFORMAT_DESCRIPTION Queue Format
tech_user_name PQ_TECH_USER_NAME Technical User
qstatus PQ_QSTATUS Queue Status
create_time PQ_CREATE_TIME Create time
last_retrieve_time PQ_LAST_RETRIEVE_TIME Time of last retr.
cleanup_prd PQ_CLEANUP_PERIOD Cleanup Queue Items
location_id PQ_LOCATION_ID Location ID
location_id_type PQ_LOCATION_ID_TYPE Location ID Type
oms_type PQ_OMS_TYPE OMS Type
qparams PQ_PRINTPARAMS Print Parameter
destination PQ_DESTINATION Destination
notify_type PQ_NOTIFY_TYPE Notification Type

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Print queue
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PQPRINTQUEUE (
    MANDT,               -- Client [MANDT]
    QNAME,               -- Unique ID of a Queue [PQ_QNAME]
    QDESCRIPTION,        -- Queue Description [PQ_QDESCRIPTION]
    QFORMAT,             -- Technical Format ID [PQ_QFORMAT]
    QFORMAT_DESCRIPT,    -- Queue Format [PQ_QFORMAT_DESCRIPTION]
    TECH_USER_NAME,      -- Technical User [PQ_TECH_USER_NAME]
    QSTATUS,             -- Queue Status [PQ_QSTATUS]
    CREATE_TIME,         -- Create time [PQ_CREATE_TIME]
    LAST_RETRIEVE_TIME,  -- Time of last retr. [PQ_LAST_RETRIEVE_TIME]
    CLEANUP_PRD,         -- Cleanup Queue Items [PQ_CLEANUP_PERIOD]
    LOCATION_ID,         -- Location ID [PQ_LOCATION_ID]
    LOCATION_ID_TYPE,    -- Location ID Type [PQ_LOCATION_ID_TYPE]
    OMS_TYPE,            -- OMS Type [PQ_OMS_TYPE]
    QPARAMS,             -- Print Parameter [PQ_PRINTPARAMS]
    DESTINATION,         -- Destination [PQ_DESTINATION]
    NOTIFY_TYPE,         -- Notification Type [PQ_NOTIFY_TYPE]
    PRIMARY KEY (MANDT, QNAME)
);

Learn More