Vendor master data cleansing

[#1]

Hi Experts,

I need to find a way to do vendor master data cleansing because we have duplicates and corrupt data in the system. We have no tool (not SAP MDM or any third-party tool) and number of vendors is too big (around 22000) so we can't do in manually (with excel or access).

Can you please help me with advice how to do it, do you have any suggestions?

I am particulary interested in data cleansing criteria, do you have any documents which describe criteria used to clean data?

Thanx in advance.

Ivana

[michael_theis]

Hi Ivana,

Main components of data cleansing is the search for and identification of possible duplicates. SAP MDM is a tool that can support you with this task. If you do not use MDM (or any other tools), you sould have a look at the capabilities of yours system. Maybe your system contains a functionality that can help you to identify duplicates.

Data cleansing criteria does always depend on the existing data. Useful criteria for vendor master data is the vendor name, the vendor address, and - if available - any unique data segments (like VAT numbers, DUNS number, and so on). you should check your data which segments you can use for cleansing. If your vendor data is very poor within the address segments, it makes no sense to use the address data for cleansing. So it is very hard to give a detailed suggestions how cleansing criteria has to look like.

BR Michael