- Home
- Resources
- SAP Tables
- TQ30 - Inspection types
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.
Source: TQ30 (Inspection types)
TQ30 table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
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 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
KZPZDR |
Print Sample-Drawing Instruction Immediately at Lot Creation |
QKZPZDR |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
KZPADR |
Print Inspection Instruction Immediately at Lot Creation |
QKZPADR |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
KZMESSAGE |
Messages Should Be Displayed When Printing |
QKZMESSAGE |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
STSMA |
Status Profile |
J_STSMA |
TJ20
|
CHAR |
|
8 |
0 |
|
ERFSICHT |
Recording View |
QERFSICHT |
|
CHAR |
|
2 |
0 |
Possible values
12 |
Single values and summarized results |
10 |
Summarized results |
11 |
Recording by units to be inspected |
78 |
Control indicators |
01 |
Old view: Measured values |
02 |
Old view: Attribute codes |
03 |
Old view: Nonconfoming units |
04 |
Old view: Number of defects |
05 |
Old view: Overview |
30 |
Multiple Specification |
77 |
Old view: Type of first characteristic |
NULL |
Single values and summarized results (default view) |
|
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 |
Possible values
NULL |
Indicator is not set |
X |
Indicator is set |
|
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 |
MANDT |
T003O |
Order Types |
CLIENT |
TQ30 |
AUART |
TQ30 |
AUART |
T003O |
Order Types |
AUART |
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 |
PRART |
TQ40 |
Definition of sample types |
PRART |
TQ30 |
PRART |
TQ30 |
MANDT |
TQ40 |
Definition of sample types |
MANDT |
TQ30 |
QMART |
TQ30 |
MANDT |
TQ80 |
Notification Types |
MANDT |
TQ30 |
QMART |
TQ30 |
QMART |
TQ80 |
Notification Types |
QMART |
TQ30 |
STEUS |
* |
|
T430 |
Operation/Activity control key |
PLNAW |
TQ30 |
STEUS |
TQ30 |
STEUS |
T430 |
Operation/Activity control key |
STEUS |
TQ30 |
STEUS |
TQ30 |
MANDT |
T430 |
Operation/Activity control key |
MANDT |
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 |