Skip to content
SAP Reference

QE01

Create S/4HANA status: Active

Record 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 SQL

Starting 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

More Quality Management t-codes