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.
QMTB table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||
|
||||||||||||||||||
|
LSPER
Data Record Is Used
|
QVERW |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | PRFQL |
TQ11
Inspector qualification
|
PRFQL |
| QMTB | PRFQL | QMTB | MANDT |
TQ11
Inspector qualification
|
MANDT |
| 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 |