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
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
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
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