The APQI table in SAP ERP or S/4HANA stores Queue info definition data. There are total 40 fields in APQI table. The Queue info definition table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of APQI table. It is in SAP Batch Input (SBDC) ABAP package and is part of the UI Services, Screen, Batch Input (BC-ABA-SC) module.
SAP APQI Table Fields
Following is the list of fields that are available in SAP APQI table. The primary key fields of the table are DESTSYS (Queue target system), DESTAPP (Queue target application), DATATYP (Queue data type), MANDANT (Queue client), GROUPID (Group name: Batch input session name), PROGID (Queue program), FORMID (Queue module/unique), QATTRIB (Queue attribute (unique or append)), QID (Queue Identification (Unique Key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| DESTSYS | Queue target system | APQ_DEST | CHAR (32) | |
| DESTAPP | Queue target application | APQ_APPL | CHAR (8) | |
| DATATYP | Queue data type | APQ_DTYP | CHAR (4) | |
| MANDANT | Queue client | APQ_MANDT | * | CLNT (3) |
| GROUPID | Group name: Batch input session name | APQ_GRPN | CHAR (12) | |
| PROGID | Queue program | APQ_PROG | CHAR (40) | |
| FORMID | Queue module/unique | APQ_MODP | CHAR (30) | |
| QATTRIB | Queue attribute (unique or append) | APQ_QATT | CHAR (1) | |
| QID | Queue Identification (Unique Key) | APQ_QUID | CHAR (20) | |
| QSTATE | Queue status | APQ_STAT | CHAR (1) | |
| QERASE | Queue deletion indicator for processed sessions | APQ_QDEL | CHAR (1) | |
| USERID | Queue user ID / for historical reasons | APQ_MAPN | CHAR (12) | |
| PASSWD | Queue password | APQ_PASS | CHAR (40) | |
| CREATOR | Queue user ID / for historical reasons | APQ_MAPN | CHAR (12) | |
| CREDATE | Queue creation date | APQ_CRDA | DATS (8) | |
| CRETIME | Queue creation time | APQ_CRTI | TIMS (6) | |
| STARTPGID | Queue driver program | APQ_TREI | CHAR (40) | |
| STARTMODE | Queue start mode | APQ_STRT | CHAR (1) | |
| STARTDATE | Queue start date | APQ_STDA | DATS (8) | |
| STARTTIME | Queue start time | APQ_STTI | TIMS (6) | |
| PUTACTIVE | Queue PUTQ active flag | APQ_OUAC | CHAR (1) | |
| PUTPID | Queue PUTQ Process ID | APQ_OUID | INT4 (10) | |
| PUTTRANS | Queue PUTQ transaction counter | APQ_OUTR | INT4 (10) | |
| PUTBLOCK | Queue PUTQ sum of logical blocks | APQ_OUBL | INT4 (10) | |
| PUTDATE | Queue PUTQ date of last PUTQ or error | APQ_OUDA | DATS (8) | |
| PUTTIME | Queue PUTQ time last PUTQ or error | APQ_OUTI | TIMS (6) | |
| GETACTIVE | Queue GETQ active flag | APQ_INAC | CHAR (1) | |
| GETPID | Queue PUTQ Process ID | APQ_INID | INT4 (10) | |
| GETTRANS | Queue GETQ transaction counter | APQ_INTR | INT4 (10) | |
| GETBLOCK | Queue GETQ sum of logical blocks | APQ_INBL | INT4 (10) | |
| GETDATE | Queue GETQ date last GETQ or error | APQ_INDA | DATS (8) | |
| GETTIME | Queue GETQ time last GETQ or error | APQ_INTI | TIMS (6) | |
| TRANSCNT | Transaction counter: Batch input, statistics | APQ_TRAN | INT4 (10) | |
| MSGCNT | Message counter: Batch input, statistics | APQ_RECO | INT4 (10) | |
| TRANSCNTE | Transaction counter: Batch input, statistics | APQ_TRAN | INT4 (10) | |
| MSGCNTE | Message counter: Batch input, statistics | APQ_RECO | INT4 (10) | |
| TRANSCNTD | Transaction counter: Batch input, statistics | APQ_TRAN | INT4 (10) | |
| MSGCNTD | Message counter: Batch input, statistics | APQ_RECO | INT4 (10) | |
| TRANSCNTF | Transaction counter: Batch input, statistics | APQ_TRAN | INT4 (10) | |
| MSGCNTF | Message counter: Batch input, statistics | APQ_RECO | INT4 (10) |
