SAP Table QPCT17
Description of the codes in QMFE, defect location
QPCT17 (Description of the codes in QMFE, defect location) 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 QPCT17 to other SAP tables.
QPCT17 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 | QPCD | CHAR | 4 | 0 | ||||||
| SPRACHE | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||
| VERSION | Version Number | QVERSNR | CHAR | 6 | 0 | |||||||
| GUELTIGAB | Valid-From Date | DATUV | DATS | 8 | 0 | |||||||
| KURZTEXT | Short Text for Code (Up to 40 Characters in Length) | QTXT_CODE | CHAR | 40 | 0 | |||||||
| LTEXTV | Long Text Exists for the Code | QLTEXTCODE | CHAR | 1 | 0 |
Possible values
|
||||||
| INAKTIV | Status of Code Group or Code Record | QINAK | CHAR | 1 | 0 |
Possible values
|
||||||
| GELOESCHT | Data Record Was Deleted | QGEL | CHAR | 1 | 0 |
Possible values
|
||||||
QPCT17 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| QPCT17 | CODE | QPCT17 | MANDT | QPCD | Inspection catalog codes | MANDT |
| QPCT17 | CODE | QPCT17 | KATALOGART | QPCD | Inspection catalog codes | KATALOGART |
| QPCT17 | CODE | QPCT17 | CODEGRUPPE | QPCD | Inspection catalog codes | CODEGRUPPE |
| QPCT17 | CODE | QPCT17 | CODE | QPCD | Inspection catalog codes | CODE |
| QPCT17 | CODE | QPCT17 | VERSION | QPCD | Inspection catalog codes | VERSION |
| QPCT17 | CODEGRUPPE | QPCT17 | KATALOGART | QPGR | Inspection catalog code groups | KATALOGART |
| QPCT17 | CODEGRUPPE | QPCT17 | CODEGRUPPE | QPGR | Inspection catalog code groups | CODEGRUPPE |
| QPCT17 | CODEGRUPPE | QPCT17 | MANDT | QPGR | Inspection catalog code groups | MANDT |
| QPCT17 | KATALOGART | QPCT17 | KATALOGART | TQ15 | Inspection catalog type index | KATALOGART |
| QPCT17 | KATALOGART | QPCT17 | MANDT | TQ15 | Inspection catalog type index | MANDT |
| QPCT17 | MANDT | QPCT17 | MANDT | T000 | Clients | MANDT |
| QPCT17 | SPRACHE | QPCT17 | SPRACHE | T002 | Language Keys (Component BC-I18) | SPRAS |
