AFVC table — Order Operation Table AFVC
AFVC stores one row per operation (or sub-operation) of a production or process order's routing: the operation number, control key, work center, and descriptive text. It does not hold planned or actual quantities and times, those sit in AFVV and AFRU respectively, joined back to AFVC through the internal keys AUFPL and APLZL.
AFVC is the operation-level table behind every production and process order routing, sitting between the order header in AFKO and the quantity/confirmation data in AFVV, AFVU and AFRU. This page covers the key fields, the joins consultants actually write, and the recurring mistake of confusing the internal routing keys with the visible operation number.
Published 16 Sept 2026· 987 words
What it stores
One row in AFVC represents a single operation, or a sub-operation under a parent operation, belonging to the routing that was copied into a specific production or process order at order creation. It carries the control key that governs whether the operation is relevant for scheduling, costing, confirmation or capacity planning, the work center it is assigned to, and a short descriptive text. AFVC is order-specific: it is the result of the standard routing (held in PLPO) being copied and possibly modified for that one order, so two orders built from the same routing group will have two independent sets of AFVC rows, not shared ones. Planned times, quantities and cost-relevant values for the operation are not stored here; they live in the companion table AFVV, keyed the same way.
Key fields
- MANDT - client
- AUFPL - internal routing number generated for the order, the linking key to the order header and to AFVV/AFVU/AFRU
- APLZL - operation/activity counter within that routing, second half of the composite key
- VORNR - operation number as shown on screen, e.g. 0010, 0020, not usable alone as a join key
- STEUS - control key, drives confirmation, costing and scheduling relevance for the operation
- ARBID - internal ID of the work center performing the operation, links to CRHD
- WERKS - plant of the operation
- LTXA1 - short text describing the operation
How it joins the data model
- AFVC-AUFPL = AFKO-AUFPL (operation rows belong to this order header)
- AFVC-AUFPL = AFVV-AUFPL and AFVC-APLZL = AFVV-APLZL (planned quantities, times and cost data for the operation)
- AFVC-AUFPL = AFVU-AUFPL and AFVC-APLZL = AFVU-APLZL (user fields for the operation)
- AFVC-AUFPL = AFRU-AUFPL and AFVC-APLZL = AFRU-APLZL (confirmations posted against the operation)
- AFVC-AUFPL = RESB-AUFPL and AFVC-APLZL = RESB-APLZL (components reserved to that specific operation)
- AFVC-ARBID = CRHD-OBJID (work center master record performing the operation)
How to read it safely
Always restrict by MANDT and, if reading directly, by plant (WERKS) or order number range through AFKO first, since AFVC has no order number field of its own and is only reachable via AUFPL. Never select on VORNR alone across orders, it repeats endlessly (every order tends to have a 0010, 0020...) and carries no uniqueness across the table. The practical entry point is almost always AFKO for the order, then AFVC filtered on the resulting AUFPL, then AFVV or AFRU joined on AUFPL and APLZL. Check the deletion indicator before trusting a row; cancelled or replaced operations are not always physically removed.
How to prove it in the data
To confirm which control key governs confirmation behaviour for a stuck order, pull AFKO for the order number to get AUFPL, then read AFVC for that AUFPL and inspect STEUS and the deletion flag on the operation in question. If STEUS points to a control key that suppresses confirmation or backflushing, that explains why the operation never shows up in AFRU regardless of what the shop floor reports.
ECC vs S/4HANA
AFVC continues to exist as a transparent table in S/4HANA and is still the primary store for order operation data; there is no widely known compatibility view replacing it at the operation level in the way some financial or material tables were replaced. The routing and order data model around it (AFKO, AFVV, AFVU, AFRU) is unchanged in structure, so existing joins and reports built against AFVC on ECC generally continue to work on S/4HANA without redesign.
Common pitfalls
- Treating VORNR as a unique key: it is only unique within one order's routing, not across the table, so filtering on VORNR without AUFPL returns rows from unrelated orders
- Expecting quantities or standard times in AFVC: they are not there, they are in AFVV, and reading AFVC alone gives no indication of how much work is planned or actually confirmed
- Assuming an operation is active because it exists in AFVC: it may carry a deletion flag or have been logically replaced during order change, and still physically remain in the table
- Confusing order-level AFVC with the routing master (PLPO): editing the routing master after the order was created does not retroactively change AFVC, the order already has its own frozen copy
- Assuming control key behaviour is fixed: STEUS is copied per operation and can be overridden manually on the order, so two orders from the same routing can behave differently for costing or confirmation
- Joining directly on ARBID to identify a work center by name: ARBID is an internal number, the readable work center code lives on CRHD, not on AFVC
- Ignoring sub-operations: an operation and its sub-operations share the same VORNR pattern conventions loosely but are distinct AFVC rows, double-counting or missing them skews time and cost analysis
Whose problem this is
Production planning consultants own the interpretation of control keys, work center assignment and operation sequencing questions raised against AFVC. Routing and master data teams own why a given operation was copied into the order the way it was; a wrong answer here is rarely a Basis or data-quality problem, it is a routing or order-type configuration problem.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-tables/afvcERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.