QAMV table — Inspection Lot Single Results Table
QAMV stores individual measured values recorded during results recording for a quantitative inspection characteristic, one row per single reading. It sits below the characteristic-level result record: when a characteristic is inspected with a sample size greater than one, each unit's reading lands here, while the summarized valuation (mean, pass or fail) is held one level up on the characteristic result table.
Covers what QAMV holds in the QM results recording data model, the join path from inspection lot down to individual readings, and the practical pitfalls of treating this table as a complete record of every characteristic inspected. Focuses on when rows exist, when they do not, and how to reconcile single values against the characteristic valuation without assuming a one-to-one relationship for every inspection.
Reviewed by an ERPClimb SAP consultant on 15 Sept 2026· 978 words
What it stores
One row represents a single recorded measured value captured during results recording for one inspection characteristic within one inspection lot. It exists for characteristics that require multiple individual readings rather than a single summarized entry, for example a sample of five units where each unit's measurement must be retained separately to support mean, range or standard deviation calculations, or to support traceability back to an individual reading. The table sits below the characteristic-result record in the data model: the inspection lot record identifies the inspection as a whole, the characteristic result record identifies which characteristic was inspected and its overall valuation, and this table holds the raw individual values that fed into that valuation. Not every characteristic generates rows here. Qualitative characteristics and quantitative characteristics recorded as a single summarized value never populate this table.
Key fields
- MANDT - client
- PRUEFLOS - inspection lot number, links every single value back to the inspection lot it was recorded against
- MERKNR - inspection characteristic number within the lot, identifies which characteristic the single value belongs to
- LFDNR - sequential number distinguishing each individual reading recorded for the same characteristic, used to reconstruct the order in which values were entered
How it joins the data model
- QAMV-PRUEFLOS = QALS-PRUEFLOS to reach the inspection lot header, status and material/plant context
- QAMV-PRUEFLOS = QAMR-PRUEFLOS and QAMV-MERKNR = QAMR-MERKNR to reach the characteristic-level result and its final valuation
- QAMV-PRUEFLOS = QASE-PRUEFLOS where sample-level characteristic data needs to be cross-checked against individual readings
- MERKNR resolves conceptually to the master inspection characteristic definition, reached indirectly through the characteristic result record rather than a direct field-to-field join
How to read it safely
Always restrict on MANDT and PRUEFLOS before doing anything else; this table grows with every sample-based reading across every lot in the plant and an unrestricted join to it in a high-volume production environment will run long. Restrict by MERKNR as soon as it is known, since a single lot can carry dozens of characteristics. Do not assume row count per characteristic equals the configured sample size without checking, since partial results recording, rework, or re-recording can leave a count that does not match. Use LFDNR to order the readings but do not treat it as a physical sample or unit identifier unless sample management is separately in use.
How to prove it in the data
Symptom: a characteristic on an inspection lot shows a valuation in results recording but a quality engineer or auditor wants to see the individual readings that produced it. Select QAMV on the exact PRUEFLOS and MERKNR, order by LFDNR, and count the rows against the sample size expected for that characteristic. Cross-check the mean of the values against the valuation stored on the corresponding QAMR record; a mismatch usually points to a re-recording that was not fully reset rather than a calculation error.
ECC vs S/4HANA
The table carries forward into S/4HANA with the same structure and role in the results recording data model; the QM results recording area has not been restructured the way some logistics tables have. No dedicated CDS compatibility view specific to this table is commonly referenced in QM reporting content, so custom reporting built on it in ECC generally continues to work unchanged in S/4HANA, subject to the usual regression testing.
Common pitfalls
- Assuming every characteristic on a lot has rows here - only quantitative characteristics recorded with multiple single values do; qualitative and single-value quantitative characteristics never appear
- Treating LFDNR as a physical unit or serial identifier - it only records entry sequence, not which physical item produced the reading unless sample management is explicitly configured for that
- Pulling values for statistical process control without checking whether the lot was reworked or results were re-recorded - stale rows from an earlier recording pass can remain and inflate a sample if the recording was not properly reset before re-entry
- Joining to QAMR or QALS without restricting on PRUEFLOS first - this table is one of the larger ones in the QM results recording chain and an unfiltered join across plants is a common performance mistake
- Reading an absence of rows as evidence the characteristic was never inspected - it may simply have been recorded as a single value rather than multiple values, or results recording is still in progress
- Expecting an independently calculated mean or range from the single values to match the valuation on QAMR exactly - rounding and decimal place settings configured at the characteristic level can produce small discrepancies that are not data errors
Whose problem this is
This is a QM consultant and plant quality engineer question, not a materials management or production planning one. Disputes over what a recorded reading actually was are resolved by pulling this table alongside the characteristic result and the inspection lot header, then walking the quality engineer through the sequence of readings rather than relying on the summarized valuation alone.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-tables/qamvERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.