User wants to check the material master changes with many materials in one go instead of one at time which is very time consuming.
Step 1:
SQ01 – InfoSet
Create InfoSet as Direct read of table: CDPOS
Step 2:
Create Extras to add table CDHDR
Link CDPOS with CDHDR as follows:
SELECT SINGLE * FROM CDHDR
WHERE OBJECTCLAS
= CDPOS-OBJECTCLAS
AND OBJECTID
= CDPOS-OBJECTID
AND CHANGENR
= CDPOS-CHANGENR
Step 3:
Create the Basic list fields you required and you are
done.
Notes:
You can refer to the pooled table TCDOB - Objects for change document creation
For example, in my query of material master changes, I have three fields as selection for the material master changes.
Fields:
Object class: You can also refer to transaction SCDO (in these example, material master object class is MATERIAL)
Transaction in which a change was: M* (refer to any changes done using MM01, MM02 etc.)
Object value: refer to your Material Master material from
tcode MM03
My Query Report-specific selections screen:
Object class
MATERIAL
Transaction in which a change was made
M*
Object value
SAP Material
