SAP Table TQ86
Report category for defects recording
TQ86 (Report category for defects recording) 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 TQ86 to other SAP tables.
TQ86 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
FEART
Report Type for Defects Recording
|
QFEART |
CHAR
|
8 | 0 | ||||||||
|
RPROFIL
Confirmation Profile
|
QRPROFIL | TQ84 |
CHAR
|
4 | 0 | |||||||
|
RBNR
Catalog Profile
|
RBNR | T352B |
CHAR
|
9 | 0 | |||||||
|
KZATOM
Import Default Values Automatically
|
QKZAUTOM |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZRBQMART
Copy Catalog Profile from Quality Notification Type
|
QRBNRQMART |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZRBMATNR
Copy Catalog Profile from Material Master
|
QRBNRMATNR |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZRBEQUI
Copy Catalog Profile from Equipment
|
QRBNREQUI |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KZRBTECHPL
Copy Catalog Profile from Functional Location
|
QRBNRTCHPL |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
TQ86 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TQ86 | MANDT | TQ86 | MANDT |
T000
Clients
|
MANDT |
| TQ86 | RBNR | TQ86 | MANDT |
T352B
Technical report
|
MANDT |
| TQ86 | RBNR | TQ86 | RBNR |
T352B
Technical report
|
RBNR |
| TQ86 | RPROFIL | TQ86 | MANDT |
TQ84
Confirmation profile
|
MANDT |
| TQ86 | RPROFIL | TQ86 | RPROFIL |
TQ84
Confirmation profile
|
RPROFIL |