Material Master Change Log Report by Field and User
Short answer: A custom ALV report that lists material master changes for many materials by date, user, transaction, table and field, with old and new values. In an audit it answers questions such as "who changed the valuation class last quarter" in one run.
- Estimated effort
- S · 2–4 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MM04 shows the change documents of one material. It does not list collectively how a given field (for example price control, MRP type, purchasing group) changed across all materials, for a given user or date range. SCU3 only helps for customizing tables with table logging switched on. Audit requests are therefore extracted by hand from CDHDR/CDPOS with SE16.
Who uses it? Master data teams, internal audit and internal control teams, MM and FI consultants.
Closest standard alternatives
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: date, time, user and transaction (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 |
| MARAGeneral Material Data | Material type filter | MARA-MATNR = CDHDR-OBJECTID | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = MARA-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| DD03LTable Fields | Data element of the changed field | DD03L-TABNAME = CDPOS-TABNAME AND DD03L-FIELDNAME = CDPOS-FNAME | ECC + S/4 |
| DD04TData Element Texts | Field description (logon language) | DD04T-ROLLNAME = DD03L-ROLLNAME AND DD04T-DDLANGUAGE = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_MATNR | Material | Range / multiple | MARA-MATNR | No | RM-1001 |
| S_MTART | Material type | Range / multiple | MARA-MTART | No | ROH |
| S_UDATE | Change date | Range / multiple | CDHDR-UDATE | Yes | 01.07.2026 – 30.09.2026 |
| S_USER | Changed by | Range / multiple | CDHDR-USERNAME | No | MDATA01 |
| S_TCODE | Transaction | Range / multiple | CDHDR-TCODE | No | MM02 |
| S_TABNM | Table | Range / multiple | CDPOS-TABNAME | No | MBEW |
| S_FNAME | Field name | Range / multiple | CDPOS-FNAME | No | BKLAS |
| P_NOINS | Exclude create entries | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Date | CDHDR-UDATE |
| 2 | Time | CDHDR-UTIME |
| 3 | User | CDHDR-USERNAME |
| 4 | Transaction | CDHDR-TCODE |
| 5 | Material | MARA-MATNR |
| 6 | Description | MAKT-MAKTX |
| 7 | Material type | MARA-MTART |
| 8 | Table | CDPOS-TABNAME |
| 9 | Field | CDPOS-FNAME |
| 10 | Field description | Calculated DD04T-SCRTEXT_M (through DD03L-ROLLNAME) |
| 11 | Org key | Calculated Plant, valuation area, storage location or sales organization parsed from CDPOS-TABKEY |
| 12 | Change type | CDPOS-CHNGIND |
| 13 | Old value | CDPOS-VALUE_OLD |
| 14 | New value | CDPOS-VALUE_NEW |
| 15 | Change number | CDHDR-CHANGENR |
Sample output
| Date | Time | User | Transaction | Material | Description | Material type | Table | Field | Field description | Org key | Change type | Old value | New value | Change number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 08/12/2026 | 10:42:15 | MDATA01 | MM02 | RM-1001 | Carton box 40x30 | ROH | MBEW | BKLAS | Valuation class | 1000 | U | 3000 | 3001 | 0000418822 |
| 08/19/2026 | 15:03:51 | PLAN02 | MM02 | RM-2040 | Steel sheet 2 mm | ROH | MARC | DISMM | MRP type | 2000 | U | PD | VB | 0000419307 |
| 09/02/2026 | 09:17:08 | SATIN03 | MM02 | SP-7720 | Bearing 6205 | ERSA | MARC | EKGRP | Purchasing group | 1000 | U | 001 | 002 | 0000420114 |
| 09/24/2026 | 17:55:40 | MDATA01 | MM02 | FG-5003 | Paint set of 4 | FERT | MBEW | VPRSV | Price control | 1000 | U | V | S | 0000421560 |
How does the report work?
- CDHDR is read for object class MATERIAL with the date (UDATE), user (USERNAME) and transaction (TCODE) criteria; the material filter is applied to the object key (OBJECTID).
- For each change number the CDPOS lines are read: table (TABNAME: MARA, MARC, MARD, MBEW, MAKT, MVKE etc.), field (FNAME), change type (CHNGIND) and old / new value.
- The table key (TABKEY) is parsed per table, and the plant, valuation area, storage location or sales organization is shown in its own column.
- The field description is taken in the logon language from DD04T through the data element in DD03L.
- The material type is added from MARA and the description from MAKT; the material type and field filters are applied. With “exclude create entries” selected, lines with CHNGIND = I are skipped.
Performance notes
Always read CDHDR with the object class and a date range, and read CDPOS only for the change numbers found, through its key fields (OBJECTCLAS, OBJECTID, CHANGENR). For long periods, run the report in the background; CDPOS is a very large table.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the material opens MM03.
- Export to Excel Can be exported to Excel for audit.
- Runs as a background job
Authorization objects
- M_MATE_MARMaster data display authorization by material type
- M_MATE_WRKMaster data display authorization by plant
Frequently asked questions
Do mass changes (MM17) and upload programs appear as well?
Yes. Every process that writes change documents leaves an entry in CDHDR/CDPOS. The transaction column shows whether the change came from MM02, MM17 or an upload program.
Does it work with the long (40-character) material number?
Yes. The object key and table key are parsed according to the material number length in the system; the 40-character number in S/4HANA is supported.
Does the report delete or change change documents?
No, it only reads. Change documents are an audit trail, so the report works with read-only authorization.
Related reports
Mass Material Master Upload Program
A custom program that creates or updates material master data in bulk from Excel or CSV rows, including the basic data, plant and valuation views. It …
Stock Aging Report
A custom ALV report that shows how many days each material has been in stock since its last goods receipt and which age bucket (0–30, 31–90, 91–180, …
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.