SAP Table QPACI

Inspection catalog codes for selected sets

QPACI (Inspection catalog codes for selected sets) 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 QPACI to other SAP tables.

Source: QPACI (Inspection catalog codes for selected sets)

QPACI table fields

Field Data element Checktable Datatype Length Decimals
CODEGRUPPE Code Group QCODEGRP CHAR 8 0
CODE Code QCODE CHAR 4 0
VERSIONAM Version Number of the Selected Set Record QVERSNRAM CHAR 6 0
GUELTIGAM Valid-From Date DATUV DATS 8 0
VERSIONCD Version Number of the Code Record QVERSNRCD CHAR 6 0
GUELTIGAB Valid-From Date DATUV DATS 8 0
MODUS X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
MASSNAHME Short Text for Task QMASSKTEXT CHAR 40 0
LTEXTMASSV Long Text Exists for the Task QLTEXTMS CHAR 1 0
NULL Indicator is not set
X Indicator is set
LTEXTM_UPD X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
AUSWIRKUNG Short Text About Effect QAUSWKTEXT CHAR 40 0
LTEXTAUSWV Long Text Exists for the Effect QLTEXTAW CHAR 1 0
NULL Indicator is not set
X Indicator is set
LTEXTA_UPD X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
MUSSTEXTKZ Text Must Be Entered when Results Are Confirmed QMUSSTKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
BEWERTUNG Code Valuation QBEWERTUNG CHAR 1 0
NULL Not valuated
A Accepted (OK)
R Rejected (not OK)
QKENNZAHL Quality Score QKENNZAHL DEC 3 0
FOLGEAKTI Follow-Up Action QFOLGEAKTI TQ07 CHAR 8 0
FEHLKLASSE Defect Class QFEHLKLAS CHAR 2 0
AENDERKZ Create Change Documents QAENKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
GELOESCHT Data Record Was Deleted QGEL CHAR 1 0
NULL Indicator is not set
X Indicator is set
BB_VORSCH Stock Posting Proposal Q_BB_VOR CHAR 1 0
NULL Indicator is not set
X Indicator is set
BB_DUNKEL Background Processing of Stock Screen Q_BB_DARK CHAR 1 0
NULL Indicator is not set
X Indicator is set
FELDNAME Posting Proposal in Usage Decision QMGBUCH CHAR 10 0
VMENGE01 To unrestricted use
VMENGE02 To scrap
VMENGE03 To sample
VMENGE04 To blocked stock
VMENGE05 To reserve samples
VMENGE06 New material
VMENGE07 Return delivery
VMENGE08 other qty posting
VMENGE09 other qty posting 2
TRANSFER01 Stock transfers (plant)
TRANSFER02 Stock transfers (StLoc)
1 Unrestricted batch status
VMENGE01 1 To unrestricted use; Unrestricted batch status
VMENGE02 1 To scrap; Unrestricted batch status
VMENGE03 1 To sample; Unrestricted batch status
VMENGE04 1 To blocked stock; Unrestricted batch status
VMENGE05 1 To appropriation; Unrestricted batch status
VMENGE06 1 New material; Unrestricted batch status
VMENGE07 1 Return delivery; Unrestricted batch status
VMENGE08 1 other qty posting; Unrestricted batch status
VMENGE09 1 Other qty posting 2; Unrestricted batch status
0 Blocked batch status
VMENGE01 0 To unrestricted use stock; Blocked batch status
VMENGE02 0 To scrap; Blocked batch status
VMENGE03 0 To sample; Blocked batch status
VMENGE04 0 To blocked stock; Blocked batch status
VMENGE05 0 To appropriation; Blocked batch status
VMENGE06 0 New material; Blocked batch status
VMENGE07 0 Return delivery; Blocked batch status
VMENGE08 0 other qty posting; Blocked batch status
VMENGE09 0 other qty posting 2; Blocked batch status

QPACI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QPACI FOLGEAKTI TQ07 MANDT TQ07 Follow-Up Action for Usage Decision of Inspection Lot MANDT
QPACI FOLGEAKTI QPACI FOLGEAKTI TQ07 Follow-Up Action for Usage Decision of Inspection Lot FOLGEAKTI