QA11

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

-- ============================================================
-- T-Code : QA11 Record Usage Decision
-- Purpose: Record Usage Decision — auto-generated boilerplate from tcode-table-map
-- Grain  : One row per QAVE joined to QALS
-- Tables : QAVE, QALS
-- 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
  h.MANDT    AS "Client",
  h.PRUEFLOS AS "Inspection Lot Number"
FROM qave h
LEFT JOIN qals q
  ON q.MANDT = h.MANDT
 AND q.PRUEFLOS = h.PRUEFLOS
WHERE
  h.MANDT = '100'
  AND h.PRUEFLOS = <PRUEFLOS>
ORDER BY h.PRUEFLOS;