1. Home
  2. Resources
  3. SAP Tables
  4. QPAC - Inspection catalog codes for selected sets

SAP Table QPAC

Inspection catalog codes for selected sets

QPAC (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 QPAC to other SAP tables.

QPAC table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
WERKS Plant WERKS_D T001W CHAR 4 0
KATALOGART Catalog QKATART TQ15 CHAR 1 0
AUSWAHLMGE Selected Set QAUSWAHLMG QPAM CHAR 8 0
CODEGRUPPE Code Group QCODEGRP QPGR CHAR 8 0
CODE Code QCODE QPCD CHAR 4 0
VERSIONAM Version Number of the Selected Set Record QVERSNRAM CHAR 6 0
GUELTIGAB Valid-From Date DATUV DATS 8 0
VERSIONCD Version Number of the Code Record QVERSNRCD CHAR 6 0
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
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
BEWERTUNG Code Valuation QBEWERTUNG CHAR 1 0
NULL Not valuated
A Accepted (OK)
R Rejected (not OK)
FEHLKLASSE Defect Class QFEHLKLAS TQ17 CHAR 2 0
WAEHRUNG Currency Key WAERS TCURC CUKY 5 0
FKOSTEN Nonconformity Costs QFKOSTEN CURR 10 2
MUSSTEXTKZ Text Must Be Entered when Results Are Confirmed QMUSSTKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
AENDERKZ Consider Long-Term Characteristics for Stock Proposal Q1LZEITMK CHAR 1 0
NULL Do Not Consider
X Do Not Consider
1 Consider Long-Term Characteristics for Stock Proposal
ERSTELLER Name of User Who Created the Data Record QERSTELLER CHAR 12 0
E_DATUM Date on Which the Data Record Was Created QDATUMERST DATS 8 0
AENDERER Name of User who Most Recently Changed the Data Record QAENDERER CHAR 12 0
A_DATUM Date on Which Data Record Was Changed QDATUMAEND DATS 8 0
GELOESCHT Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
QKENNZAHL Quality Score QKENNZ INT4 10 0
FOLGEAKTI Follow-Up Action QFOLGEAKTI TQ07 CHAR 8 0
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

QPAC foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QPAC AUSWAHLMGE QPAC AUSWAHLMGE QPAM Inspection catalog selected sets AUSWAHLMGE
QPAC AUSWAHLMGE QPAC MANDT QPAM Inspection catalog selected sets MANDT
QPAC AUSWAHLMGE QPAC WERKS QPAM Inspection catalog selected sets WERKS
QPAC AUSWAHLMGE QPAC KATALOGART QPAM Inspection catalog selected sets KATALOGART
QPAC CODE '000001' QPCD Inspection catalog codes VERSION
QPAC CODE QPAC MANDT QPCD Inspection catalog codes MANDT
QPAC CODE QPAC KATALOGART QPCD Inspection catalog codes KATALOGART
QPAC CODE QPAC CODEGRUPPE QPCD Inspection catalog codes CODEGRUPPE
QPAC CODE QPAC CODE QPCD Inspection catalog codes CODE
QPAC CODEGRUPPE QPAC MANDT QPGR Inspection catalog code groups MANDT
QPAC CODEGRUPPE QPAC KATALOGART QPGR Inspection catalog code groups KATALOGART
QPAC CODEGRUPPE QPAC CODEGRUPPE QPGR Inspection catalog code groups CODEGRUPPE
QPAC FEHLKLASSE QPAC MANDT TQ17 Defect classes MANDT
QPAC FEHLKLASSE QPAC FEHLKLASSE TQ17 Defect classes FEHLKLASSE
QPAC FOLGEAKTI QPAC MANDT TQ07 Follow-Up Action for Usage Decision of Inspection Lot MANDT
QPAC FOLGEAKTI QPAC FOLGEAKTI TQ07 Follow-Up Action for Usage Decision of Inspection Lot FOLGEAKTI
QPAC KATALOGART QPAC MANDT TQ15 Inspection catalog type index MANDT
QPAC KATALOGART QPAC KATALOGART TQ15 Inspection catalog type index KATALOGART
QPAC MANDT QPAC MANDT T000 Clients MANDT
QPAC WAEHRUNG QPAC MANDT TCURC Currency Codes MANDT
QPAC WAEHRUNG QPAC WAEHRUNG TCURC Currency Codes WAERS
QPAC WERKS QPAC WERKS T001W Plants/Branches WERKS
QPAC WERKS QPAC MANDT T001W Plants/Branches MANDT