SAP table TQ30 (Inspection types)

SAP table TQ30 has 2 primary key fields being MANDT,ART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
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
Single Values and Summarized Results (Default View)
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
10 Summarized Results
11 Recording by Units to Be Inspected
12 Single Values and Summarized Results
30 Multiple Specification
60 Extensibility
77 Old View: Type of First Characteristic
78 Control Indicators
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

TQ30 foreign key relationships

Table Field Check Table Check Field
0 TQ30 AUART T003O Order Types AUART
1 TQ30 PPLVERW T411 Task list usage MANDT
0 TQ30 PRART TQ40 Definition of sample types MANDT
0 TQ30 PRART TQ40 Definition of sample types PRART
1 TQ30 QMART TQ80 Notification Types MANDT
1 TQ30 QMART TQ80 Notification Types QMART
0 TQ30 STEUS T430 Operation/Activity control key MANDT
0 TQ30 STEUS T430 Operation/Activity control key PLNAW
0 TQ30 STEUS T430 Operation/Activity control key STEUS
1 TQ30 STSMA TJ20 Status profiles MANDT
1 TQ30 STSMA TJ20 Status profiles STSMA
0 TQ30 VEMENGE QPAM Inspection catalog selected sets MANDT
0 TQ30 VEMENGE QPAM Inspection catalog selected sets WERKS
0 TQ30 VEMENGE QPAM Inspection catalog selected sets KATALOGART