SAP QM Table Relationships

An interactive reference showing how SAP Quality Management tables connect across inspection lots, notifications, inspection plans and master data in both SAP ECC and SAP S/4HANA.

The SAP Quality Management (QM) module stores inspection, notification and quality certificate data across related tables linked to materials, batches, production orders and goods movements. Understanding how these tables join together is essential for building quality KPI dashboards, defect trend analyses, first-pass-yield reporting and supplier quality scorecards.

Use the diagram below to explore table relationships visually, or scroll to the quick-reference guide for a complete list of tables, join keys and system compatibility. QM tables are broadly consistent between ECC and S/4HANA - the most common cross-module dependencies are with MM material documents (MATDOC in S/4HANA), batch tables and inspection task lists shared with PP.

Read the Full Blog Post

Interactive Data Model

Hover over any table to see its description, key fields and system compatibility. Dashed red borders indicate S/4HANA-specific tables.

QM Transaction

Master Data

S/4HANA

Configuration

Quick-Reference Guide

All SAP QM tables shown above with their primary join keys and SAP system compatibility.

Table	Description	Primary Join Keys	System
Inspection Lot - Transactional
QALS	Inspection Lot Master	PRUEFLOS	ECC + S/4HANA
QAMR	Characteristic Single Results	PRUEFLOS, VORNLFNR, MERKNUM, WERTNR	ECC + S/4HANA
QAMV	Inspection Characteristic Specification	PRUEFLOS, VORNLFNR, MERKNUM	ECC + S/4HANA
QAMB	Link between QM lots and Material Documents	PRUEFLOS, MBLNR, MJAHR, ZEILE	ECC + S/4HANA
QASR	Characteristic Sample Results	PRUEFLOS, VORNLFNR, MERKNUM, PROBENR	ECC + S/4HANA
QASE	Sample	PRUEFLOS, PROBENR	ECC + S/4HANA
Notifications
QMEL	Quality Notification Header	QMNUM	ECC + S/4HANA
QMIH	Quality Notification Item (maintenance data)	QMNUM	ECC + S/4HANA
QMFE	Notification Defect	QMNUM, FENUM	ECC + S/4HANA
QMMA	Notification Activity	QMNUM, MANUM	ECC + S/4HANA
QMSM	Notification Task	QMNUM, MNCOD	ECC + S/4HANA
Inspection Planning
MAPL	Assignment of Task Lists to Material	MATNR, PLNTY, PLNNR, PLNAL	ECC + S/4HANA
PLKO	Task List Header	PLNTY, PLNNR, PLNAL	ECC + S/4HANA
PLPO	Task List Operation	PLNTY, PLNNR, PLNKN	ECC + S/4HANA
PLMK	Inspection Characteristic Assignment (in plan)	PLNTY, PLNNR, PLNKN	ECC + S/4HANA
Inspection Catalog
QPMK	Master Inspection Characteristic	WERKS, MKMNR, VERSION	ECC + S/4HANA
QPMT	Inspection Method	WERKS, VERFAHREN, VERSION	ECC + S/4HANA
QPCT	Catalog Codes	KATALOGART, CODEGRUPPE, CODE	ECC + S/4HANA
Material / Batch Master
MARA	Material Master (General)	MATNR	ECC + S/4HANA
MARC	Material (Plant, includes QM view)	MATNR, WERKS	ECC + S/4HANA
MCH1	Batches (cross-plant)	MATNR, CHARG	ECC + S/4HANA
MCHA	Batches (per plant)	MATNR, WERKS, CHARG	ECC + S/4HANA
S/4HANA
MATDOC	Universal Material Document (replaces MKPF + MSEG; QAMB links QM lots to MATDOC in S/4HANA)	MBLNR, MJAHR, ZEILE	S/4HANA
Configuration
T001W	Plants	WERKS	ECC + S/4HANA
TQ30	Inspection Type / Control key	ART	ECC + S/4HANA
TQ77	Usage Decision Codes	VERWKAT, VERWCODE	ECC + S/4HANA

Related Resources

Explore more SAP content from DVW Analytics.

SAP QM Tables Blog Post

Detailed descriptions of every table shown in this diagram, with practical tips for building quality analytics workflows.

DVW Help Centre

Guides and documentation for the DVW Connector for SAP, DVW Flow Tool and other DVW products. Available to free trial and paid users.

Try it free for 30 days

Free 30-day trial. Full functionality. No commitment.

Start Your Free Trial

Watch demos View pricing Talk to our team