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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||
| VERWENDUNG | Data Record Is Used | QVERW | CHAR | 1 | 0 |
Possible values
|
||||||
| GELOESCHT | Data Record Was Deleted | QGEL | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 | CODEGRUPPE | QPGR | Inspection catalog code groups | CODEGRUPPE |
| QPCD | CODEGRUPPE | QPCD | MANDT | QPGR | Inspection catalog code groups | MANDT |
| QPCD | CODEGRUPPE | QPCD | KATALOGART | QPGR | Inspection catalog code groups | KATALOGART |
| 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 | KATALOGART | TQ15 | Inspection catalog type index | KATALOGART |
| QPCD | KATALOGART | QPCD | MANDT | TQ15 | Inspection catalog type index | MANDT |
| QPCD | MANDT | QPCD | MANDT | T000 | Clients | MANDT |
