SAP ABAP Table QMTB (Inspection method master record)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QA (Package) QM master data

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QMTB	Table Relationship Diagram
Short Description	Inspection method master record

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	WERKS	☑	Q_METH_PLANT	WERKS	CHAR	4	0	Plant for Inspection Method	T001W
3	PMTNR	☑	QPMETHODE	QPMETHODE	CHAR	8	0	Inspection Method
4	VERSION	☑	QVERSNRPM	QVERSNR	CHAR	6	0	Version Number of the Inspection Method
5	GUELTIGAB	☐	DATUV	DATUM	DATS	8	0	Valid-From Date
6	SORTFELD	☐	QSORTFELD	CHAR40	CHAR	40	0	Search Field
7	AUTOR	☐	QERSTELLER	QAENDERER	CHAR	12	0	Name of User Who Created the Data Record
8	DATES	☐	QDATUMERST	DATUM	DATS	8	0	Date on Which the Data Record Was Created
9	AEAUT	☐	QAENDERER	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Data Record
10	DATAE	☐	QDATUMAEND	DATUM	DATS	8	0	Date on Which Data Record Was Changed
11	LOEKZ	☐	QLOESCHKZ	QLOESCHKZ	CHAR	1	0	Status of Master Record
12	LSPER	☐	QVERW	QKZ	CHAR	1	0	Data Record is Being Used
13	PRFQL	☐	QPRQUALIF	QPRQUALIF	CHAR	5	0	Inspector Qualification	TQ11
14	DUMMY10	☐	QTXT10	QTXT10	CHAR	10	0	Text Line for Additional Information
15	DUMMY20	☐	QTXT20	QTXT20	CHAR	20	0	Text Line for Additional Information
16	DUMMY40	☐	QTXT40	QTXT40	CHAR	40	0	Text Line for Additional Information
17	QAUTH	☐	QMASTAUTH	QMASTAUTH	CHAR	8	0	Authorization Group QM Basic Data	TQ01D

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QMTB	MANDT	T000	MANDT	KEY	1	CN
2	QMTB	PRFQL	TQ11	PRFQL	REF	C	CN
3	QMTB	QAUTH	TQ01D	QMASTAUTH
4	QMTB	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in