1. Home
  2. Resources
  3. SAP Tables
  4. 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.

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
NULL Indicator is not set
X Indicator is set
KZPZDR Print Sample-Drawing Instruction Immediately at Lot Creation QKZPZDR CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZPADR Print Inspection Instruction Immediately at Lot Creation QKZPADR CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZMESSAGE Messages Should Be Displayed When Printing QKZMESSAGE CHAR 1 0
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
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
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 MANDT TQ40 Definition of sample types MANDT
TQ30 PRART TQ30 PRART TQ40 Definition of sample types PRART
TQ30 QMART TQ30 MANDT TQ80 Notification Types MANDT
TQ30 QMART TQ30 QMART TQ80 Notification Types QMART
TQ30 STEUS TQ30 MANDT T430 Operation/Activity control key MANDT
TQ30 STEUS * T430 Operation/Activity control key PLNAW
TQ30 STEUS TQ30 STEUS T430 Operation/Activity control key STEUS
TQ30 STSMA TQ30 MANDT TJ20 Status profiles MANDT
TQ30 STSMA TQ30 STSMA TJ20 Status profiles STSMA
TQ30 VEMENGE '3' QPAM Inspection catalog selected sets KATALOGART
TQ30 VEMENGE TQ30 VEMENGE QPAM Inspection catalog selected sets AUSWAHLMGE
TQ30 VEMENGE TQ30 MANDT QPAM Inspection catalog selected sets MANDT
TQ30 VEMENGE * QPAM Inspection catalog selected sets WERKS