APQI

Transparent Table Temporary Data
41 Fields 1 CDS Views

Queue INFO DEFINITION

APQI is an SAP database table in S/4HANA. Queue INFO DEFINITION. It contains 41 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 (41)

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
job_templ apj_job_template_name Job Template Name

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]
    JOB_TEMPL,  -- Job Template Name [apj_job_template_name]
    PRIMARY KEY (DESTSYS, DESTAPP, DATATYP, MANDANT, GROUPID, PROGID, FORMID, QATTRIB, QID)
);

Learn More