SAP APQD DATA DEFINITION Queue Table data and field list

APQD is a standard SAP Table which is used to store DATA DEFINITION Queue data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The APQD table consists of various fields, each holding specific information or linking keys about DATA DEFINITION Queue data available in SAP. These include TRANS (Transaction counter: Batch input, statistics), BLOCK (Message counter: Batch input, statistics), SEGMT (Queue data segmentation number), MSGCOUNT (Queue data block number)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

APQD table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP APQD table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the APQD table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
QIDQueue identification (unique key) APQ_QUIDCHAR20CHAR20
TRANSTransaction counter: Batch input, statistics APQ_TRANINT410CDINT4
BLOCKMessage counter: Batch input, statistics APQ_RECOINT410CDINT4
SEGMTQueue data segmentation number APQ_SEGMINT25CDINT2
MSGCOUNTQueue data block number APQ_BLCKINT25CDINT2
VARLENQueue data length of user data APQ_LDATINT25CDINT2
VARDATALong String Used to Store BDC Objects in the Database BDC_LCHARLCHR7902BDC_LCHAR

Key field Non-key field



How do I retrieve data from SAP table APQD using ABAP code

The following ABAP code Example will allow you to do a basic selection on APQD to SELECT all data from the table
DATA: WA_APQD TYPE APQD.

SELECT SINGLE *
FROM APQD
INTO CORRESPONDING FIELDS OF WA_APQD
WHERE...

How to access SAP table APQD

Within an ECC or HANA version of SAP you can also view further information about APQD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).