Data Cleansing

[Former Member]

Hi Everybody,

Please,Can anybody let me know what is meant my Data Cleansing in SAP?

Points will be rewarded.

Regards

Pradeep Belur.

[former_member922475]

Hi Pradeep,

I always recommend to cleanse the data by using an ongoing approach. This helps to reduce the effort to migrate the data to other systems or releases like S/4. It also reduces the hardware requirements (especially when using cloud based solutions). For more details you could check e.g. www.data-cleansing-check.de - if you search in Google you will also find other offers which support the data migration approach.

Thanks

Alfred

[Former Member]

The data cleansing requirement will take place, while move the data from legacy system to new target ERP / system. I.e. need to cleanse, enrich, de-duplicate, & standardize.

The existing data may not have consistent format since it is often being derived from various sources. It may contain duplicate information as well missing or incomplete information. Cleanse and normalize content to achieve accuracy, consistency and proper understanding of the data.

Also it’s a process of organizing the data, which will ensure enrichment of your data which are up-to-date, accurate, and complete. These processes are manual / labor intensive and require a fair bit of specialization.

If you need to have more details please feel free to interact with us as per below.

Thanks

Kumar

www deebrostech.com

[Former Member]

Dear Pradeep Belur,

Data cleansing allows you to compare, include and merge redundant business partner master records (potential duplicates) in data cleansing cases. Following the data cleansing process you can remove data records from the system using archiving.

Integration

Before you can carry out data cleansing, you must determine the redundant data in your system and include it in data cleansing cases.

You have the following options for duplicate recognition and creation of data cleansing cases.

The Business Address Services (BAS) provide interfaces for integrating the relevant external software (search machines).

User-defined programs

Services of data providers, who check their data for possible duplicates.

In the options described above, the data cleansing cases are created via the system and put into the data cleansing worklist for further processing.

In individual cases you can find potential business partner duplicates in the hitlist of the business partner search and create a separate data cleansing case.

After connecting the non-SAP software (search engines), the system starts duplicate recognition (Delta Scan) with every change to or new entry of a business partner for this specific individual record. You should do a full scan through the complete dataset at the beginning of the consolidation process using the non-SAP software, this registers all potential duplicates in data cleansing cases and makes them available or further processing.

Within the application basis, the referencing objects, which are taken into account by the data cleansing, are limited to the sub-objects of the business partner. You have the possibility to make modification-free enhancements to the referencing objects.

Prerequisites

You must have determined the redundant data records in your system.

To use the interface of the Business Address Services, make the following Customizing settings: SAP Implementation Guide -> Basis -> Basis Services -> Address Management -> Activate Duplicate Check Index Pool

Make the following system settings in the IMG of the SAP Business Partner: Basic Settings -> Data Cleansing -> Maintain Number Range / Define Priorities / Activate Data Cleansing.

Activities

Register data cleansing cases via BAPIs or create them in the dialog for business partner maintenance from the worklist or the business partner search.

Process the created data cleansing cases in a separate process step afterwards.

Do let me know in case of any queries.

Hope this helps you.

Do award points if you found them useful.

Regards,

Rakesh

[Former Member]

Your data should be cleansed before importing into a new system. ultimately it should be cleansed before and after any data is imported into your system from an outside source, and vice-versa if you are putting your data into any other outside source. (we don't know what kind of systems that data has been in, now do we ?) At the very least, if not cleansed, it should at least be protected by some encapsulation coverage to keep any bad, outside viruses or bugs off of it.

Due to the delicate nature of data, cleansing should be performed with a mild detergent solution. Data is, at it's most basic level, comprised of 0's and 1's. Using a small toothbrush can be effective on the 1's, but can be difficult to thouroughly clean out the inside of those nasty 0's. You can wrap a small towellete around the 1's and use it to clean out the inside of the 0's. A gentle in-and-out motion with a slight twisting should do the trick

[Former Member]

Hi Pradeep,

Data cleansing allows you to compare, include and merge redundant business partner master records (potential duplicates) in data cleansing cases. Following the data cleansing process you can remove data records from the system using archiving.

[Former Member]

Hi,

It essentially means master data cleansing such as removal of redundant material master / customer master / vendor master data, updating and correcting excise master data etc. This is necessary because, despite controls, over a period of time we tend to accumulate lot of muck which needs to be cleared for smooth functioning and optimum system utilization.

This can happen in an already functioning SAP environment or during migration from legacy systems to SAP.

Muraleedharan.R