Routing Standard Value Change Audit Report
Short answer: A custom ALV report that lists operations changed in routings within a date range, with the old and new setup, machine and labor standard values, the change percentage, the user who changed them and the change number. Time changes that directly affect product costs and capacity planning are audited in one list.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
CA03 shows one routing on a key date; to see the old state of a change made with a change number the routing must be opened again with another date. CA80 gives the work center where-used and CA85 the mass replace; but no standard list answers 'in which routings did who change which standard value, and by what percentage, last month' across several routings. When differences appear after a cost estimate, the root cause analysis is done by hand. The custom report lists the changes compared with the previous record.
Who uses it? Industrial engineering and work study teams, cost accounting (product costing), internal audit and PP master data owners.
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 |
|---|---|---|---|
| PLPOTask List Operation | Routing operations: standard values, change data (driving table) | — | ECC + S/4 |
| PLASTask List Selection of Operations | Assignment of the operation to the routing counter | PLAS-PLNTY = PLPO-PLNTY AND PLAS-PLNNR = PLPO-PLNNR AND PLAS-PLNKN = PLPO-PLNKN | ECC + S/4 |
| PLKOTask List Header | Routing header: usage, status | PLKO-PLNTY = PLAS-PLNTY AND PLKO-PLNNR = PLAS-PLNNR AND PLKO-PLNAL = PLAS-PLNAL | ECC + S/4 |
| MAPLAssignment of Task Lists to Materials | Material assigned to the routing | MAPL-PLNTY = PLKO-PLNTY AND MAPL-PLNNR = PLKO-PLNNR AND MAPL-PLNAL = PLKO-PLNAL | ECC + S/4 |
| CRHDWork Center Header | Work center of the operation | CRHD-OBJTY = 'A' AND CRHD-OBJID = PLPO-ARBID | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = MAPL-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | PLPO-WERKS | Yes | 1000 |
| S_PLNNR | Routing group | Range / multiple | PLKO-PLNNR | No | 50000120 |
| S_MATNR | Material | Range / multiple | MAPL-MATNR | No | FG-* |
| S_AEDAT | Changed on | Range / multiple | PLPO-AEDAT | Yes | 01.10.2026 – 31.10.2026 |
| S_AENAM | Changed by | Range / multiple | PLPO-AENAM | No | — |
| S_AENNR | Change number | Range / multiple | PLPO-AENNR | No | 500000000412 |
| P_PCT | Minimum change (%) | Single value | — | No | 10 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Material | MAPL-MATNR |
| 2 | Material description | MAKT-MAKTX |
| 3 | Routing group | PLKO-PLNNR |
| 4 | Counter | PLKO-PLNAL |
| 5 | Operation | PLPO-VORNR |
| 6 | Work center | CRHD-ARBPL |
| 7 | Valid from | PLPO-DATUV |
| 8 | Change number | PLPO-AENNR |
| 9 | Changed by | PLPO-AENAM |
| 10 | Changed on | PLPO-AEDAT |
| 11 | Standard value | Calculated Changed field: Setup (VGW01), Machine (VGW02) or Labor (VGW03) |
| 12 | Old value | Calculated Value in the PLPO record with the previous DATUV for the same PLNKN; blank if none |
| 13 | New value | Calculated VGW01/VGW02/VGW03 of the current PLPO record with its unit |
| 14 | Change (%) | Calculated (New − Old) ÷ Old × 100 |
| 15 | Base quantity | PLPO-BMSCH |
Sample output
| Material | Material description | Routing group | Counter | Operation | Work center | Valid from | Change number | Changed by | Changed on | Standard value | Old value | New value | Change (%) | Base quantity |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FG-5003 | Packed product C | 50000120 | 1 | 0020 | DOLUM-01 | 10/06/2026 | 500000000412 | ADEMIR | 10/05/2026 | Machine | 12 MIN | 9 MIN | -25 | 100 |
| FG-5003 | Packed product C | 50000120 | 1 | 0020 | DOLUM-01 | 10/06/2026 | 500000000412 | ADEMIR | 10/05/2026 | Setup | 30 MIN | 45 MIN | 50 | 100 |
| FG-6100 | Panel cabinet 80 cm | 50000144 | 1 | 0030 | KAYN-02 | 03/01/2024 | BYILMAZ | 10/17/2026 | Labor | No previous value | 1,8 H | 1 | ||
| SA-3100 | Body subassembly | 50000098 | 2 | 0010 | PRES-01 | 10/21/2026 | 500000000430 | CKAYA | 10/20/2026 | Machine | 40 SEC | 52 SEC | 30 | 10 |
How does the report work?
- Routing operations (PLNTY ‘N’ and ‘R’) of the selected plant (WERKS) are read from PLPO where the change date AEDAT or creation date ANDAT is in the selected range; AENAM and AENNR filter the selection.
- For changes made with a change number, the PLPO record with an older DATUV for the same PLNNR and PLNKN is taken as the previous value; VGW01, VGW02 and VGW03 are compared together with the units (VGE01–VGE03) and the base quantity (BMSCH).
- For changes made without a change number the previous value is not kept in the system, so the line shows only the last value, the user and the date, with the note ‘No previous value’.
- Through PLAS the routing counter (PLNAL) the operation belongs to is found, PLKO gives the routing usage and status, and MAPL the assigned material.
- The work center is read from CRHD-ARBPL; each changed standard value becomes a separate line and the change percentage is calculated as (new − old) ÷ old × 100.
- When a percentage threshold is entered, lines whose absolute change is below it are hidden.
Performance notes
Read PLPO by PLNTY, WERKS and AEDAT; in large plants limit the date range to one or two months. Fetch the previous records with one FOR ALL ENTRIES read on the list of changed PLNNR. For the monthly audit, run the report in the background and email it to the costing team.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The routing group opens CA03 on the change date; the change number opens the change master record.
- Export to Excel
- Runs as a background job
- Send the result by email
Authorization objects
- C_ROUTAuthorization to display routings
- C_ROUT_MATDisplay of routings assigned to materials
Frequently asked questions
Why is the old value not shown for routings changed without a change number?
Without a change number, SAP overwrites the PLPO record and does not keep the old value; only the last user and date remain. If a full before/after trail is needed, making engineering change management (change numbers) mandatory for routing changes is recommended.
Are deleted or newly added operations listed?
Yes. Operations deleted with a change number are shown as 'deleted', newly added ones as 'new operation', with the old or new value left blank.
Does the report work on S/4HANA?
Yes. PLKO, PLPO, PLAS and MAPL keep the same structure in S/4HANA. For a clean core approach, released CDS views such as I_MfgBillOfOperationsChgSt and I_MfgBOOOperationChangeState can be used.
Packages that include this solution
BOM, Routing and Production Version Pack
A five-component pack that loads, changes and audits production master data: mass routing creation from Excel, mass BOM component changes, an audit of …
Related reports
Mass Routing Creation Upload Program from Excel
A custom program that creates material routings in bulk from operation rows in an Excel or CSV file, with header, operations, work centers, control …
Production Order Schedule Adherence Report (Planned vs Actual Start and Finish)
A custom ALV report that compares the planned and actual start and finish dates of completed production orders and calculates the days of delay and …
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.