Deleting old/unsued/junk Master Data in Production

[Former Member]

Hi Gurus:

Please let me know the most efficient way to clean up old/unused/junk Master Data.

My client has a master data that is virtually used in all the cubes & has 8 million records in it.

What would you suggest - the best method to clean up

I have an idea - what we craete a new Master Data object & then in update rules we mention what can go into the object, and then do full load from R/3 to the new info object. Will this approach be good?

Please let me know...Thanks & Regards

[Former Member]

Hello,

> If the values of the InfoObject are a part of transaction data in any data target, the system will not let you delete it.

> You can reload the master data and then run the attribute change run. This will over write all the old data with new data from Production.

> You can do this in RSA1 > Tools > Apply Hier/Attr change. Click on InfoObject List and see if you char is there.

> If there is no new master data then there is nothing for the system to activate. As for the old records: If they are stored as transactional data in a data target, the system will not let you delete the entries.

Hope the above points help to solve your problem

Thanks

VArun