Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Data cleansing

Former Member
0 Kudos

Hi Gurus,

What is meant by Data cleansing?

Thanks in Advance.

Shahana.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

hi

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.

http://help.sap.com/saphelp_crm40/helpdata/en/35/16dc2c1f9911d6b1d200508b5d5211/content.htm

http://mitiq.mit.edu/Documents/IQ_Projects/May%202004/DQ%20Assessment_FUZZY.pdf#search=%22DATA%20CLE...

Regards,

Reshma

5 REPLIES 5

Former Member
0 Kudos

hi

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.

http://help.sap.com/saphelp_crm40/helpdata/en/35/16dc2c1f9911d6b1d200508b5d5211/content.htm

http://mitiq.mit.edu/Documents/IQ_Projects/May%202004/DQ%20Assessment_FUZZY.pdf#search=%22DATA%20CLE...

Regards,

Reshma

Former Member
0 Kudos

Check out

Former Member
0 Kudos

<b>Data Cleansing </b>

Use

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.

Regards,

Pavan.

Former Member
0 Kudos

Hi,

<u>Use</u>

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.

<u>Integration</u>

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.

http://www.sap-press.com/product.cfm?account=&product=H956

http://help.sap.com/saphelp_nw2004s/helpdata/en/8d/3e4ad6462a11d189000000e8323d3a/frameset.htm

http://help.sap.com/saphelp_crm40/helpdata/en/35/16dc2c1f9911d6b1d200508b5d5211/content.htm

http://mitiq.mit.edu/Documents/IQ_Projects/May%202004/DQ%20Assessment_FUZZY.pdf#search=%22DATA%20CLE...

REgards,

Padmam.

Former Member
0 Kudos

Hi,

<b>Use</b>

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.

<b>Integration</b>

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.

<b>Prerequisites</b>

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.

<b>

Activities</b>

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.

http://help.sap.com/saphelp_crm40/helpdata/en/35/16dc401f9911d6b1d200508b5d5211/content.htm

Regards

Sudheer