- Home
- Resources
- SAP Tables
- QMTB - Inspection method master record
SAP Table QMTB
Inspection method master record
QMTB (Inspection method master record) 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 QMTB to other SAP tables.
Source: QMTB (Inspection method master record)
QMTB table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| WERKS |
Plant for Inspection Method |
Q_METH_PLANT |
T001W
|
CHAR |
|
4 |
0 |
|
| PMTNR |
Inspection Method |
QPMETHODE |
|
CHAR |
|
8 |
0 |
|
| VERSION |
Version Number of the Inspection Method |
QVERSNRPM |
|
CHAR |
|
6 |
0 |
|
| GUELTIGAB |
Valid-From Date |
DATUV |
|
DATS |
|
8 |
0 |
|
| SORTFELD |
Search Field |
QSORTFELD |
|
CHAR |
|
40 |
0 |
|
| AUTOR |
Name of User Who Created the Data Record |
QERSTELLER |
|
CHAR |
|
12 |
0 |
|
| DATES |
Date on Which the Data Record Was Created |
QDATUMERST |
|
DATS |
|
8 |
0 |
|
| AEAUT |
Name of User who Most Recently Changed the Data Record |
QAENDERER |
|
CHAR |
|
12 |
0 |
|
| DATAE |
Date on Which Data Record Was Changed |
QDATUMAEND |
|
DATS |
|
8 |
0 |
|
| LOEKZ |
Status of Master Record |
QLOESCHKZ |
|
CHAR |
|
1 |
0 |
Possible values
| 1 |
Being created |
| 2 |
Released |
| 3 |
Can no longer be used |
| 4 |
Deletion flag |
| 5 |
Archived |
|
| LSPER |
Data Record Is Used |
QVERW |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Indicator is not set |
| X |
Indicator is set |
|
| PRFQL |
Inspector Qualification |
QPRQUALIF |
TQ11
|
CHAR |
|
5 |
0 |
|
| DUMMY10 |
Text Line for Additional Information |
QTXT10 |
|
CHAR |
|
10 |
0 |
|
| DUMMY20 |
Text Line for Additional Information |
QTXT20 |
|
CHAR |
|
20 |
0 |
|
| DUMMY40 |
Text Line for Additional Information |
QTXT40 |
|
CHAR |
|
40 |
0 |
|
| QAUTH |
Authorization Group QM Basic Data |
QMASTAUTH |
TQ01D
|
CHAR |
|
8 |
0 |
|
QMTB foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| QMTB |
MANDT |
QMTB |
MANDT |
T000 |
Clients |
MANDT |
| QMTB |
PRFQL |
QMTB |
MANDT |
TQ11 |
Inspector qualification |
MANDT |
| QMTB |
PRFQL |
QMTB |
PRFQL |
TQ11 |
Inspector qualification |
PRFQL |
| QMTB |
QAUTH |
SY |
MANDT |
TQ01D |
Authorization groups for QM master data |
MANDT |
| QMTB |
QAUTH |
QMTB |
QAUTH |
TQ01D |
Authorization groups for QM master data |
QMASTAUTH |
| QMTB |
WERKS |
QMTB |
MANDT |
T001W |
Plants/Branches |
MANDT |
| QMTB |
WERKS |
QMTB |
WERKS |
T001W |
Plants/Branches |
WERKS |
