- Home
- Resources
- SAP Tables
- 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.
Source: QPAC (Inspection catalog codes for selected sets)
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 |
Possible values
| 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 |
Possible values
| NULL |
Indicator is not set |
| X |
Indicator is set |
|
| BEWERTUNG |
Code Valuation |
QBEWERTUNG |
|
CHAR |
|
1 |
0 |
Possible values
| 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 |
Possible values
| NULL |
Indicator is not set |
| X |
Indicator is set |
|
| AENDERKZ |
Consider Long-Term Characteristics for Stock Proposal |
Q1LZEITMK |
|
CHAR |
|
1 |
0 |
Possible values
| 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 |
Possible values
| NULL |
Indicator is not set |
| X |
Indicator is set |
|
| BB_DUNKEL |
Background Processing of Stock Screen |
Q_BB_DARK |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Indicator is not set |
| X |
Indicator is set |
|
| FELDNAME |
Posting Proposal in Usage Decision |
QMGBUCH |
|
CHAR |
|
10 |
0 |
Possible values
| 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 |
KATALOGART |
QPAM |
Inspection catalog selected sets |
KATALOGART |
| QPAC |
AUSWAHLMGE |
QPAC |
WERKS |
QPAM |
Inspection catalog selected sets |
WERKS |
| QPAC |
AUSWAHLMGE |
QPAC |
MANDT |
QPAM |
Inspection catalog selected sets |
MANDT |
| QPAC |
CODE |
'000001' |
|
QPCD |
Inspection catalog codes |
VERSION |
| QPAC |
CODE |
QPAC |
CODE |
QPCD |
Inspection catalog codes |
CODE |
| QPAC |
CODE |
QPAC |
CODEGRUPPE |
QPCD |
Inspection catalog codes |
CODEGRUPPE |
| QPAC |
CODE |
QPAC |
KATALOGART |
QPCD |
Inspection catalog codes |
KATALOGART |
| QPAC |
CODE |
QPAC |
MANDT |
QPCD |
Inspection catalog codes |
MANDT |
| 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 |
FEHLKLASSE |
TQ17 |
Defect classes |
FEHLKLASSE |
| QPAC |
FEHLKLASSE |
QPAC |
MANDT |
TQ17 |
Defect classes |
MANDT |
| QPAC |
FOLGEAKTI |
QPAC |
FOLGEAKTI |
TQ07 |
Follow-Up Action for Usage Decision of Inspection Lot |
FOLGEAKTI |
| QPAC |
FOLGEAKTI |
QPAC |
MANDT |
TQ07 |
Follow-Up Action for Usage Decision of Inspection Lot |
MANDT |
| QPAC |
KATALOGART |
QPAC |
KATALOGART |
TQ15 |
Inspection catalog type index |
KATALOGART |
| QPAC |
KATALOGART |
QPAC |
MANDT |
TQ15 |
Inspection catalog type index |
MANDT |
| QPAC |
MANDT |
QPAC |
MANDT |
T000 |
Clients |
MANDT |
| QPAC |
WAEHRUNG |
QPAC |
WAEHRUNG |
TCURC |
Currency Codes |
WAERS |
| QPAC |
WAEHRUNG |
QPAC |
MANDT |
TCURC |
Currency Codes |
MANDT |
| QPAC |
WERKS |
QPAC |
WERKS |
T001W |
Plants/Branches |
WERKS |
| QPAC |
WERKS |
QPAC |
MANDT |
T001W |
Plants/Branches |
MANDT |
