# SAP Engineering Change Affected Materials Impact Worksheet

> Source: https://netray.co/tools/sap-ecn-affected-material-impact-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

A row by row worksheet of affected materials with quantities, cost and disposition that totals the financial impact of a change.

## Category

engineering-plm

## Erp

SAP S/4HANA

## Audience

- Engineering change coordinator
- SAP PLM consultant
- Planner

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Material

**Key:** material

**Type:** text

#### Change type

**Key:** level

**Type:** select

**Options:**

- Replace
- Remove
- Add
- Modify

#### Stock

**Key:** stock

**Type:** number

#### WIP

**Key:** wip

**Type:** number

#### Open PO

**Key:** po

**Type:** number

#### Unit cost

**Key:** cost

**Type:** number

**Format:** currency

#### Exposure

**Key:** exposure

**Type:** number

**Expr:** (stock + wip + po) * cost

**Format:** currency

#### Disposition

**Key:** disposition

**Type:** select

**Options:**

- Use up
- Rework
- Scrap
- Return to vendor
- Cancel PO

#### Effective from

**Key:** effective

**Type:** date

**Rows:**

**Material:** CMP-20417 Bracket rev B

**Level:** Replace

**Stock:** 1200

**Wip:** 150

**Po:** 800

**Cost:** 6.4

**Disposition:** Use up

**Effective:** 2026-12-01

**Material:** CMP-31882 Fastener M6

**Level:** Remove

**Stock:** 9000

**Wip:** 0

**Po:** 0

**Cost:** 0.12

**Disposition:** Use up

**Effective:** 2026-12-01

**Material:** SUB-55120 Housing assy

**Level:** Modify

**Stock:** 85

**Wip:** 40

**Po:** 0

**Cost:** 212

**Disposition:** Rework

**Effective:** 2026-11-15

**Material:** CMP-40016 Gasket

**Level:** Replace

**Stock:** 640

**Wip:** 0

**Po:** 2000

**Cost:** 1.85

**Disposition:** Cancel PO

**Effective:** 2026-11-15

**Material:** CMP-77310 Label

**Level:** Add

**Stock:** 0

**Wip:** 0

**Po:** 500

**Cost:** 0.4

**Disposition:** Use up

**Effective:** 2026-12-01

**Totals:**

#### Total exposure

**Key:** exposure

**Agg:** sum

**Format:** currency

#### Total stock

**Key:** stock

**Agg:** sum

**Format:** integer

#### Materials affected

**Key:** material

**Agg:** count

**Format:** integer

**Summary:**

#### Average exposure per material

**Key:** avg_exposure

**Expr:** if(gt(count, 0), sum_exposure / count, 0)

**Format:** currency

#### Largest single exposure

**Key:** max_line

**Expr:** max_exposure

**Format:** currency

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to use it

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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

**Body:** 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.

**Bullets:**

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

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

**Faq:**

#### Where do I get the affected materials?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

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

## Search terms

engineering change impact worksheet, sap ecn affected parts list, eco impact analysis excel, engineering change cost template, sap change master affected materials, engineering change disposition list, ecn bom where used impact, engineering change inventory worksheet

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json