# Routing Standard Value Change Audit Report

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

- Type: Report, Custom development, ALV report
- Module: PP
- Estimated effort: M (4–6 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/routing-standard-value-change-history-report/


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

### Closest standard alternatives

- CA03: Shows one routing on a key date; does not list changes across several routings with before/after values.
- CA85: Replaces work centers in mass; does not give an audit list of the changes made.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| PLPO | Routing operations: standard values, change data (driving table) | Read | - | ECC + S/4 |
| PLAS | Assignment of the operation to the routing counter | Read | PLAS-PLNTY = PLPO-PLNTY AND PLAS-PLNNR = PLPO-PLNNR AND PLAS-PLNKN = PLPO-PLNKN | ECC + S/4 |
| PLKO | Routing header: usage, status | Read | PLKO-PLNTY = PLAS-PLNTY AND PLKO-PLNNR = PLAS-PLNNR AND PLKO-PLNAL = PLAS-PLNAL | ECC + S/4 |
| MAPL | Material assigned to the routing | Read | MAPL-PLNTY = PLKO-PLNTY AND MAPL-PLNNR = PLKO-PLNNR AND MAPL-PLNAL = PLKO-PLNAL | ECC + S/4 |
| CRHD | Work center of the operation | Read | CRHD-OBJTY = 'A' AND CRHD-OBJID = PLPO-ARBID | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = MAPL-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | PLPO-WERKS | Yes |
| S_PLNNR | Routing group | Range / multiple | PLKO-PLNNR | No |
| S_MATNR | Material | Range / multiple | MAPL-MATNR | No |
| S_AEDAT | Changed on | Range / multiple | PLPO-AEDAT | Yes |
| S_AENAM | Changed by | Range / multiple | PLPO-AENAM | No |
| S_AENNR | Change number | Range / multiple | PLPO-AENNR | No |
| P_PCT | Minimum change (%) | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Material | MAPL-MATNR |
| Material description | MAKT-MAKTX |
| Routing group | PLKO-PLNNR |
| Counter | PLKO-PLNAL |
| Operation | PLPO-VORNR |
| Work center | CRHD-ARBPL |
| Valid from | PLPO-DATUV |
| Change number | PLPO-AENNR |
| Changed by | PLPO-AENAM |
| Changed on | PLPO-AEDAT |
| Standard value | Calculated: Changed field: Setup (VGW01), Machine (VGW02) or Labor (VGW03) |
| Old value | Calculated: Value in the PLPO record with the previous DATUV for the same PLNKN; blank if none |
| New value | Calculated: VGW01/VGW02/VGW03 of the current PLPO record with its unit |
| Change (%) | Calculated: (New − Old) ÷ Old × 100 |
| Base quantity | PLPO-BMSCH |

## How does the report work?

1. 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.
2. 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).
3. 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'.
4. Through PLAS the routing counter (PLNAL) the operation belongs to is found, PLKO gives the routing usage and status, and MAPL the assigned material.
5. 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.
6. When a percentage threshold is entered, lines whose absolute change is below it are hidden.

## Authorization objects

- C_ROUT: Authorization to display routings
- C_ROUT_MAT: Display 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=pp-routing-standard-value-change-audit
