Material Master Changes List Using SAP Query

How to list out the material master changes using SQ01?

One of our business user make a request whether can they see the changes of the material master using multiple materials without requiring any ABAP development effort.

I gave it tried and noticed that SAP Query does not allowed Cluster table to be join with Transparent table.  This becomes an issue as you need both table CDHDR and CDPOS to be join together before you can extract the change documents.

After various trial and error, I managed to create the Material Master Changes query with tcode SQ01

Step 1: Create the InfoSet with the Option Direct read of table: CDPOS

Cluster Table        CDPOS 
Short Description  Change document items

Cluster Table CDPOS

Step 2: Don't use Join table, instead click Extras to create the table CDHDR.
Then manually copy and paste the three CDPOS key fields as follows:

Transp. Table       CDHDR   
Short Description  Change document header

CDPOS-OBJECTCLAS - Object class
CDPOS-OBJECTID             - Object value
CDPOS-CHANGENR         - Document change number

Transparent Table CDHDR

Step 3: Create the Query Basic List with the fields you want to display and you are done.

CDPOS-OBJECTCLAS - When you input "MATERIAL", it select only the Material Master data

CDHDR-TCODE - Here I input "M*" because I want to list out all the tcodes starting with M.
Example of tcodes that were listed:
MM02
MM02(RMDATIND)
MM02(MASS)

CDPOS-OBJECTID - This refer to the Material Code.  If your company used masking for the material code, you need to Remove the Masking Sign in the Material e.g. - . /

Material Master Changes List Using SAP Query

Only 3 steps and you are done.

ABAP Tips

Read Also
Query To Extract PO Specific Condition Type

Get help for your ABAP problems
Do you have a ABAP Question?

ABAP Books
ABAP Certification, BAPI, Java, Web Programming, Smart Forms, Sapscripts Reference Books

More ABAP Tips

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.