HI GUrus,
Can anybody please throw some ideas on how to approach this problem. We have about 7500 MRO items in plant 1, 7000 MRO items in plant 2 and 6500 in plant 3 and 8000 in plant 4. There are duplicate material numbers in these plants. Meaning to say that there are materials which are same but the part numbers are different. How can we clean this up. The bottom line is the consolidation of all the materials across the 4 plants.
Thanks
Anusha