Engineering & PLMFree worksheetPDF, Excel, Word exportSAP S/4HANA

SAP Engineering Change Affected Materials Impact Worksheet

An engineering change touches more materials than the change request lists. This worksheet gives the change coordinator a simple table for every affected material, with quantities, cost and disposition, and exports to Excel for the change board.

Download:

Material	Change type	Stock	WIP	Open PO	Unit cost	Exposure	Disposition	Effective from
						$13,760
						$1,080
						$26,500
						$4,884
						$200

Total exposure

$46,424

Total stock

10,925

Materials affected

Average exposure per material

$9,285

Largest single exposure

$26,500

Fill this from the where-used list and stock reports for the parts named on your engineering change number. Exposure is gross, so it does not subtract rework or salvage value; use the obsolescence exposure calculator for a net estimate.

Automated change impact list

Optional help generating this worksheet from where-used and stock data.

Optional. The tool and every export work without this. No spam.

How to use it

Start from the where-used list of each changed component and add every material in the BOM tree that is affected, including subassemblies and finished goods. For each row, record stock, WIP and open purchase quantity, the unit cost and the disposition decided by the board. The worksheet calculates exposure per row and totals the sheet.

Add one row per material and plant if values differ
Set an effective date per row
Export to Excel for the approval pack

Why dispositions matter

Every affected quantity needs a decision. Use up is cheapest when the effectivity allows a run-out. Rework applies when a part can be modified or used elsewhere. Scrap and return to vendor are last resorts, and open purchase orders either continue, change or are cancelled. Writing it down per material prevents the surprise of finding old parts on the line after cut-in.

Reading the totals

The total exposure is the gross value of everything touched. The largest single exposure shows where to focus effort, because one expensive subassembly can dominate the sheet. The average exposure helps compare changes of different sizes.

Common mistakes

The usual failure is incomplete scope: only the changed component is listed, while assemblies built with it sit in stock. Another is leaving out service parts, since a change that affects the field may also affect spares.

Leaving out stocked subassemblies
Ignoring service and spare parts
No effective date for each row

Frequently Asked Questions

Where do I get the affected materials?

Run a where-used for the changed component through all BOM levels, then add materials from your change request. Include variants and plants. A multi-level where-used report is the usual starting point.

Is exposure the same as loss?

No. It is the gross value of the quantities touched. The loss depends on dispositions and recovery, which the obsolescence exposure calculator estimates.

Can I attach this to the change record?

Export it to Excel or PDF and attach it to your change request, or reference it in the change master record according to your process.

Should every plant have its own row?

Yes if stock, cost or effective dates differ by plant. Otherwise a single row with the combined quantities is easier to review.

Netray can help generate this list automatically from where-used data and stock reports, so every change starts with a complete impact table.

Talk to an Expert Explore More Free Tools

Related Tools

Engineering & PLM

More Engineering & PLM tools

See all

Back to All Tools