SAP Table APQI
Queue info definition
APQI (Queue info definition) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link APQI to other SAP tables.
APQI table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| DESTSYS | Queue target system | APQ_DEST | CHAR | 32 | 0 | |||
| DESTAPP | Queue target application | APQ_APPL | CHAR | 8 | 0 | |||
| DATATYP | Queue data type | APQ_DTYP | CHAR | 4 | 0 | |||
| MANDANT | Queue client | APQ_MANDT | CLNT | 3 | 0 | |||
| GROUPID | Group name: Batch input session name | APQ_GRPN | CHAR | 12 | 0 | |||
| PROGID | Queue program | APQ_PROG | CHAR | 40 | 0 | |||
| FORMID | Queue module/unique | APQ_MODP | CHAR | 30 | 0 | |||
| QATTRIB | Queue attribute (unique or append) | APQ_QATT | CHAR | 1 | 0 | |||
| QID | Queue identification (unique key) | APQ_QUID | CHAR | 20 | 0 | |||
| QSTATE | Queue status | APQ_STAT | CHAR | 1 | 0 | |||
| QERASE | Queue deletion indicator for processed sessions | APQ_QDEL | CHAR | 1 | 0 | |||
| USERID | Queue user ID / for historical reasons | APQ_MAPN | CHAR | 12 | 0 | |||
| PASSWD | Queue password | APQ_PASS | CHAR | 40 | 0 | |||
| CREATOR | Queue user ID / for historical reasons | APQ_MAPN | CHAR | 12 | 0 | |||
| CREDATE | Queue creation date | APQ_CRDA | DATS | 8 | 0 | |||
| CRETIME | Queue creation time | APQ_CRTI | TIMS | 6 | 0 | |||
| STARTPGID | Queue driver program | APQ_TREI | CHAR | 40 | 0 | |||
| STARTMODE | Queue start mode | APQ_STRT | CHAR | 1 | 0 | |||
| STARTDATE | Queue start date | APQ_STDA | DATS | 8 | 0 | |||
| STARTTIME | Queue start time | APQ_STTI | TIMS | 6 | 0 | |||
| PUTACTIVE | Queue PUTQ active flag | APQ_OUAC | CHAR | 1 | 0 | |||
| PUTPID | Queue PUTQ Process ID | APQ_OUID | INT4 | 10 | 0 | |||
| PUTTRANS | Queue PUTQ transaction counter | APQ_OUTR | INT4 | 10 | 0 | |||
| PUTBLOCK | Queue PUTQ sum of logical blocks | APQ_OUBL | INT4 | 10 | 0 | |||
| PUTDATE | Queue PUTQ date of last PUTQ or error | APQ_OUDA | DATS | 8 | 0 | |||
| PUTTIME | Queue PUTQ time last PUTQ or error | APQ_OUTI | TIMS | 6 | 0 | |||
| GETACTIVE | Queue GETQ active flag | APQ_INAC | CHAR | 1 | 0 | |||
| GETPID | Queue PUTQ Process ID | APQ_INID | INT4 | 10 | 0 | |||
| GETTRANS | Queue GETQ transaction counter | APQ_INTR | INT4 | 10 | 0 | |||
| GETBLOCK | Queue GETQ sum of logical blocks | APQ_INBL | INT4 | 10 | 0 | |||
| GETDATE | Queue GETQ date last GETQ or error | APQ_INDA | DATS | 8 | 0 | |||
| GETTIME | Queue GETQ time last GETQ or error | APQ_INTI | TIMS | 6 | 0 | |||
| TRANSCNT | Transaction counter: Batch input, statistics | APQ_TRAN | INT4 | 10 | 0 | |||
| MSGCNT | Message counter: Batch input, statistics | APQ_RECO | INT4 | 10 | 0 | |||
| TRANSCNTE | Transaction counter: Batch input, statistics | APQ_TRAN | INT4 | 10 | 0 | |||
| MSGCNTE | Message counter: Batch input, statistics | APQ_RECO | INT4 | 10 | 0 | |||
| TRANSCNTD | Transaction counter: Batch input, statistics | APQ_TRAN | INT4 | 10 | 0 | |||
| MSGCNTD | Message counter: Batch input, statistics | APQ_RECO | INT4 | 10 | 0 | |||
| TRANSCNTF | Transaction counter: Batch input, statistics | APQ_TRAN | INT4 | 10 | 0 | |||
| MSGCNTF | Message counter: Batch input, statistics | APQ_RECO | INT4 | 10 | 0 | |||
