SAP Reference
QA11
Create S/4HANA status: ActiveRecord Usage Decision
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>, <KZART>, <ZAEHLER>
-- ============================================================
-- 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",
h.KZART AS "Record Type of Usage Decision",
h.ZAEHLER AS "Counter for Usage Decision"
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>
AND h.KZART = '<KZART>'
AND h.ZAEHLER = '<ZAEHLER>'
ORDER BY h.PRUEFLOS;Tables Used by This Transaction
How these tables connect — join details in the list below.
R read · W write · R/W read + write