SAP Reference
QE01
Create S/4HANA status: ActiveRecord Inspection Results by Characteristic
What the badges mean
- S/4HANA status: Active
- Active and unchanged in S/4HANA.
- S/4HANA status: Deprecated
- Still readable today, but no longer SAP's strategic path — plan around it.
- S/4HANA status: Replaced
- Replaced by a new persistence in S/4HANA; the classic name may still answer reads (see read mechanism).
- S/4HANA status: Migrating to IBP
- Planning scope is moving from APO toward IBP.
- S/4HANA status: Active (StRM) · Replaced (EWM)
- Path-dependent: active with SAP Stock Room Management, replaced where EWM is the warehouse path.
- S/4HANA status: Replaced · Compat View
- Compatibility view: the classic table name is redirected to a view over the new persistence — see how the physical model moved.
- S/4HANA status: Active · Proxy View
- Proxy view: reads route through NSDM proxy/CDS views — see how the physical model moved.
- master
- Data class: what the table holds — master data, transaction documents, org structure, config, or texts (one row per language — see the quirks guide).
In field listings, K marks a primary-key field, and linked type codes in the Type column jump to the matching quirks-guide section.
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
6 parameters not filled: <catalog>, <schema>, <MANDT>, <PRUEFLOS>, <VORGLFNR>, <MERKNR>
-- ============================================================
-- T-Code : QE01 Record Inspection Results by Characteristic
-- Purpose: Record Inspection Results by Characteristic — 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;Tables Used by This Transaction
R read · W write · R/W read + write