SAP table reference
TQ30
Inspection typesExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table TQ30.
SAP table TQ30 has 2 primary key fields: MANDT,ART.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
TQ30 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||||||||||||||
| Key ART | 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 relationships.
| 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 |