Dear Gurus,
my task is to create a list of those Customer / Vendor / Material master data, that have been used in the last six months. (Usage means orders posted against, or for materials: issued or received.)
Only the numbers are important! (eg. 65% of ALL Vendor master data has been used in the last 6 months, 35% not.)
First I tried to find standard transactions for the same purpose, but I didnt get far...
For Vendors I have found MC$4 transaction, that is checking PO value per vendors on a certain period. This seems to be a good pick.
For Materials I tried MCBE. With this one I am regularly getting timeout, since MARA contains 102.000 materials, while MCBE deals with maximum 12.000 hits a time. Any better alternative? In fact if I could exclude those with 0 received/issued quantity, and get a list of the rest, that would be great.
For Customers - I dont know how to proceed. (I would need something like MC$4 for Vendors.)
Do you have any alternatives for the above (especially Material & Customer)?
Please advise. Any help is very appreciated!
Thanks,
Marton