AFVV
transaction S/4HANA status: ActiveQuantities/Dates/Values in the Operation
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).
- Linked type codes
CLNT — the client key; filter it explicitly and carry it through every join.
NUMC — fixed-width numeric text; keep it a string and keep the leading zeros.
DATS, TIMS — character date (YYYYMMDD) and time (HHMMSS), zero-filled when initial.
CURR, CUKY, QUAN, UNIT — amounts and quantities, meaningful only beside the currency key or unit that qualifies them.
LANG — a language key in a text table — one row per language.
Fields
11 fields · 3 key
The join key is all 3 key fields together — matching on any single one fans out. See composite keys in the quirks guide.
11 fields.
| Key | Field | Description | Type | Length | References |
|---|---|---|---|---|---|
| Primary key | MANDT | Client | CLNT | 3 | |
| Primary key | AUFPL | Routing Number of Operations in the Order | NUMC | 10 | AFVC |
| Primary key | APLZL | General Counter for Order | NUMC | 8 | |
| MGVRG | Operation Quantity | QUAN | 13,3 | ||
| MEINH | Unit of Measure for Activity | UNIT | 3 | T006 | |
| LMNGA | Total Yield Confirmed | QUAN | 13,3 | ||
| XMNGA | Total Scrap Quantity Confirmed | QUAN | 13,3 | ||
| FSAVD | Earliest Scheduled Start: Execution (Date) | DATS | 8 | ||
| FSEDD | Earliest Scheduled Finish: Execution (Date) | DATS | 8 | ||
| ISDD | Actual Start: Execution (Date) | DATS | 8 | ||
| IEDD | Actual Finish: Execution (Date) | DATS | 8 |
Linked type codes in the Type column jump to the matching section of the SAP data quirks guide.
Field provenance: hand-curated.
Boilerplate SQL
Starting point for reading AFVV on Databricks. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.
3 parameters not filled: <catalog>, <schema>, <MANDT>
-- ============================================================
-- Table : AFVV Quantities/Dates/Values in the Operation
-- Purpose: Column-selected read of AFVV — auto-generated from field metadata
-- Grain : One row per AUFPL + APLZL
-- Notes : Auto-generated skeleton. For multi-table transaction query patterns, see the linked t-codes on this page. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
a.MANDT AS "Client",
a.AUFPL AS "Routing Number of Operations in the Order",
a.APLZL AS "General Counter for Order",
a.MGVRG AS "Operation Quantity",
a.MEINH AS "Unit of Measure for Activity",
a.LMNGA AS "Total Yield Confirmed",
a.XMNGA AS "Total Scrap Quantity Confirmed",
a.FSAVD AS "Earliest Scheduled Start: Execution (Date)",
a.FSEDD AS "Earliest Scheduled Finish: Execution (Date)",
a.ISDD AS "Actual Start: Execution (Date)",
a.IEDD AS "Actual Finish: Execution (Date)"
FROM <catalog>.<schema>.afvv a
WHERE
a.MANDT = '<MANDT>'
ORDER BY a.AUFPL;Verified August 2026
Relationships
Diagram of 1-hop neighbors — join details below.
Transaction Codes That Use This Table
No t-code mappings populated for this table yet.