SAP table QMTB (Inspection method master record)
SAP table QMTB has 4 primary key fields being MANDT,WERKS,PMTNR,VERSION.
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
Client
CLNT
3
0
T000
MANDT
Plant for Inspection Method
CHAR
4
0
T001W
Q_METH_PLANT
Inspection Method
CHAR
8
0
QPMETHODE
Version Number of Inspection Method
CHAR
6
0
QVERSNRPM
GUELTIGAB
Valid-From Date
DATS
8
0
DATUV
SORTFELD
Search Field
CHAR
40
0
QSORTFELD
AUTOR
Name of User Who Created the Data Record
CHAR
12
0
QERSTELLER
DATES
System Date on Which Data Record Was Created
DATS
8
0
QDATUMERST
AEAUT
Name of User Who Last Changed Data Record
CHAR
12
0
QAENDERER
DATAE
System Date on Which Data Record Was Changed
DATS
8
0
QDATUMAEND
LOEKZ
Status of Master Record
CHAR
1
0
QLOESCHKZ
Possible values
1
Being Created
2
Released
3
Can No Longer Be Used
4
Deletion Flag
5
Archived
LSPER
Data Record Is Used
CHAR
1
0
QVERW
PRFQL
Inspector Qualification
CHAR
5
0
TQ11
QPRQUALIF
DUMMY10
Text Line for Additional Information
CHAR
10
0
QTXT10
DUMMY20
Text Line for Additional Information
CHAR
20
0
QTXT20
DUMMY40
Text Line for Additional Information
CHAR
40
0
QTXT40
QAUTH
Authorization Group QM Master Data
CHAR
8
0
TQ01D
QMASTAUTH
CHANGEDDATETIME
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
DEC
15
0
TZNTSTMPS
DUMMY_QMTB_INCL_EEW_PS
Dummy function in length 1
CHAR
1
0
DUMMY
QMTB foreign key relationships
Table
Field
Check Table
Check Field
0 QMTB
PRFQL
TQ11 Inspector qualification
MANDT
1 QMTB
QAUTH
TQ01D Authorization groups for QM master data
MANDT
0 QMTB
WERKS
T001W Plants/Branches
MANDT
0 QMTB
WERKS
T001W Plants/Branches
WERKS