QE01

Starting point for querying the tables behind this transaction. Adjust the WHERE clause for your scenario.

-- ============================================================
-- T-Code : QE01 Record Results for Inspection Lot
-- Purpose: Record Results for Inspection Lot — auto-generated boilerplate from tcode-table-map
-- Grain  : One row per QAMR joined to QAMV
-- Tables : QAMR, QAMV
-- Notes  : Auto-generated skeleton. Add MAKT/T001W/LFA1/KNA1 enrichment joins as needed for the business question. Replace placeholders (<...>) and MANDT with your tenant values.
-- ============================================================
SELECT
  l.MANDT    AS "Client",
  l.PRUEFLOS AS "Inspection Lot Number",
  l.VORNR    AS "Operation Number",
  l.MERKNR   AS "Inspection Characteristic Number"
FROM qamr l
LEFT JOIN qamv q
  ON q.MANDT = l.MANDT
 AND q.PRUEFLOS = l.PRUEFLOS
 AND q.VORNR = l.VORNR
 AND q.MERKNR = l.MERKNR
WHERE
  l.MANDT = '100'
  AND l.PRUEFLOS = <PRUEFLOS>
  AND l.VORNR = '<VORNR>'
  AND l.MERKNR = <MERKNR>
ORDER BY l.PRUEFLOS;