BOM Change Log Report with E-mail Alerts
Short answer: A report that shows component additions, deletions, quantity and validity changes in bills of material in a readable list with who, when and the old and new values, and emails changes in selected material groups to the departments concerned. The same screen also gives the history of quantity, date and component changes in released production orders.
- Estimated effort
- M · 5–8 working days
- System
- ECC and S/4HANA
- Tables
- 10
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
CS80 shows BOM change documents, but as technical output per field; the component number and old/new quantity cannot be read side by side, and nobody is notified when a change happens. Changes to production orders are shown order by order in CO03. The custom report turns the change documents into readable lines per component and order, gives a combined view and produces email alerts.
Who uses it? Product engineering and R&D, production planning, purchasing, quality and cost accounting teams.
Closest standard alternatives
- CS80 Change Documents for Material BOMs. Shows BOM change documents; no readable per-component list and no email alerts.
- CO03 Display Production Order. Change documents can be displayed from within one order at a time.
- CS14 BOM Comparison. Compares two BOMs or dates; does not show who changed what and when.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| CDHDRChange Document Header | Change document header: user, date, time, object (driving table) | — | ECC + S/4 |
| CDPOSChange Document Items | Changed table, field, old and new value | CDPOS-OBJECTCLAS = CDHDR-OBJECTCLAS AND CDPOS-OBJECTID = CDHDR-OBJECTID AND CDPOS-CHANGENR = CDHDR-CHANGENR | ECC + S/4 |
| MASTMaterial to BOM Link | Header material and usage of the BOM | MAST-STLNR = CDPOS-TABKEY+4(8) | ECC + S/4 |
| STKOBOM Header | BOM header: base quantity, status | STKO-STLNR = MAST-STLNR | ECC + S/4 |
| STPOBOM Item | BOM item: component, quantity, change number, validity | STPO-STLNR = CDPOS-TABKEY+4(8) AND STPO-STLKN = CDPOS-TABKEY+12(8) | ECC + S/4 |
| STASBOM Item Selection | Alternative-to-item link and deletion indicator | STAS-STLNR = STPO-STLNR AND STAS-STLKN = STPO-STLKN | ECC + S/4 |
| AENRChange Master | Change number description and valid-from date | AENR-AENNR = STPO-AENNR | ECC + S/4 |
| MAKTMaterial Descriptions | Header material and component descriptions | MAKT-MATNR = MAST-MATNR / STPO-IDNRK | ECC + S/4 |
| AFKOOrder Header Data for PP Orders | Order header and dates for order changes | AFKO-AUFNR ↔ CDHDR-OBJECTID (CDHDR-OBJECTCLAS = 'ORDER') | ECC + S/4 |
| RESBReservation/Dependent Requirements | Component items for order changes | RESB-AUFNR = AFKO-AUFNR | ECC + S/4 |
BAPIs and functions used
- CHANGEDOCUMENT_READRead Change Documents. Reads change documents with their items
- SO_DOCUMENT_SEND_API1SAPoffice: Send Document with Attachments. Sends the change summary by email
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_UDATE | Change date | Range / multiple | CDHDR-UDATE | Yes | 01.11.2026 – 15.11.2026 |
| S_MATNR | Header material | Range / multiple | MAST-MATNR | No | MAM-40021 |
| S_WERKS | Plant | Range / multiple | MAST-WERKS | No | 1000 |
| S_USER | Changed by | Range / multiple | CDHDR-USERNAME | No | MUH_AYILMAZ |
| P_ORDER | Also show production order changes | Checkbox | — | No | X |
| P_ALERT | Alert mode: email changes since the last run | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Date | CDHDR-UDATE |
| 2 | Time | CDHDR-UTIME |
| 3 | User | CDHDR-USERNAME |
| 4 | Object | Calculated BOM or production order (by object class) |
| 5 | Header material / order | Calculated MAST-MATNR or AFKO-AUFNR |
| 6 | Component | STPO-IDNRK |
| 7 | Changed field | Calculated CDPOS-FNAME translated into a user-friendly label |
| 8 | Old value | CDPOS-VALUE_OLD |
| 9 | New value | CDPOS-VALUE_NEW |
| 10 | Change type | Calculated CDPOS-CHNGIND: I = added, D = deleted, U = changed |
| 11 | Change number | STPO-AENNR |
| 12 | Notified | Calculated Recipient group if an alert email was sent |
Sample output
| Date | Time | User | Object | Header material / order | Component | Changed field | Old value | New value | Change type | Change number | Notified |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 12.11.2026 | 09:42 | MUH_AYILMAZ | BOM | MAM-40021 | YM-11870 | Component quantity | 4 | 6 | Changed | 500000123 | Planning, Purchasing |
| 12.11.2026 | 09:44 | MUH_AYILMAZ | BOM | MAM-40021 | HM-20455 | Component | HM-20455 | Added | 500000123 | Planning, Purchasing | |
| 13.11.2026 | 14:05 | MUH_KDEMIR | BOM | MAM-40388 | HM-20102 | Valid from | 01.11.2026 | 01.12.2026 | Changed | Planning | |
| 14.11.2026 | 08:17 | PLN_SAKSOY | Production order | 1004512 | HM-30017 | Requirement quantity | 120 | 150 | Changed |
How does the report work?
- BOM change documents (object class STUE) are read from CDHDR for the selected date range; optionally production order change documents (object class ORDER) are added. Order change documents are created only if change documents are activated in the order type parameters.
- Item details come from CDPOS: table (STKO, STPO, STAS or RESB, AFKO, AFPO), field, change type (CHNGIND) and old/new value. The table key (TABKEY) is decoded to find the BOM number and item node.
- The BOM number is linked to the header material through MAST, the item through STPO to the component (IDNRK), item number and change number (AENNR); descriptions come from MAKT. If a change number exists, its description and valid-from date are added from AENR.
- For older records without change documents, the creation and change data in STPO/STAS (ANDAT/ANNAM, AEDAT/AENAM) and the date validity (DATUV) are used as a fallback source.
- Field names are translated into user-friendly labels (e.g. MENGE → Component quantity, DATUV → Valid from) and each line is classified as added, deleted or changed.
- Alert mode runs as a scheduled job: changes since the last run are mapped to a distribution setting by material group, plant or BOM usage, and each recipient group gets a summary table email sent with SO_DOCUMENT_SEND_API1; sent documents are flagged so they are not sent again.
Performance notes
Read CDHDR by OBJECTCLAS and UDATE; fetch CDPOS only for the change numbers found. Run the alert job e.g. hourly rather than at very short intervals and keep the last run time in a settings record.
Features
- ALV list (sort, filter, subtotals)
- Double-click drill-down to the document From a line you open the BOM in CS03 or the order in CO03.
- Send the result by email A summary table is sent to recipients defined per material group or plant.
- Runs as a background job Alert mode runs as a scheduled job and sends only new changes.
- Export to Excel
Authorization objects
- C_STUE_WRKBOM display by plant
- C_STUE_BERBOM display by authorization group
- C_AFKO_AWKOrder display for order changes
- S_OC_SENDSending external email from SAP
Frequently asked questions
Why are production order changes empty for some orders?
Order change documents are created only after change documents are activated for the order type and plant. There are no documents for changes made before activation; the report flags these orders as 'no documents'.
How do changes made with a change number appear?
Changes made with a change number create a new validity slice for the item. The report shows the change number, its description and valid-from date, so you also see from which date the change affects production.
Who receives the alerts?
Recipients are defined in a settings table by material group, plant or BOM usage; email addresses are taken from user master data or a distribution list. Each recipient sees only the changes within their scope.
Related reports
Mass BOM Component Replacement Upload Program
A custom program that replaces, adds or deletes components or updates quantities in many material BOMs from Excel or CSV rows. Validity is set with a …
Multi-Level BOM Where-Used Report with Open Production Orders
A custom ALV report that shows in which assemblies and, at the top, in which finished goods one or more components are used, as a flat list that …
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 …
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.