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 | 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 | 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 | ||||||||
|
||||||||||||
|
INAKTIV
Status of Code Group or Code Record
|
QINAK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
GELOESCHT
Data Record Was Deleted
|
QGEL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
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 |