item location duplicates

Hello,

In our DM instance, we have a ton of item location duplicates in MDP_MATRIX and SALES_DATA

Can some one pls guide me on how to remove item+location id combinations?

I am trying out a method, to clean up  (but this is going to be one by one)

Does any one have a script to delete item+location duplicates ?

Any ideas ?

Our Sales_Data has 45 million junk entries owing to the above issue

thanks for your support !!!

Vishy

+91 9686526194