PP Report Custom development ALV report

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

  • CA03 Display Routing. Shows one routing on a key date; does not list changes across several routings with before/after values.
  • CA85 Replace Work Center in Task Lists. Replaces work centers in mass; does not give an audit list of the changes made.

Tables used

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

TableRoleJoinSystem
PLPOTask List OperationRouting operations: standard values, change data (driving table)—ECC + S/4
PLASTask List Selection of OperationsAssignment of the operation to the routing counterPLAS-PLNTY = PLPO-PLNTY AND PLAS-PLNNR = PLPO-PLNNR AND PLAS-PLNKN = PLPO-PLNKNECC + S/4
PLKOTask List HeaderRouting header: usage, statusPLKO-PLNTY = PLAS-PLNTY AND PLKO-PLNNR = PLAS-PLNNR AND PLKO-PLNAL = PLAS-PLNALECC + S/4
MAPLAssignment of Task Lists to MaterialsMaterial assigned to the routingMAPL-PLNTY = PLKO-PLNTY AND MAPL-PLNNR = PLKO-PLNNR AND MAPL-PLNAL = PLKO-PLNALECC + S/4
CRHDWork Center HeaderWork center of the operationCRHD-OBJTY = 'A' AND CRHD-OBJID = PLPO-ARBIDECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = MAPL-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multiplePLPO-WERKSYes1000
S_PLNNRRouting groupRange / multiplePLKO-PLNNRNo50000120
S_MATNRMaterialRange / multipleMAPL-MATNRNoFG-*
S_AEDATChanged onRange / multiplePLPO-AEDATYes01.10.2026 – 31.10.2026
S_AENAMChanged byRange / multiplePLPO-AENAMNo—
S_AENNRChange numberRange / multiplePLPO-AENNRNo500000000412
P_PCTMinimum change (%)Single value—No10

Output columns

#ColumnSource
1MaterialMAPL-MATNR
2Material descriptionMAKT-MAKTX
3Routing groupPLKO-PLNNR
4CounterPLKO-PLNAL
5OperationPLPO-VORNR
6Work centerCRHD-ARBPL
7Valid fromPLPO-DATUV
8Change numberPLPO-AENNR
9Changed byPLPO-AENAM
10Changed onPLPO-AEDAT
11Standard valueCalculated Changed field: Setup (VGW01), Machine (VGW02) or Labor (VGW03)
12Old valueCalculated Value in the PLPO record with the previous DATUV for the same PLNKN; blank if none
13New valueCalculated VGW01/VGW02/VGW03 of the current PLPO record with its unit
14Change (%)Calculated (New − Old) ÷ Old × 100
15Base quantityPLPO-BMSCH

Sample output

MaterialMaterial descriptionRouting groupCounterOperationWork centerValid fromChange numberChanged byChanged onStandard valueOld valueNew valueChange (%)Base quantity
FG-5003Packed product C5000012010020DOLUM-0110/06/2026500000000412ADEMIR10/05/2026Machine12 MIN9 MIN-25100
FG-5003Packed product C5000012010020DOLUM-0110/06/2026500000000412ADEMIR10/05/2026Setup30 MIN45 MIN50100
FG-6100Panel cabinet 80 cm5000014410030KAYN-0203/01/2024BYILMAZ10/17/2026LaborNo previous value1,8 H1
SA-3100Body subassembly5000009820010PRES-0110/21/2026500000000430CKAYA10/20/2026Machine40 SEC52 SEC3010
A view built with fictional sample data; not real system data.

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.

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

PP Package Custom

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 …

5 components · v1.0

Related reports

PP Program Custom Mass upload

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 …

MARC · CRHD · PLKO · MAPL

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: Routing Standard Value Change Audit Report