APQI

Transparent Table Temporary Data
40 Fields 1 CDS Views

Queue info definition

APQI is an SAP database table in S/4HANA. Queue info definition. It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
BDC_V_APQI_AUTH_APP_AREA view from CDS: APQI mit Berechtigung auf BDC_APP_AREA

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY destsys APQ_DEST Target System
KEY destapp APQ_APPL Target appl.
KEY datatyp APQ_DTYP Data type
KEY mandant APQ_MANDT Client
KEY groupid APQ_GRPN Group name
KEY progid APQ_PROG Program
KEY formid APQ_MODP Modules
KEY qattrib APQ_QATT Attribute
KEY qid APQ_QUID Queue name
qstate APQ_STAT Status
qerase APQ_QDEL Deletion Ind.
userid APQ_MAPN User ID
passwd APQ_PASS Password
creator APQ_MAPN User ID
credate APQ_CRDA Created on
cretime APQ_CRTI Created at
startpgid APQ_TREI Driver
startmode APQ_STRT Start mode
startdate APQ_STDA Lock until:
starttime APQ_STTI Start time
putactive APQ_OUAC PUTQ act.flag
putpid APQ_OUID PUTQ ProcID
puttrans APQ_OUTR PUTQ TranCnt
putblock APQ_OUBL Queue sum blcks
putdate APQ_OUDA PUTQ last PUTQ
puttime APQ_OUTI PUTQ last time
getactive APQ_INAC GETQ AFlag
getpid APQ_INID GETQ ProcID
gettrans APQ_INTR GETQ TranCnt
getblock APQ_INBL Queue sum blck
getdate APQ_INDA GETQ last GETQ
gettime APQ_INTI GETQ last time
transcnt APQ_TRAN Transaction#
msgcnt APQ_RECO Message counter
transcnte APQ_TRAN Transaction#
msgcnte APQ_RECO Message counter
transcntd APQ_TRAN Transaction#
msgcntd APQ_RECO Message counter
transcntf APQ_TRAN Transaction#
msgcntf APQ_RECO Message counter

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.

-- Queue info definition
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE APQI (
    DESTSYS,    -- Target System [APQ_DEST]
    DESTAPP,    -- Target appl. [APQ_APPL]
    DATATYP,    -- Data type [APQ_DTYP]
    MANDANT,    -- Client [APQ_MANDT]
    GROUPID,    -- Group name [APQ_GRPN]
    PROGID,     -- Program [APQ_PROG]
    FORMID,     -- Modules [APQ_MODP]
    QATTRIB,    -- Attribute [APQ_QATT]
    QID,        -- Queue name [APQ_QUID]
    QSTATE,     -- Status [APQ_STAT]
    QERASE,     -- Deletion Ind. [APQ_QDEL]
    USERID,     -- User ID [APQ_MAPN]
    PASSWD,     -- Password [APQ_PASS]
    CREATOR,    -- User ID [APQ_MAPN]
    CREDATE,    -- Created on [APQ_CRDA]
    CRETIME,    -- Created at [APQ_CRTI]
    STARTPGID,  -- Driver [APQ_TREI]
    STARTMODE,  -- Start mode [APQ_STRT]
    STARTDATE,  -- Lock until: [APQ_STDA]
    STARTTIME,  -- Start time [APQ_STTI]
    PUTACTIVE,  -- PUTQ act.flag [APQ_OUAC]
    PUTPID,     -- PUTQ ProcID [APQ_OUID]
    PUTTRANS,   -- PUTQ TranCnt [APQ_OUTR]
    PUTBLOCK,   -- Queue sum blcks [APQ_OUBL]
    PUTDATE,    -- PUTQ last PUTQ [APQ_OUDA]
    PUTTIME,    -- PUTQ last time [APQ_OUTI]
    GETACTIVE,  -- GETQ AFlag [APQ_INAC]
    GETPID,     -- GETQ ProcID [APQ_INID]
    GETTRANS,   -- GETQ TranCnt [APQ_INTR]
    GETBLOCK,   -- Queue sum blck [APQ_INBL]
    GETDATE,    -- GETQ last GETQ [APQ_INDA]
    GETTIME,    -- GETQ last time [APQ_INTI]
    TRANSCNT,   -- Transaction# [APQ_TRAN]
    MSGCNT,     -- Message counter [APQ_RECO]
    TRANSCNTE,  -- Transaction# [APQ_TRAN]
    MSGCNTE,    -- Message counter [APQ_RECO]
    TRANSCNTD,  -- Transaction# [APQ_TRAN]
    MSGCNTD,    -- Message counter [APQ_RECO]
    TRANSCNTF,  -- Transaction# [APQ_TRAN]
    MSGCNTF,    -- Message counter [APQ_RECO]
    PRIMARY KEY (DESTSYS, DESTAPP, DATATYP, MANDANT, GROUPID, PROGID, FORMID, QATTRIB, QID)
);

Learn More