SAP Table QPCT
Code texts
QPCT (Code texts) 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 QPCT to other SAP tables.
QPCT 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
|
||||||
QPCT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| QPCT | CODE | QPCT | MANDT | QPCD | Inspection catalog codes | MANDT |
| QPCT | CODE | QPCT | KATALOGART | QPCD | Inspection catalog codes | KATALOGART |
| QPCT | CODE | QPCT | CODEGRUPPE | QPCD | Inspection catalog codes | CODEGRUPPE |
| QPCT | CODE | QPCT | CODE | QPCD | Inspection catalog codes | CODE |
| QPCT | CODE | QPCT | VERSION | QPCD | Inspection catalog codes | VERSION |
| QPCT | CODEGRUPPE | QPCT | KATALOGART | QPGR | Inspection catalog code groups | KATALOGART |
| QPCT | CODEGRUPPE | QPCT | CODEGRUPPE | QPGR | Inspection catalog code groups | CODEGRUPPE |
| QPCT | CODEGRUPPE | QPCT | MANDT | QPGR | Inspection catalog code groups | MANDT |
| QPCT | KATALOGART | QPCT | KATALOGART | TQ15 | Inspection catalog type index | KATALOGART |
| QPCT | KATALOGART | QPCT | MANDT | TQ15 | Inspection catalog type index | MANDT |
| QPCT | MANDT | QPCT | MANDT | T000 | Clients | MANDT |
| QPCT | SPRACHE | QPCT | SPRACHE | T002 | Language Keys (Component BC-I18) | SPRAS |
