SAP Table QPCD
Inspection catalog codes
QPCD (Inspection catalog codes) 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 QPCD to other SAP tables.
QPCD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
KATALOGART
Catalog
|
QKATART | TQ15 |
CHAR
|
1 | 0 | |||||||
|
CODEGRUPPE
Code Group
|
QCODEGRP | QPGR |
CHAR
|
8 | 0 | |||||||
|
CODE
Code
|
QCODE |
CHAR
|
4 | 0 | ||||||||
|
VERSION
Version Number
|
QVERSNR |
CHAR
|
6 | 0 | ||||||||
|
GUELTIGAB
Valid-From Date
|
DATUV |
DATS
|
8 | 0 | ||||||||
|
FEHLKLASSE
Defect Class
|
QFEHLKLAS | TQ17 |
CHAR
|
2 | 0 | |||||||
|
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 | ||||||||
|
INAKTIV
Status of Code Group or Code Record
|
QINAK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
VERWENDUNG
Data Record Is Used
|
QVERW |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
GELOESCHT
Data Record Was Deleted
|
QGEL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
FOLGEAKTI
Follow-Up Action
|
QFOLGEAKTI | TQ07 |
CHAR
|
8 | 0 | |||||||
QPCD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| QPCD | CODEGRUPPE | QPCD | MANDT |
QPGR
Inspection catalog code groups
|
MANDT |
| QPCD | CODEGRUPPE | QPCD | KATALOGART |
QPGR
Inspection catalog code groups
|
KATALOGART |
| QPCD | CODEGRUPPE | QPCD | CODEGRUPPE |
QPGR
Inspection catalog code groups
|
CODEGRUPPE |
| QPCD | FEHLKLASSE | QPCD | MANDT |
TQ17
Defect classes
|
MANDT |
| QPCD | FEHLKLASSE | QPCD | FEHLKLASSE |
TQ17
Defect classes
|
FEHLKLASSE |
| QPCD | FOLGEAKTI | QPCD | MANDT |
TQ07
Follow-Up Action for Usage Decision of Inspection Lot
|
MANDT |
| QPCD | FOLGEAKTI | QPCD | FOLGEAKTI |
TQ07
Follow-Up Action for Usage Decision of Inspection Lot
|
FOLGEAKTI |
| QPCD | KATALOGART | QPCD | MANDT |
TQ15
Inspection catalog type index
|
MANDT |
| QPCD | KATALOGART | QPCD | KATALOGART |
TQ15
Inspection catalog type index
|
KATALOGART |
| QPCD | MANDT | QPCD | MANDT |
T000
Clients
|
MANDT |