Production Orders with Consumption but No Goods Receipt Report
Short answer: A custom ALV report that lists production orders with posted component consumption but no or very little goods receipt, with consumed value, receipt value, open balance and waiting time. Orders to check before month-end WIP and variance calculation appear in one list.
- Estimated effort
- S · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MB51 lists 261 (consumption) and 101 (goods receipt) movements as separate lines; it does not flag orders with consumption and no receipt and does not calculate the open balance per order. The COOIS goods movement view does not give the total value per order or the waiting time either. At month end these orders are found by matching two lists in Excel.
Who uses it? Cost accountants, controllers, production planners and month-end closing teams.
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 |
|---|---|---|---|
| AUFMGoods Movements for Orders | Goods movements of the order: consumption and goods receipt (driving table) | — | ECC + S/4 |
| AUFKOrder Master Data | Order type, plant and object number | AUFK-AUFNR = AUFM-AUFNR | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | MRP controller and planned dates | AFKO-AUFNR = AUFM-AUFNR | ECC + S/4 |
| AFPOOrder Item | Header material, order quantity and quantity received | AFPO-AUFNR = AUFM-AUFNR | ECC + S/4 |
| JESTIndividual Object Status | TECO, CLSD and deletion flag check | JEST-OBJNR = AUFK-OBJNR | 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_AUFNR | Production order | Range / multiple | AUFM-AUFNR | No | 1000398 |
| S_MATNR | Material | Range / multiple | AFPO-MATNR | No | FG-5003 |
| P_CUTOF | Cutoff date (first consumption before this date) | Single value | SY-DATUM | Yes | 31.10.2026 |
| P_RECPCT | Delivery percentage threshold (%) | Single value | — | No | 10 |
| P_TECO | Include technically completed orders | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Production order | AUFM-AUFNR |
| 2 | Order type | AUFK-AUART |
| 3 | Material | AFPO-MATNR |
| 4 | Description | MAKT-MAKTX |
| 5 | Order qty | AFPO-PSMNG |
| 6 | Received qty | AFPO-WEMNG |
| 7 | Unit | AFPO-MEINS |
| 8 | First consumption | Calculated Smallest AUFM-BUDAT of 261 movements |
| 9 | Last consumption | Calculated Largest AUFM-BUDAT of 261 movements |
| 10 | Consumed value | Calculated Σ AUFM-DMBTR (261 plus, 262 minus) |
| 11 | Receipt value | Calculated Σ AUFM-DMBTR (101 plus, 102 minus) |
| 12 | Open balance | Calculated Consumed value − receipt value |
| 13 | Currency | AUFM-WAERS |
| 14 | Waiting (days) | Calculated Today − first consumption |
| 15 | System status | Calculated Texts of the active statuses in JEST |
Sample output
| Production order | Order type | Material | Description | Order qty | Received qty | Unit | First consumption | Last consumption | Consumed value | Receipt value | Open balance | Currency | Waiting (days) | System status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000398 | PP01 | FG-5003 | Packed product C | 1,000 | 0 | PC | 10/06/2026 | 10/09/2026 | 184,500 | 0 | 184,500 | TRY | 42 | Released, partially confirmed |
| 1000405 | PP01 | FG-6100 | Painted panel 120 cm | 400 | 0 | PC | 10/14/2026 | 10/20/2026 | 96,200 | 0 | 96,200 | TRY | 34 | Released, confirmed |
| 1000419 | PP02 | SF-2210 | Welded chassis | 120 | 10 | PC | 10/21/2026 | 11/02/2026 | 58,800 | 4,900 | 53,900 | TRY | 27 | Released, partially delivered |
| 1000427 | PP01 | FG-5003 | Packed product C | 500 | 0 | PC | 10/30/2026 | 10/30/2026 | 12,400 | 0 | 12,400 | TRY | 18 | Technically completed |
How does the report work?
- Production orders (AUTYP = 10) of the selected plant are read from AUFK. Closed (CLSD, I0046) and deleted (I0076) orders are skipped with JEST; technically completed orders (TECO, I0045) are included by selection.
- Goods movements of the order are read from AUFM. Consumption: movement type 261 plus, 262 minus. Goods receipt: 101 plus, 102 minus. The amount is AUFM-DMBTR, the sign follows AUFM-SHKZG.
- Orders whose first consumption is before the cutoff date and whose delivery percentage (AFPO-WEMNG ÷ AFPO-PSMNG × 100) is below the threshold are listed.
- Open balance = consumed value − goods receipt value. This is the balance to explain before the month-end WIP calculation.
- Waiting time = today − first consumption date. ALV shows subtotals per order type and is sorted by open balance, highest first.
Performance notes
Read AUFM with FOR ALL ENTRIES on the order numbers and restrict movement types to 101, 102, 261 and 262. With a very large number of open orders, run the report as a background job one day before closing.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The order number opens CO03, the value columns open the order's goods movements.
- Export to Excel
- Runs as a background job
- Send the result by email Can be sent to cost accounting and planning before closing.
Authorization objects
- C_AFKO_AWKDisplay production orders by plant and order type
- M_MSEG_WWADisplay goods movements by plant
Frequently asked questions
Is the open balance the same as WIP?
Roughly, but not exactly. The WIP calculation also includes activity costs and overhead. This report only looks at material movements and is designed to quickly find the orders that need an explanation before the WIP run.
How are co-product or by-product receipts counted?
All 101 receipts linked to an order item are added to the receipt value. If a different movement type is used for by-products, those types are added to the selection during installation.
Does it work on S/4HANA?
Yes. In S/4HANA AUFM is read from MATDOC as a compatibility view; MATDOC or released material document CDS views can be used directly if preferred.
Packages that include this solution
Product Cost and Production Variance Pack
A four-report pack that shows where product cost variance comes from, with one plant and period selection: standard vs current cost estimate …
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 …
COGI Failed Goods Movements Aging Report
A custom ALV report that groups the backflush and automatic goods receipt errors waiting in COGI by age, error reason and material, and flags which of …
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.