SAP-tabelreferentie
TQ30
Inspection typesBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel TQ30.
SAP-tabel TQ30 heeft 2 primaire sleutelvelden: MANDT,ART.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
/ Velden
TQ30 velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||||||||||||||
| Sleutel 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 | |||||||||||||||||||||||||||
/ Relaties
TQ30 relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| 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 |