SAP Table TQ30
Inspection types
TQ30 (Inspection types) 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 TQ30 to other SAP tables.
TQ30 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||||
|
ART
Inspection Type
|
QPART |
CHAR
|
8 | 0 | ||||||||||||||||||||||||||||
|
PPLVERW
Task List Usage
|
QPLN_VERWE | T411 |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||
|
BILDS
Key for Field Control (Not Used After 3.0)
|
QBILDS |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
VEMENGE
Selected Set for Usage Decision
|
QVEMENGE | QPAM |
CHAR
|
8 | 0 | |||||||||||||||||||||||||||
|
VEVERSION
Code Version Used for an Automatic Usage Decision
|
QVEVERSION |
CHAR
|
6 | 0 | ||||||||||||||||||||||||||||
|
VEDATUM
Date of Code Used for Usage Decision
|
QVEDATUM |
DATS
|
8 | 0 | ||||||||||||||||||||||||||||
|
KZVEWERKS
Selected Set Must Be Available in Plant
|
QKZVEWERKS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
KZPZDR
Print Sample-Drawing Instruction Immediately at Lot Creation
|
QKZPZDR |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
KZPADR
Print Inspection Instruction Immediately at Lot Creation
|
QKZPADR |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
KZMESSAGE
Messages Should Be Displayed When Printing
|
QKZMESSAGE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
STSMA
Status Profile
|
J_STSMA | TJ20 |
CHAR
|
8 | 0 | |||||||||||||||||||||||||||
|
ERFSICHT
Recording View
|
QERFSICHT |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
STEUS
Control key
|
STEUS | T430 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
|
QMART
Notification Type
|
QMART | TQ80 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
VORNR
Operation/Activity Number
|
VORNR |
CHAR
|
4 | 0 | ||||||||||||||||||||||||||||
|
PRART
Physical-Sample Type
|
QPRART | TQ40 |
CHAR
|
2 | 0 | |||||||||||||||||||||||||||
|
EINEMELD
One Quality Notification per Inspection Lot
|
QEINEMELD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||
|
AUART
Order Type for QM Orders As Default Value for Insp. Type
|
QAUARTTQ30 | T003O |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||
TQ30 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TQ30 | AUART | TQ30 | AUART |
T003O
Order Types
|
AUART |
| TQ30 | AUART | TQ30 | MANDT |
T003O
Order Types
|
CLIENT |
| TQ30 | MANDT | TQ30 | MANDT |
T000
Clients
|
MANDT |
| TQ30 | PPLVERW | TQ30 | MANDT |
T411
Task list usage
|
MANDT |
| TQ30 | PPLVERW | TQ30 | PPLVERW |
T411
Task list usage
|
VERWE |
| TQ30 | PRART | TQ30 | MANDT |
TQ40
Definition of sample types
|
MANDT |
| TQ30 | PRART | TQ30 | PRART |
TQ40
Definition of sample types
|
PRART |
| TQ30 | QMART | TQ30 | MANDT |
TQ80
Notification Types
|
MANDT |
| TQ30 | QMART | TQ30 | QMART |
TQ80
Notification Types
|
QMART |
| TQ30 | STEUS | TQ30 | STEUS |
T430
Operation/Activity control key
|
STEUS |
| TQ30 | STEUS | TQ30 | MANDT |
T430
Operation/Activity control key
|
MANDT |
| TQ30 | STEUS | * |
T430
Operation/Activity control key
|
PLNAW | |
| TQ30 | STSMA | TQ30 | MANDT |
TJ20
Status profiles
|
MANDT |
| TQ30 | STSMA | TQ30 | STSMA |
TJ20
Status profiles
|
STSMA |
| TQ30 | VEMENGE | TQ30 | MANDT |
QPAM
Inspection catalog selected sets
|
MANDT |
| TQ30 | VEMENGE | * |
QPAM
Inspection catalog selected sets
|
WERKS | |
| TQ30 | VEMENGE | '3' |
QPAM
Inspection catalog selected sets
|
KATALOGART | |
| TQ30 | VEMENGE | TQ30 | VEMENGE |
QPAM
Inspection catalog selected sets
|
AUSWAHLMGE |