PP Report Custom development ALV report

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

  • MB51 Material Document List. Lists consumption and goods receipt on separate lines; it does not flag orders with consumption and no receipt.
  • COOIS Production Order Information System. Shows goods movements per order; no open balance and no waiting time.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
AUFMGoods Movements for OrdersGoods movements of the order: consumption and goods receipt (driving table)—ECC + S/4
AUFKOrder Master DataOrder type, plant and object numberAUFK-AUFNR = AUFM-AUFNRECC + S/4
AFKOOrder Header Data for PP OrdersMRP controller and planned datesAFKO-AUFNR = AUFM-AUFNRECC + S/4
AFPOOrder ItemHeader material, order quantity and quantity receivedAFPO-AUFNR = AUFM-AUFNRECC + S/4
JESTIndividual Object StatusTECO, CLSD and deletion flag checkJEST-OBJNR = AUFK-OBJNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = AFPO-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleAUFK-WERKSYes1000
S_AUARTOrder typeRange / multipleAUFK-AUARTNoPP01
S_AUFNRProduction orderRange / multipleAUFM-AUFNRNo1000398
S_MATNRMaterialRange / multipleAFPO-MATNRNoFG-5003
P_CUTOFCutoff date (first consumption before this date)Single valueSY-DATUMYes31.10.2026
P_RECPCTDelivery percentage threshold (%)Single value—No10
P_TECOInclude technically completed ordersCheckbox—NoX

Output columns

#ColumnSource
1Production orderAUFM-AUFNR
2Order typeAUFK-AUART
3MaterialAFPO-MATNR
4DescriptionMAKT-MAKTX
5Order qtyAFPO-PSMNG
6Received qtyAFPO-WEMNG
7UnitAFPO-MEINS
8First consumptionCalculated Smallest AUFM-BUDAT of 261 movements
9Last consumptionCalculated Largest AUFM-BUDAT of 261 movements
10Consumed valueCalculated Σ AUFM-DMBTR (261 plus, 262 minus)
11Receipt valueCalculated Σ AUFM-DMBTR (101 plus, 102 minus)
12Open balanceCalculated Consumed value − receipt value
13CurrencyAUFM-WAERS
14Waiting (days)Calculated Today − first consumption
15System statusCalculated Texts of the active statuses in JEST

Sample output

Production orderOrder typeMaterialDescriptionOrder qtyReceived qtyUnitFirst consumptionLast consumptionConsumed valueReceipt valueOpen balanceCurrencyWaiting (days)System status
1000398PP01FG-5003Packed product C1,0000PC10/06/202610/09/2026184,5000184,500TRY42Released, partially confirmed
1000405PP01FG-6100Painted panel 120 cm4000PC10/14/202610/20/202696,200096,200TRY34Released, confirmed
1000419PP02SF-2210Welded chassis12010PC10/21/202611/02/202658,8004,90053,900TRY27Released, partially delivered
1000427PP01FG-5003Packed product C5000PC10/30/202610/30/202612,400012,400TRY18Technically completed
A view built with fictional sample data; not real system data.

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.

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

CO Package Custom

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 …

4 components · v1.0

Related reports

PP Report Custom ALV report

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 …

AFFW · T100 · MARD · MAKT

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.

Related report: Production Orders with Consumption but No Goods Receipt Report