# SAP QM Database Tables Reference (QALS, QAVE, QMEL and More) > Source: https://netray.co/tools/sap-qm-database-tables-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Searchable lookup of the core SAP Quality Management tables, what each one stores and its main key fields, for report writers and data migration teams. ## Category sap ## Erp SAP S/4HANA ## Industry Discrete Manufacturing ## Audience - SAP QM consultant - ABAP developer - Quality engineer ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### What it stores **Key:** stores **Type:** text #### Main fields **Key:** keys **Type:** text #### QM area **Key:** area **Type:** text **Rows:** **Table:** QALS **Stores:** Inspection lot record (header data of the lot) **Keys:** PRUEFLOS, WERK, MATNR, ART, HERKUNFT, LOSMENGE **Area:** Inspection lot **Table:** QAVE **Stores:** Inspection processing: usage decision data **Keys:** PRUEFLOS, VCODE, VCODEGRP, VDATUM **Area:** Usage decision **Table:** QAMV **Stores:** Characteristic specifications of the inspection lot **Keys:** PRUEFLOS, VORNR, MERKNR, VERWMERKM **Area:** Results **Table:** QAMR **Stores:** Characteristic results during inspection processing **Keys:** PRUEFLOS, VORNR, MERKNR **Area:** Results **Table:** QAPP **Stores:** Inspection points of the lot **Keys:** PRUEFLOS, VORNR **Area:** Inspection lot **Table:** QMAT **Stores:** Inspection type setup per material and plant **Keys:** ART, MATNR, WERKS **Area:** Master data **Table:** QINF **Stores:** QM info record for procurement (material, vendor, plant) **Keys:** MATNR, LIEFERANT, WERK **Area:** QM in procurement **Table:** MARC **Stores:** Plant data for material, including QM fields QMATV, SSQSS and QMATA **Keys:** MATNR, WERKS **Area:** Master data **Table:** QMEL **Stores:** Quality notification header **Keys:** QMNUM, QMART, MATNR, MAWERK, QMDAT **Area:** Notification **Table:** QMFE **Stores:** Quality notification items (defects) **Keys:** QMNUM, FENUM, FEGRP, FECOD **Area:** Notification **Table:** QMUR **Stores:** Quality notification causes **Keys:** QMNUM, FENUM, URNUM **Area:** Notification **Table:** QMSM **Stores:** Quality notification tasks **Keys:** QMNUM, MANUM **Area:** Notification **Table:** QMMA **Stores:** Quality notification activities **Keys:** QMNUM, MANUM **Area:** Notification **Table:** QPMK **Stores:** Master inspection characteristics (general data) **Keys:** MKMNR, ZAEHLER **Area:** Master data **Table:** QPMT **Stores:** Master inspection characteristic texts **Keys:** MKMNR, SPRACHE **Area:** Master data **Table:** QPGR **Stores:** Code groups of the QM catalogs **Keys:** KATALOGART, CODEGRUPPE **Area:** Catalogs **Table:** QPGT **Stores:** Code group texts **Keys:** KATALOGART, CODEGRUPPE, SPRACHE **Area:** Catalogs **Table:** QPCD **Stores:** Codes within code groups **Keys:** KATALOGART, CODEGRUPPE, CODE **Area:** Catalogs **Table:** QPCT **Stores:** Code texts **Keys:** KATALOGART, CODEGRUPPE, CODE, SPRACHE **Area:** Catalogs **Table:** MAPL **Stores:** Assignment of task lists to materials **Keys:** PLNTY, PLNNR, PLNAL, MATNR, WERKS **Area:** Inspection plan **Table:** PLKO **Stores:** Task list header (inspection plan header) **Keys:** PLNTY, PLNNR, PLNAL **Area:** Inspection plan **Table:** PLPO **Stores:** Task list operations **Keys:** PLNTY, PLNNR, PLNKN **Area:** Inspection plan **Table:** PLMK **Stores:** Inspection characteristics of the task list **Keys:** PLNTY, PLNNR, PLNKN, MERKNR **Area:** Inspection plan **Table:** JEST **Stores:** Individual object status (links to QALS and QMEL through OBJNR) **Keys:** OBJNR, STAT, INACT **Area:** Status **Notes:** Field lists are the main fields only, not the full table definition. Confirm exact fields and keys for your release in SE11 or SE16N before you build a report or a migration object. Table names are the same in ECC and S/4HANA unless noted in your release notes. ## Content **Intro:** This reference lists the SAP QM tables you meet most often when writing reports, CDS views, extractors or data migration programs. Search by table name or by what the table stores and export the result to Excel for your design document. **Sections:** #### How to use the table list **Body:** Type part of a table name or a business word such as usage decision or notification in the search box. Each row shows what the table holds and the fields you normally join on. Export the filtered rows to Excel or PDF and attach them to a functional specification so developers and testers start from the same list. Always verify the field list in SE11 for your release, because custom append structures and newer releases add fields that this reference does not show. #### How the QM tables fit together **Body:** The inspection lot in QALS is the anchor. The lot number PRUEFLOS links to the characteristic specifications in QAMV, the results in QAMR, inspection points in QAPP and the usage decision in QAVE. Material setup comes from QMAT and MARC, and the inspection plan behind the lot comes from MAPL, PLKO, PLPO and PLMK. Notifications live in QMEL with items, causes, tasks and activities in separate tables joined by QMNUM. Status is not stored in the QM tables themselves but in JEST through the object number OBJNR. **Bullets:** - QALS to QAVE: one usage decision per lot, join on PRUEFLOS - QALS to QAMV and QAMR: join on PRUEFLOS and VORNR - QMEL to QMFE: join on QMNUM, add MANDT in native SQL - QALS and QMEL to JEST: join on OBJNR for status #### Worked example: lots with a rejected decision **Body:** A quality engineer wants all lots for plant 1000 that ended with a rejection code last month. The query starts at QALS filtered on WERK and the creation date, joins QAVE on PRUEFLOS and filters on the usage decision code group and code that your catalog uses for rejection. Because code groups are customer defined, the filter values come from your own QPGR and QPCD entries, not from a standard list. Joining JEST on OBJNR lets you exclude lots that carry a deletion flag. #### Common mistakes **Body:** Most defects in QM reports come from the same few habits. Avoid them and your numbers will match what users see in transactions such as QA32 and QM03. **Bullets:** - Reading results from QAMR without joining the specification in QAMV - Forgetting MANDT when using native SQL on HANA - Treating a status as a column instead of reading JEST - Hard coding code groups instead of reading them from QPGR and QPCD - Ignoring archived data, which is no longer in the active tables **Cta:** If you need these tables exposed as a governed, read-only data model that quality people can query in plain language, we can build that on top of your SAP system, on-premises if required. **Faq:** #### Which table stores the usage decision in SAP QM? **Answer:** The usage decision data is stored in table QAVE, keyed by the inspection lot number PRUEFLOS. It holds the code group, the code and the decision date. The lot header itself is in QALS, so most reports join QALS to QAVE on PRUEFLOS. #### Where are SAP QM inspection results stored? **Answer:** Characteristic results are stored in QAMR, with the matching specification in QAMV. Both are keyed by inspection lot, operation and characteristic number. Single value results are stored in a related table, so check SE11 for your release if you need individual readings. #### How do I find the status of a quality notification in tables? **Answer:** Statuses are not columns in QMEL. QMEL carries an object number OBJNR, and the active statuses for that object are rows in JEST. Join on OBJNR and read the STAT column, then translate the status codes using the status text tables. #### Are the QM table names different in S/4HANA? **Answer:** The core QM tables such as QALS, QAVE and QMEL keep their names in S/4HANA, and material master tables follow the simplifications of your release. Confirm field lengths such as the material number in SE11, because S/4HANA allows longer material numbers. ## Search terms SAP QM tables, QALS table, QAVE table SAP, QMEL table, SAP inspection lot table, SAP QM database tables list, QAMV QAMR tables, SAP quality notification tables --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json