SAP Data Models|Quality Management
SAP QM table relationships in one interactive diagram
How SAP Quality Management tables connect across inspection lots, notifications, inspection plans and master data, in both SAP ECC and SAP S/4HANA.
Trusted by 500+ enterprises. Read and write SAP data from any analytics or data platform.
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 PostInteractive Data Model
Hover over any table to see its description, key fields and system compatibility. Dashed red borders indicate S/4HANA-specific tables.
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, MANUM | 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 | ZAEHLER (plant), MKMNR, VERSION | ECC + S/4HANA |
| QMTB | Inspection Method Master | ZAEHLER (plant), PMTNR, 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.
Try it free for 30 days
Free 30-day trial. Full functionality. No commitment.
Start Your Free Trial