SAP APQI Queue info definition Table
Overview
APQI is a standard SAP S/4HANA table that stores Queue info definition data. There are total 40 fields in the APQI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table APQI belongs to UI Services, Screen, Batch Input (BC-ABA-SC) module and is located in the package SAP Batch Input (SBDC).
In addition, following links provide an overview of foreign key relationships, if any, that link APQI to other SAP tables and standard CDS views available based on APQI table in S/4HANA 2020.
Techincal Settings of APQI
Below are technical details of the table APQI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of APQI Fields
The following table gives you an overview of the fields available in APQI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| 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 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for APQI