SAP Table QMTBV

Logical database QTQ (QMTB and QMTT)

QMTBV (Logical database QTQ (QMTB and QMTT)) 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 QMTBV to other SAP tables.

QMTBV 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
SPRACHE Language Key SPRAS LANG 1 0
KURZTEXT Short Text for The Inspection Method QKTEXTMETH CHAR 40 0
LTEXTKZ Long Text Exists for the Inspection Method QLTEXTMT CHAR 1 0
NULL Indicator is not set
X Indicator is set
GELOESCHT Data Record Was Deleted QGELOESCHT CHAR 1 0
NULL Indicator is not set
X Indicator is set

QMTBV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QMTBV MANDT QMTBV MANDT T000 Clients MANDT
QMTBV PRFQL QMTBV PRFQL TQ11 Inspector qualification PRFQL
QMTBV PRFQL QMTBV MANDT TQ11 Inspector qualification MANDT
QMTBV QAUTH SY MANDT TQ01D Authorization groups for QM master data MANDT
QMTBV QAUTH QMTBV QAUTH TQ01D Authorization groups for QM master data QMASTAUTH
QMTBV WERKS QMTBV MANDT T001W Plants/Branches MANDT
QMTBV WERKS QMTBV WERKS T001W Plants/Branches WERKS