# Released Production Orders Without Any Confirmation Report

> 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.

- Type: Report, Custom development, ALV report
- Module: PP
- Estimated effort: S (2–4 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/released-production-orders-without-confirmation-report/


## 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.

### Closest standard alternatives

- COOIS: Lists orders with a status selection; the valid confirmation check, waiting time and movement flag are not in the same list.
- CO03: Shows the operations and confirmations of one order.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| AUFK | Order type, plant and object number (driving table) | Read | - | ECC + S/4 |
| JEST | Check of the REL, DLV, TECO and deletion status | Read | JEST-OBJNR = AUFK-OBJNR AND JEST-INACT = ' ' | ECC + S/4 |
| AFKO | Release date, scheduled dates, production supervisor | Read | AFKO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFPO | Material, order and goods receipt quantity | Read | AFPO-AUFNR = AUFK-AUFNR | ECC + S/4 |
| AFVC | Operations and confirmation numbers | Read | AFVC-AUFPL = AFKO-AUFPL | ECC + S/4 |
| AFRU | Check for a valid confirmation record | Read | AFRU-RUECK = AFVC-RUECK AND AFRU-STOKZ = ' ' AND AFRU-STZHL = '00000000' | ECC + S/4 |
| RESB | Whether components were withdrawn | Read | RESB-AUFNR = AUFK-AUFNR | ECC + S/4 |
| CRHD | Work center of the first operation | Read | CRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBID | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = AFPO-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | AUFK-WERKS | Yes |
| S_AUART | Order type | Range / multiple | AUFK-AUART | No |
| S_FEVOR | Production supervisor | Range / multiple | AFKO-FEVOR | No |
| S_DISPO | MRP controller | Range / multiple | AFKO-DISPO | No |
| S_FTRMI | Release date | Range / multiple | AFKO-FTRMI | No |
| P_DAYS | Minimum days since release | Single value | - | Yes |
| P_MOVE | Only orders with goods movements | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Order | AUFK-AUFNR |
| Order type | AUFK-AUART |
| Material | AFPO-MATNR |
| Material description | MAKT-MAKTX |
| Supervisor | AFKO-FEVOR |
| Released on | AFKO-FTRMI |
| Days since release | Calculated: Today − AFKO-FTRMI |
| Scheduled start | AFKO-GSTRS |
| Scheduled finish | AFKO-GLTRS |
| Order quantity | AFPO-PSMNG |
| Goods receipt quantity | AFPO-WEMNG |
| First work center | CRHD-ARBPL |
| Operations | Calculated: Number of AFVC lines under AFKO-AUFPL |
| Components issued | Calculated: X when any RESB line has ENMNG > 0 |
| Finding | Calculated: Waiting / Scheduled start passed / Movements, no confirmation |

## How does the report work?

1. 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.
2. 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.
3. 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.
4. 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'.
5. The work center of the first operation comes from CRHD-ARBPL, the material description from MAKT.
6. The list is sorted by days since release, descending; the finding column shows 'Waiting', 'Scheduled start passed' or 'Movements, no confirmation'.

## Authorization objects

- C_AFKO_AWK: Display production orders by plant and order type
- C_AFRU_AWK: Display 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=pp-released-orders-without-confirmation
