Skip to Content
author's profile photo Former Member
Former Member

Data Cleansing


Does the cleansing of Master Data Objects in MDM take place only during the initial upload to the Content Integrator ?

Do we use data cleansing in any other place ?

Also what exactly cleansing does. Duplicate removal seems to be a seperate service in MDM. If duplicate removal is not cleansing what exactly is cleansing ?

Can anybody please help me out or point me to some documents in SAPNET where I can find more information ?

With Best Regards,


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Apr 02, 2004 at 08:42 AM


    Let me try and give you an explanation of how the term "cleansing" is used within the SAP MDM 2.0 context.

    Cleansing is used as a general term which basically describes two things:

    1. The determination of identical objects within the application system landscape.

    In this context, the Content Integrator is the key component used to determine identity

    by providing ID mapping information (object <i>A</i> in system <i>1</i> = object <i>B</i> in

    system <i>2</i>).

    This knowledge is the basis for subsequent global reporting.

    2. Merging records into an MDS object

    In addition to what has been described above, identical master data objects will be compared, the relevant attributes recollected by taking the "best of two worlds" and merged into one object which is posted as central MDS object. This new central master data record and the relevant information contained therein will be distributed back to the relevant application client systems.

    This leads to an overall quality improvement (harmonization) of master data in the application system landscape.

    For an overview of the scenarios and process flows within SAP MDM 2.0, see the Service Marketplace, alias <i>MDM</i>. In the <i>Related links</i> box, click <i>Installation & Upgrade Guides</i>. On the page displayed, navigate in the tree as follows: (<i>SAP NetWeaver</i> -> <i>SAP NetWeaver in Detail</i> -> <i>Solution Lifecycle Managemment</i> -> <i>Installation</i> -> <i>SAP Components</i> -> <i>MDM</i> -> <i>MDM 2.00</i>. Here you'll find the Business Scenario Descriptions for the core MDM scenarios.

    In the MDM 2.0 context, cleansing processes take place within initial and delta loads from the client systems. (A delta load is required when master data are created or changed in a client system.)

    For information on the removal of real duplicates in a client system (R/3), see the Service Marketplace, alias <i>SLO</i>.

    Hope this helps.



    Message was edited by: Markus Ganser

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.