TQ30 SAP (Inspection types) Table details

Dictionary Type: Table
Description: Inspection types




ABAP Code to SELECT data from TQ30
Related tables to TQ30
Access table TQ30




Table field list including key, data, relationships and ABAP select examples

TQ30 is a standard SAP Table which is used to store Inspection types data and is available within R/3 SAP systems depending on the version and release level.

The TQ30 table consists of various fields, each holding specific information or linking keys about Inspection types data available in SAP. These include ART (Inspection Type), PPLVERW (Task List Usage), BILDS (Key for Field Control (Not Used After 3.0)), VEMENGE (Selected Set for Usage Decision).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: G - Customising table which is protected against SAP Update
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = TQ30T


SAP TQ30 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
ARTInspection Type QPARTCHAR8QPARTQLA
PPLVERWTask List Usage QPLN_VERWECHAR3T411PLN_VERWE
BILDSKey for Field Control (Not Used After 3.0) QBILDSCHAR2QBILDS
VEMENGESelected Set for Usage Decision QVEMENGECHAR8QPAMQAUSWAHLMGAWM
VEVERSIONCode Version Used for an Automatic Usage Decision QVEVERSIONCHAR6ALPHAQVERSNR
VEDATUMDate of Code Used for Usage Decision QVEDATUMDATS8DATUM
KZVEWERKSSelected Set Must Be Available in Plant QKZVEWERKSCHAR1QKZ
KZPZDRPrint Sample-Drawing Instruction Immediately at Lot Creation QKZPZDRCHAR1QKZ
KZPADRPrint Inspection Instruction Immediately at Lot Creation QKZPADRCHAR1QKZ
KZMESSAGEMessages Should Be Displayed When Printing QKZMESSAGECHAR1QKZ
STSMAStatus Profile J_STSMACHAR8TJ20J_STSMA
ERFSICHTRecording View QERFSICHTCHAR2QERFSICHTQER
STEUSControl key STEUSCHAR4T430STEUS
QMARTNotification Type QMARTCHAR2TQ80QMARTQMR
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
PRARTPhysical-Sample Type QPRARTCHAR2TQ40QPRART
EINEMELDOne Quality Notification per Inspection Lot QEINEMELDCHAR1QKZ
AUARTOrder Type for QM Orders As Default Value for Insp. Type QAUARTTQ30CHAR4T003OAUFART

Key field Non-key field



How do I retrieve data from SAP table TQ30 using ABAP code

The following ABAP code Example will allow you to do a basic selection on TQ30 to SELECT all data from the table
DATA: WA_TQ30 TYPE TQ30.

SELECT SINGLE *
FROM TQ30
INTO CORRESPONDING FIELDS OF WA_TQ30
WHERE...

How to access SAP table TQ30

Within an ECC or HANA version of SAP you can also view further information about TQ30 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!