MM Report Custom development ALV report

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

  • MM04 Display Material Change Documents. Shows the change documents of one material; gives no collective list by field or user.
  • SCU3 Table History. Shows changes to tables with table logging switched on; does not cover material master change documents.

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: date, time, user and transaction (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
MARAGeneral Material DataMaterial type filterMARA-MATNR = CDHDR-OBJECTIDECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = MARA-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
DD03LTable FieldsData element of the changed fieldDD03L-TABNAME = CDPOS-TABNAME AND DD03L-FIELDNAME = CDPOS-FNAMEECC + S/4
DD04TData Element TextsField description (logon language)DD04T-ROLLNAME = DD03L-ROLLNAME AND DD04T-DDLANGUAGE = SY-LANGUECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_MATNRMaterialRange / multipleMARA-MATNRNoRM-1001
S_MTARTMaterial typeRange / multipleMARA-MTARTNoROH
S_UDATEChange dateRange / multipleCDHDR-UDATEYes01.07.2026 – 30.09.2026
S_USERChanged byRange / multipleCDHDR-USERNAMENoMDATA01
S_TCODETransactionRange / multipleCDHDR-TCODENoMM02
S_TABNMTableRange / multipleCDPOS-TABNAMENoMBEW
S_FNAMEField nameRange / multipleCDPOS-FNAMENoBKLAS
P_NOINSExclude create entriesCheckbox—NoX

Output columns

#ColumnSource
1DateCDHDR-UDATE
2TimeCDHDR-UTIME
3UserCDHDR-USERNAME
4TransactionCDHDR-TCODE
5MaterialMARA-MATNR
6DescriptionMAKT-MAKTX
7Material typeMARA-MTART
8TableCDPOS-TABNAME
9FieldCDPOS-FNAME
10Field descriptionCalculated DD04T-SCRTEXT_M (through DD03L-ROLLNAME)
11Org keyCalculated Plant, valuation area, storage location or sales organization parsed from CDPOS-TABKEY
12Change typeCDPOS-CHNGIND
13Old valueCDPOS-VALUE_OLD
14New valueCDPOS-VALUE_NEW
15Change numberCDHDR-CHANGENR

Sample output

DateTimeUserTransactionMaterialDescriptionMaterial typeTableFieldField descriptionOrg keyChange typeOld valueNew valueChange number
08/12/202610:42:15MDATA01MM02RM-1001Carton box 40x30ROHMBEWBKLASValuation class1000U300030010000418822
08/19/202615:03:51PLAN02MM02RM-2040Steel sheet 2 mmROHMARCDISMMMRP type2000UPDVB0000419307
09/02/202609:17:08SATIN03MM02SP-7720Bearing 6205ERSAMARCEKGRPPurchasing group1000U0010020000420114
09/24/202617:55:40MDATA01MM02FG-5003Paint set of 4FERTMBEWVPRSVPrice control1000UVS0000421560
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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).
  2. 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.
  3. The table key (TABKEY) is parsed per table, and the plant, valuation area, storage location or sales organization is shown in its own column.
  4. The field description is taken in the logon language from DD04T through the data element in DD03L.
  5. 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

MM Program Custom Mass upload

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 …

MARA · MAKT · MARC · MBEW

MM Report Custom ALV report

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, …

MARD · MARA · MAKT · MBEW

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: Material Master Change Log Report by Field and User