Any master data cleanup menas you are checking the dead data or wrong entry in the data etc.
One way to check your vendors acitivity is to execute MC$4 for a certain period.
Among all you will find vendors having only zero amount in the analyzed period.
These a possible candidates for cleansing.
Further I would download the result to Excel, as well as all your vendors.
Then I would x-check which vendors did not even have a zero entry - did not appear at all- in the MC$4 report.
A) You can know the list of active vendor through transaction MC$4 wherein you can give the period say 2 years to find out list of vendor on which PO were raised.
B) To find out duplicate vendors you can very well use the tool SAP MDM which is specifically used to find duplicate master records.
SAP MDM helps in following ways
• Delivers a single version of the truth for customers, suppliers, products, employees and user designated objects
• Provides capabilities to share this single version of the truth internally and externally with partners
• Leverages existing IT investments in business-critical data
• Accelerates and improves the execution of business processes
To delete vendors from source list you have two options.
a) if you want to delete a vendor for supplying a particular material then you have to go to a source list of that material & block vendor from that list
b) If you want to delete a vendor from the system then go to transaction MK 06 & you can delete the vendor from the system.
I hope this will clarify your doubts.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.