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
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
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. - . /
Only 3 steps and you are done.
