Skip to Content
Author's profile photo Former Member

How to Prepare for and Perform Master Data Cleanup

Master Data Cleanup Utility

How to Prepare for and Perform Master Data Cleanup

Introduction

You can use the Master Data Cleanup wizard to remove or deactivate data in SAP Business One Data can be business partners, item master data, G/L accounts, project codes, cost centers, distribution rules, and tax codes.

With the Master Data Cleanup wizard, you can perform the following tasks:

  • Initiate a master data cleanup wizard run

When the master data cleanup wizard run is complete, a certain amount of data is permanently removed or deactivated from the database. This action is irreversible

Note

You are required to back up the data base before any data is removed. I f needed, you always can restore the backup file, review the database, generate reports, and print documents.

  • Load a saved data cleanup wizard run

All data cleanup wizard runs are saved. You can view any master data cleanup wizard run executed in the past and check whether a specific document is included in a master data cleanup wizard run.

What Data is Removed or Deactivated?

The following table lists the database objects that you can remove or deactivate during the data cleanup process. The table is followed by a detailed explanation about the removal guidelines for each type of master data.

Financials

G/L Account – You can cleanup G/L accounts that are not connected to any nonremovable data. G/L accounts with the status Inactive can be removed but not deactivated. If you select items or business partners for removal, connected G/L accounts are recommended for removal.

VAT Groups – You can cleanup VAT groups that are not connected to any nonremovable data. VAT groups with the status Inactive can be removed but not deactivated.

Cost Center – You can cleanup cost centers that are not connected to any nonremovable data, unless they are system cost centers. Cost centers with the status Inactive can be removed but not deactivated. If you select distribution rules for removal or deactivation, connected cost centers are recommended for removal or deactivation accordingly.

Distribution Rule – You can cleanup distribution rules that are not connected to any nonremovable data. Distribution rules with the status Inactive can be removed but not deactivated. If you select G/L accounts for removal, connected distribution rules are recommended for removal.

Project Code – You can cleanup project codes that are not connected to any nonremovable data. Project codes with the status Inactive can be removed but not deactivated. If you select G/L accounts or business partners for removal, connected project codes are recommended for removal.

Sales Tax Code – You can cleanup tax codes that are not connected to any nonremovable data. Tax codes with the status Inactive can be removed but not deactivated. If you select G/L accounts, items, or business partners for removal, connected tax codes are recommended for removal.

Business Partners

Business Partner – You can cleanup business partners that are not connected to any nonremovable data. Business partners with the status Inactive can be removed but not deactivated. If you select items for removal, connected business partners are recommended for removal.

Inventory

Item – You can cleanup items that are not connected to any nonremovable data. Items with the status Inactive can be removed but not deactivated.

Removing or Deactivating Data

This chapter explains how to perform a master data cleanup wizard run. At the end of this process, a certain amount of data is permanently removed from or deactivated in the company database. 

Prerequisites 

You have made all the relevant preparations as detailed in the How to Prepare for Data Cleanup chapter.

There are no other users logged on to the company database.

Procedure 

1. From the SAP Business One Main Menu, choose Administration → Utilities → Master Data Cleanup Wizard. In the Introduction to Master Data Cleanup window, choose the Next button.

2. In the Wizard Options window, select the Start New Master Data Cleanup Run radio button and choose the Next button

3. In the Master Data Cleanup Selection window, specify a unique name for this data cleanup run.

Note

By default, SAP Business One assigns to each Master Data Cleanup wizard run a unique name based on the following formulation: Database name_data cleanup wizard run sequential no._run date If you choose to specify a different name, the name must be unique and can consist of up to 100 alphanumeric characters.

You can specify the types of data to remove or deactivate by selecting the corresponding check boxes. To continue, choose the Next button.

4. You can use the following windows to remove or deactivate master data.

If you specify to cleanup item master data, the Item Master Data Cleanup Selection window appears.

The following table lists the fields in the Item Master Data Cleanup Selection window.

The Item Master Data Cleanup Recommendations window displays the results of the database analysis by SAP Business One. This window indicates which item master data can be removed or deactivated and which cannot.  Select the items you want to cleanup and choose the Next button to continue.

The following table lists the fields in the Item Master Data Cleanup Recommendations window.

The following table lists the fields in the Business Partner Cleanup Selection window.

The following table lists the fields in the G/L Account Cleanup Selection window.

The following table lists the fields in the Project Code Cleanup Selection window.

The following table lists the fields in the Distribution Rule Cleanup Selection window.

The following table lists the fields in the Cost Center Cleanup Selection window.

The following table lists the fields in the Tax Code Cleanup Selection window.

5. The Save & Execute Options window appears. To save the data cleanup wizard run, select the Save Parameter Set and Exit radio button and choose Finish. To remove or deactivate data, select the Execute radio button and choose the Next button to continue.

6. The Progress Bar window appears, providing you with an overview about the upcoming process. To continue, choose the Next button.

7. Once the process is complete, the Master Data Cleanup Summary window appears. This window displays an overview of the main results of the data cleanup. To continue, choose the Next button.

8. A window appears informing you the master data cleanup completed successfully. To complete the data cleanup process, choose the Finish button.

Loading Saved Data Cleanup Runs

You can load master data cleanup wizard runs to do the following:

  • Track documents that are removed or deactivated
  • Examine each step of previously executed master data cleanup runs
  • Modify and execute saved master data cleanup runs The following procedure describes how to load master data cleanup runs. 

Procedure

1. From the SAP Business One Main Menu, choose Administration → Utilities → Master Data Cleanup Wizard. In the Introduction to Master Data Cleanup window, choose the Next button. 

2. In the Wizard Options window, select the Load Saved Master Data Cleanup Run radio button. A table listing all saved master data cleanup wizard runs appears.  Click the row of the master data cleanup wizard run you want to load and choose the Next button.

The following table lists the fields in the Wizard Options window

https://websmp108.sap-ag.de/smb/sbocustomer/documentation

Regards,

Marcelo Silva Santos

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      What a useful post. Thanks for sharing. We are just implementing SAP and I suspect we may need to use this facility once we go live to make sure all data is good.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Accurate and in environment where there is data replication that for some reason are not being used. Thanks!

      Author's profile photo Former Member
      Former Member

      Hi we are new to SAP where can we find this application this can help a lot to clean our deactivated and error master data

      Author's profile photo Yeshwanth Prakash Thoguluva Seshadri
      Yeshwanth Prakash Thoguluva Seshadri

      HI,

       

      Once the clean up is done, there is history of all the master data stored in the history table. this stores all the master data that are cleaned up. So even of the master is removed from the data tables, there is no reduction in the DB size as there is history of all the master data created since the creation of DB.

       

      Is there any way to clean those history tables???

       

      regards,

      Yeshwanth

      Author's profile photo Former Member
      Former Member

      Hi, I am new to this master data cleaning wizard.  Thank you for your blog, it really helpful for me. I tried this and really helped me with wiping the unused BP that already imported to new system.

      I need some tips on running this utilities, my question is regarding about backing up database before running the wizard:
      - how long do I need to run the wizard after the database has been backed up? since I don't have the authorization to access database, my IT manager does. It really helps me to know the timing, since I need to arrange with my IT manager, because I think last time my manager ran the backup, there was like more than 1 hour after that, and the wizard asking to backup the database, please correct me if I'm wrong
      - Is there anyway to run this wizard without having to backup the database every time?

      Thank you very much for your help, much appreciated.

      Regards,
      Ichsan