PP Report Custom development ALV report

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.

TableRoleJoinSystem
CDHDRChange Document HeaderChange document header: user, date, time, object (driving table)—ECC + S/4
CDPOSChange Document ItemsChanged table, field, old and new valueCDPOS-OBJECTCLAS = CDHDR-OBJECTCLAS AND CDPOS-OBJECTID = CDHDR-OBJECTID AND CDPOS-CHANGENR = CDHDR-CHANGENRECC + S/4
MASTMaterial to BOM LinkHeader material and usage of the BOMMAST-STLNR = CDPOS-TABKEY+4(8)ECC + S/4
STKOBOM HeaderBOM header: base quantity, statusSTKO-STLNR = MAST-STLNRECC + S/4
STPOBOM ItemBOM item: component, quantity, change number, validitySTPO-STLNR = CDPOS-TABKEY+4(8) AND STPO-STLKN = CDPOS-TABKEY+12(8)ECC + S/4
STASBOM Item SelectionAlternative-to-item link and deletion indicatorSTAS-STLNR = STPO-STLNR AND STAS-STLKN = STPO-STLKNECC + S/4
AENRChange MasterChange number description and valid-from dateAENR-AENNR = STPO-AENNRECC + S/4
MAKTMaterial DescriptionsHeader material and component descriptionsMAKT-MATNR = MAST-MATNR / STPO-IDNRKECC + S/4
AFKOOrder Header Data for PP OrdersOrder header and dates for order changesAFKO-AUFNR ↔ CDHDR-OBJECTID (CDHDR-OBJECTCLAS = 'ORDER')ECC + S/4
RESBReservation/Dependent RequirementsComponent items for order changesRESB-AUFNR = AFKO-AUFNRECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_UDATEChange dateRange / multipleCDHDR-UDATEYes01.11.2026 – 15.11.2026
S_MATNRHeader materialRange / multipleMAST-MATNRNoMAM-40021
S_WERKSPlantRange / multipleMAST-WERKSNo1000
S_USERChanged byRange / multipleCDHDR-USERNAMENoMUH_AYILMAZ
P_ORDERAlso show production order changesCheckbox—NoX
P_ALERTAlert mode: email changes since the last runCheckbox—No—

Output columns

#ColumnSource
1DateCDHDR-UDATE
2TimeCDHDR-UTIME
3UserCDHDR-USERNAME
4ObjectCalculated BOM or production order (by object class)
5Header material / orderCalculated MAST-MATNR or AFKO-AUFNR
6ComponentSTPO-IDNRK
7Changed fieldCalculated CDPOS-FNAME translated into a user-friendly label
8Old valueCDPOS-VALUE_OLD
9New valueCDPOS-VALUE_NEW
10Change typeCalculated CDPOS-CHNGIND: I = added, D = deleted, U = changed
11Change numberSTPO-AENNR
12NotifiedCalculated Recipient group if an alert email was sent

Sample output

DateTimeUserObjectHeader material / orderComponentChanged fieldOld valueNew valueChange typeChange numberNotified
12.11.202609:42MUH_AYILMAZBOMMAM-40021YM-11870Component quantity46Changed500000123Planning, Purchasing
12.11.202609:44MUH_AYILMAZBOMMAM-40021HM-20455ComponentHM-20455Added500000123Planning, Purchasing
13.11.202614:05MUH_KDEMIRBOMMAM-40388HM-20102Valid from01.11.202601.12.2026ChangedPlanning
14.11.202608:17PLN_SAKSOYProduction order1004512HM-30017Requirement quantity120150Changed
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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

PP Program Custom Mass upload

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 …

MAST · STKO · STPO · MARA

PP Report Custom ALV report

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 …

PLPO · PLAS · 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: BOM Change Log Report with E-mail Alerts