SAP Table
TQ30 Inspection types
SAP table TQ30 has 2 primary key fields being MANDT,ART.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TQ30 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||||||||||||||
| KeyART | Inspection Type | CHAR | 8 | 0 | QPART | ||||||||||||||||||||||||||||
| PPLVERW | Task List Usage | CHAR | 3 | 0 | T411 | QPLN_VERWE | |||||||||||||||||||||||||||
| BILDS | Key for Field Control (Not Used After 3.0) | CHAR | 2 | 0 | QBILDS | ||||||||||||||||||||||||||||
| VEMENGE | Selected Set for Usage Decision | CHAR | 8 | 0 | QPAM | QVEMENGE | |||||||||||||||||||||||||||
| VEVERSION | Code Version Used for an Automatic Usage Decision | CHAR | 6 | 0 | QVEVERSION | ||||||||||||||||||||||||||||
| VEDATUM | System Date When Usage Decision Was Recorded | DATS | 8 | 0 | QVEDATUM | ||||||||||||||||||||||||||||
| KZVEWERKS | Selected Set Must Be Available in Plant | CHAR | 1 | 0 | QKZVEWERKS | ||||||||||||||||||||||||||||
| KZPZDR | Print Sample-Drawing Instruction Immediately at Lot Creation | CHAR | 1 | 0 | QKZPZDR | ||||||||||||||||||||||||||||
| KZPADR | Print Inspection Instruction Immediately at Lot Creation | CHAR | 1 | 0 | QKZPADR | ||||||||||||||||||||||||||||
| KZMESSAGE | Messages Should Be Included When Printing | CHAR | 1 | 0 | QKZMESSAGE | ||||||||||||||||||||||||||||
| STSMA | Status Profile | CHAR | 8 | 0 | TJ20 | J_STSMA | |||||||||||||||||||||||||||
| ERFSICHT | Recording View | CHAR | 2 | 0 | QERFSICHT | ||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
| STEUS | Control key | CHAR | 4 | 0 | T430 | STEUS | |||||||||||||||||||||||||||
| QMART | Notification Type | CHAR | 2 | 0 | TQ80 | QMART | |||||||||||||||||||||||||||
| VORNR | Operation/Activity Number | CHAR | 4 | 0 | VORNR | ||||||||||||||||||||||||||||
| PRART | Material Sample Type | CHAR | 2 | 0 | TQ40 | QPRART | |||||||||||||||||||||||||||
| EINEMELD | One Quality Notification per Inspection Lot | CHAR | 1 | 0 | QEINEMELD | ||||||||||||||||||||||||||||
| AUART | Order Type for QM Orders As Default Value for Insp. Type | CHAR | 4 | 0 | T003O | QAUARTTQ30 | |||||||||||||||||||||||||||
/ Relationships
TQ30 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TQ30 | AUART | T003O | Order Types | AUART |
| TQ30 | PPLVERW | T411 | Task list usage | MANDT |
| TQ30 | PRART | TQ40 | Definition of sample types | MANDT |
| TQ30 | PRART | TQ40 | Definition of sample types | PRART |
| TQ30 | QMART | TQ80 | Notification Types | MANDT |
| TQ30 | QMART | TQ80 | Notification Types | QMART |
| TQ30 | STEUS | T430 | Operation/Activity control key | MANDT |
| TQ30 | STEUS | T430 | Operation/Activity control key | PLNAW |
| TQ30 | STEUS | T430 | Operation/Activity control key | STEUS |
| TQ30 | STSMA | TJ20 | Status profiles | MANDT |
| TQ30 | STSMA | TJ20 | Status profiles | STSMA |
| TQ30 | VEMENGE | QPAM | Inspection catalog selected sets | MANDT |
| TQ30 | VEMENGE | QPAM | Inspection catalog selected sets | WERKS |
| TQ30 | VEMENGE | QPAM | Inspection catalog selected sets | KATALOGART |