Released Production Orders Without Any Confirmation Report
Short answer: A custom ALV report that lists production orders that were released but have not received a confirmation for a single operation, with the days since release and the first work center. Orders with component issues or goods receipts but no confirmation are flagged separately, so orders forgotten on the shop floor, released by mistake or confirmed outside the system appear in one list.
- Estimated effort
- S · 2–4 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
COOIS allows status selection, but building 'REL active and no CNF/PCNF on any operation' in one selection, and separating valid confirmations from reversed ones, is hard. The list does not show the days since release, the work center of the first operation and whether components were issued to the order on the same line. Planners move between COOIS, CO03 and MB51. The custom report combines these conditions and sorts by waiting time.
Who uses it? Production planners, production supervisors, shift leads and cost accounting teams that clean up open orders at month end.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| AUFKOrder Master Data | Order type, plant and object number (driving table) | — | ECC + S/4 |
| JESTIndividual Object Status | Check of the REL, DLV, TECO and deletion status | JEST-OBJNR = AUFK-OBJNR AND JEST-INACT = ' ' | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Release date, scheduled dates, production supervisor | AFKO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFPOOrder Item | Material, order and goods receipt quantity | AFPO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFVCOperation within an Order | Operations and confirmation numbers | AFVC-AUFPL = AFKO-AUFPL | ECC + S/4 |
| AFRUOrder Confirmations | Check for a valid confirmation record | AFRU-RUECK = AFVC-RUECK AND AFRU-STOKZ = ' ' AND AFRU-STZHL = '00000000' | ECC + S/4 |
| RESBReservation/Dependent Requirements | Whether components were withdrawn | RESB-AUFNR = AUFK-AUFNR | ECC + S/4 |
| CRHDWork Center Header | Work center of the first operation | CRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBID | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = AFPO-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | AUFK-WERKS | Yes | 1000 |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No | PP01 |
| S_FEVOR | Production supervisor | Range / multiple | AFKO-FEVOR | No | 101 |
| S_DISPO | MRP controller | Range / multiple | AFKO-DISPO | No | 001 |
| S_FTRMI | Release date | Range / multiple | AFKO-FTRMI | No | 01.01.2026 – 10.11.2026 |
| P_DAYS | Minimum days since release | Single value | — | Yes | 5 |
| P_MOVE | Only orders with goods movements | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Order | AUFK-AUFNR |
| 2 | Order type | AUFK-AUART |
| 3 | Material | AFPO-MATNR |
| 4 | Material description | MAKT-MAKTX |
| 5 | Supervisor | AFKO-FEVOR |
| 6 | Released on | AFKO-FTRMI |
| 7 | Days since release | Calculated Today − AFKO-FTRMI |
| 8 | Scheduled start | AFKO-GSTRS |
| 9 | Scheduled finish | AFKO-GLTRS |
| 10 | Order quantity | AFPO-PSMNG |
| 11 | Goods receipt quantity | AFPO-WEMNG |
| 12 | First work center | CRHD-ARBPL |
| 13 | Operations | Calculated Number of AFVC lines under AFKO-AUFPL |
| 14 | Components issued | Calculated X when any RESB line has ENMNG > 0 |
| 15 | Finding | Calculated Waiting / Scheduled start passed / Movements, no confirmation |
Sample output
| Order | Order type | Material | Material description | Supervisor | Released on | Days since release | Scheduled start | Scheduled finish | Order quantity | Goods receipt quantity | First work center | Operations | Components issued | Finding |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000412 | PP01 | FG-5003 | Packed product C | 101 | 09/22/2026 | 56 | 09/24/2026 | 09/26/2026 | 1,200 | 0 | MONT-01 | 4 | X | Movements, no confirmation |
| 1000437 | PP01 | FG-6100 | Panel cabinet 80 cm | 102 | 10/15/2026 | 33 | 10/20/2026 | 10/23/2026 | 150 | 0 | KAYN-02 | 6 | Scheduled start passed | |
| 1000455 | PP02 | SA-3100 | Body subassembly | 101 | 11/03/2026 | 14 | 11/18/2026 | 11/19/2026 | 400 | 0 | PRES-01 | 3 | Waiting | |
| 1000461 | PP01 | FG-7200 | Compressor unit K2 | 103 | 11/05/2026 | 12 | 11/06/2026 | 11/12/2026 | 60 | 20 | TEST-01 | 5 | X | Movements, no confirmation |
How does the report work?
- Production orders (AUTYP = ‘10’) of the selected plants and order types are read from AUFK; through AUFK-OBJNR, orders with REL (I0002) active and TECO (I0045), DLV (I0012) and the deletion flag (I0076) not active are kept in JEST.
- AFKO gives the actual release date (FTRMI), scheduled start/finish, production supervisor and MRP controller; orders released fewer days ago than the threshold on the selection screen are skipped.
- Through AFKO-AUFPL the AFVC operations are read; for each operation’s confirmation number (RUECK) a non-reversed confirmation (STOKZ blank, STZHL = 0) is searched in AFRU. Orders without a valid confirmation on any operation enter the list.
- The withdrawn quantity on the order components (RESB-ENMNG > 0) and the goods receipt quantity (AFPO-WEMNG) are checked; orders with movements but no confirmation are flagged ‘Movements, no confirmation’.
- The work center of the first operation comes from CRHD-ARBPL, the material description from MAKT.
- The list is sorted by days since release, descending; the finding column shows ‘Waiting’, ‘Scheduled start passed’ or ‘Movements, no confirmation’.
Performance notes
Check AFRU with one FOR ALL ENTRIES read on the RUECK list of the orders; do not run a SELECT per order. Restrict the JEST read to STAT IN ( 'I0002', 'I0012', 'I0045', 'I0076' ). For several plants and hundreds of thousands of orders, run the report overnight in the background and distribute it by email.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The order number opens CO03; the components issued flag opens the MB51 movement list of the order.
- Export to Excel
- Runs as a background job
- Send the result by email In a background job the list can be split by production supervisor and sent to each person.
Authorization objects
- C_AFKO_AWKDisplay production orders by plant and order type
- C_AFRU_AWKDisplay of confirmation data
Frequently asked questions
How are reversed confirmations treated?
A reversed confirmation (STOKZ = X) and the record that reverses it (STZHL filled) are not counted as valid. If an operation was confirmed and then fully reversed, the order is still listed as 'without confirmation'.
Are orders with automatic confirmations listed too?
In scenarios with milestone confirmation, the confirmation may come automatically from another operation. Because the report looks for real records in AFRU, these confirmations are recognized; operations whose control key does not require confirmation can optionally be excluded from the count.
Does the report work on S/4HANA?
Yes. AUFK, AFKO, AFPO, AFVC, AFRU and JEST keep the same structure in S/4HANA. For a clean core approach it can also be built on released CDS views such as I_MfgOrderWithStatus and I_MfgOrderConfirmation.
Related reports
Automatic Technical Completion (TECO) of Production Orders Program
A custom background program that finds production orders that are fully delivered, have no open reservations or COGI records left and whose last goods …
Production Orders with Consumption but No Goods Receipt Report
A custom ALV report that lists production orders with posted component consumption but no or very little goods receipt, with consumed value, receipt …
Overdue Production Orders and Remaining Quantity Report
A custom ALV report that lists production orders past their basic finish date that are not yet fully received, with days late, remaining quantity and …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.