Skip to Content
0
Former Member
Dec 06, 2010 at 04:11 PM

List of Unused Master Data

103 Views

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