PP Report Custom development ALV report

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

  • COOIS Production Order Information System. Lists orders with a status selection; the valid confirmation check, waiting time and movement flag are not in the same list.
  • CO03 Display Production Order. Shows the operations and confirmations of one order.

Tables used

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

TableRoleJoinSystem
AUFKOrder Master DataOrder type, plant and object number (driving table)—ECC + S/4
JESTIndividual Object StatusCheck of the REL, DLV, TECO and deletion statusJEST-OBJNR = AUFK-OBJNR AND JEST-INACT = ' 'ECC + S/4
AFKOOrder Header Data for PP OrdersRelease date, scheduled dates, production supervisorAFKO-AUFNR = AUFK-AUFNRECC + S/4
AFPOOrder ItemMaterial, order and goods receipt quantityAFPO-AUFNR = AUFK-AUFNRECC + S/4
AFVCOperation within an OrderOperations and confirmation numbersAFVC-AUFPL = AFKO-AUFPLECC + S/4
AFRUOrder ConfirmationsCheck for a valid confirmation recordAFRU-RUECK = AFVC-RUECK AND AFRU-STOKZ = ' ' AND AFRU-STZHL = '00000000'ECC + S/4
RESBReservation/Dependent RequirementsWhether components were withdrawnRESB-AUFNR = AUFK-AUFNRECC + S/4
CRHDWork Center HeaderWork center of the first operationCRHD-OBJTY = 'A' AND CRHD-OBJID = AFVC-ARBIDECC + 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_FEVORProduction supervisorRange / multipleAFKO-FEVORNo101
S_DISPOMRP controllerRange / multipleAFKO-DISPONo001
S_FTRMIRelease dateRange / multipleAFKO-FTRMINo01.01.2026 – 10.11.2026
P_DAYSMinimum days since releaseSingle value—Yes5
P_MOVEOnly orders with goods movementsCheckbox—No—

Output columns

#ColumnSource
1OrderAUFK-AUFNR
2Order typeAUFK-AUART
3MaterialAFPO-MATNR
4Material descriptionMAKT-MAKTX
5SupervisorAFKO-FEVOR
6Released onAFKO-FTRMI
7Days since releaseCalculated Today − AFKO-FTRMI
8Scheduled startAFKO-GSTRS
9Scheduled finishAFKO-GLTRS
10Order quantityAFPO-PSMNG
11Goods receipt quantityAFPO-WEMNG
12First work centerCRHD-ARBPL
13OperationsCalculated Number of AFVC lines under AFKO-AUFPL
14Components issuedCalculated X when any RESB line has ENMNG > 0
15FindingCalculated Waiting / Scheduled start passed / Movements, no confirmation

Sample output

OrderOrder typeMaterialMaterial descriptionSupervisorReleased onDays since releaseScheduled startScheduled finishOrder quantityGoods receipt quantityFirst work centerOperationsComponents issuedFinding
1000412PP01FG-5003Packed product C10109/22/20265609/24/202609/26/20261,2000MONT-014XMovements, no confirmation
1000437PP01FG-6100Panel cabinet 80 cm10210/15/20263310/20/202610/23/20261500KAYN-026Scheduled start passed
1000455PP02SA-3100Body subassembly10111/03/20261411/18/202611/19/20264000PRES-013Waiting
1000461PP01FG-7200Compressor unit K210311/05/20261211/06/202611/12/20266020TEST-015XMovements, no confirmation
A view built with fictional sample data; not real system data.

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

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

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: Released Production Orders Without Any Confirmation Report