QA11

-- ============================================================
-- 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. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  h.MANDANT  AS "Client",
  h.PRUEFLOS AS "Inspection Lot Number"
FROM <catalog>.<schema>.qave h
LEFT JOIN <catalog>.<schema>.qals q
  ON q.MANDANT = h.MANDANT
 AND q.PRUEFLOS = h.PRUEFLOS
WHERE
  h.MANDANT = '<MANDT>'
  AND h.PRUEFLOS = <PRUEFLOS>
ORDER BY h.PRUEFLOS;