SAP Reference
QE01
CreateS/4HANA status: ActiveRecord Results for Inspection Lot
Boilerplate SQL
Databricks SQLStarting point for querying the tables behind this transaction. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.
Query parameters
-- ============================================================
-- 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. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
l.MANDANT AS "Client",
l.PRUEFLOS AS "Inspection Lot Number",
l.VORGLFNR AS "Current Node Number from Order Counter APLZL",
l.MERKNR AS "Inspection Characteristic Number"
FROM <catalog>.<schema>.qamr l
LEFT JOIN <catalog>.<schema>.qamv q
ON q.MANDANT = l.MANDANT
AND q.PRUEFLOS = l.PRUEFLOS
AND q.VORGLFNR = l.VORGLFNR
AND q.MERKNR = l.MERKNR
WHERE
l.MANDANT = '<MANDT>'
AND l.PRUEFLOS = <PRUEFLOS>
AND l.VORGLFNR = <VORGLFNR>
AND l.MERKNR = <MERKNR>
ORDER BY l.PRUEFLOS;