SAP table QMTBV (Logical database QTQ (QMTB and QMTT))

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
WERKS Plant for Inspection Method CHAR 4 0 T001W Q_METH_PLANT
PMTNR Inspection Method CHAR 8 0 * QPMETHODE
VERSION 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
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
SPRACHE Language Key LANG 1 0 SPRAS
KURZTEXT Short Text for The Inspection Method CHAR 40 0 QKTEXTMETH
LTEXTKZ Long Text Exists for the Inspection Method CHAR 1 0 QLTEXTMT
GELOESCHT Data Record Was Deleted CHAR 1 0 QGELOESCHT

QMTBV foreign key relationships

Table Field Check Table Check Field
0 QMTBV PRFQL TQ11 Inspector qualification MANDT
1 QMTBV QAUTH TQ01D Authorization groups for QM master data MANDT
0 QMTBV WERKS T001W Plants/Branches MANDT
0 QMTBV WERKS T001W Plants/Branches WERKS