# 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 value, open balance and waiting time. Orders to check before month-end WIP and variance calculation appear in one list.

- Type: Report, Custom development, ALV report
- Module: PP
- Estimated effort: S (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/production-orders-with-consumption-but-no-goods-receipt-report/


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

### Closest standard alternatives

- MB51: Lists consumption and goods receipt on separate lines; it does not flag orders with consumption and no receipt.
- COOIS: Shows goods movements per order; no open balance and no waiting time.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| AUFM | Goods movements of the order: consumption and goods receipt (driving table) | Read | - | ECC + S/4 |
| AUFK | Order type, plant and object number | Read | AUFK-AUFNR = AUFM-AUFNR | ECC + S/4 |
| AFKO | MRP controller and planned dates | Read | AFKO-AUFNR = AUFM-AUFNR | ECC + S/4 |
| AFPO | Header material, order quantity and quantity received | Read | AFPO-AUFNR = AUFM-AUFNR | ECC + S/4 |
| JEST | TECO, CLSD and deletion flag check | Read | JEST-OBJNR = AUFK-OBJNR | 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_AUFNR | Production order | Range / multiple | AUFM-AUFNR | No |
| S_MATNR | Material | Range / multiple | AFPO-MATNR | No |
| P_CUTOF | Cutoff date (first consumption before this date) | Single value | SY-DATUM | Yes |
| P_RECPCT | Delivery percentage threshold (%) | Single value | - | No |
| P_TECO | Include technically completed orders | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Production order | AUFM-AUFNR |
| Order type | AUFK-AUART |
| Material | AFPO-MATNR |
| Description | MAKT-MAKTX |
| Order qty | AFPO-PSMNG |
| Received qty | AFPO-WEMNG |
| Unit | AFPO-MEINS |
| First consumption | Calculated: Smallest AUFM-BUDAT of 261 movements |
| Last consumption | Calculated: Largest AUFM-BUDAT of 261 movements |
| Consumed value | Calculated: Σ AUFM-DMBTR (261 plus, 262 minus) |
| Receipt value | Calculated: Σ AUFM-DMBTR (101 plus, 102 minus) |
| Open balance | Calculated: Consumed value − receipt value |
| Currency | AUFM-WAERS |
| Waiting (days) | Calculated: Today − first consumption |
| System status | Calculated: Texts of the active statuses in JEST |

## How does the report work?

1. 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.
2. 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.
3. Orders whose first consumption is before the cutoff date and whose delivery percentage (AFPO-WEMNG ÷ AFPO-PSMNG × 100) is below the threshold are listed.
4. Open balance = consumed value − goods receipt value. This is the balance to explain before the month-end WIP calculation.
5. Waiting time = today − first consumption date. ALV shows subtotals per order type and is sorted by open balance, highest first.

## Authorization objects

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

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=pp-consumption-without-goods-receipt
