Skip to Content
Product Information

Customer/Vendor Address Data Cleansing with SAP DQM (Data Quality Management)

Every customer converting their system to SAP S/4HANA (On-Premise or Private Cloud) needs to go through the CVI process (Customer Vendor Integration) and migrate to Business Partner from the classical ECC customer / vendor data model.

The migration process to Business Partner besides the configuration part also addresses the master data quality of Customers and Vendors, as it creates Business Partner from existing data.

This part of the process usually brings up a lot of master data inconsistencies, and key among them is the address data. Correcting and solving those inconsistencies poses a significant challenge and an additional time variable to a project to any customer converting their system to S/4HANA.

Luckily there is a solution and that is called SAP DQM (Data Quality Management).

SAP Data Quality Management version for SAP Solutions (DQM for SAP) offers the below capabilities:

  • Corrects and/or validates the address based on referential data sources;
  • Formats the address according to norms of the applicable country.

Master data consistency check (transaction code CVI_PRECHK) report can use DQM to cleanse the address details and ease the system conversion process. DQM can only be called when the DQM Add-on is present in the system. Kindly go over the following note for more details on the CVI_PRECHK report: https://launchpad.support.sap.com/#/notes/2743494

As said above the DQM add-on check integrates directly to the CVI_PRECHK and helps customers identify and resolve any potential issues directly in ECC. However, the solutions to the issues uncovered by the tool are being received from the SAP Business Technology Platform as DQM besides the add-on part is actually a microservice delivered by SAP within the SAP Extension Suite*.

The picture below details how the process actually works:

 

 

Having said that DQM is currently capable of:

  • Address cleansing only for the inconsistent customers and vendors in ECC and NOT on the entire address records of ADRC
  • Execute batch call to DQM micro-service for inconsistent address records
  • Get proposals from DQM (in batch) and view the changes before committing to DB
  • Inline editing of proposal for any special cases before committing to DB
  • Address consistency check for C/V records is based on OY17 configuration
  • Default address to some standard value (per country) just to expedite the conversion (only in sandbox)

 

How does it work?

  • First step is to have all the notes needed for the CVI process as detailed in the CVI Cookbook implemented in your SAP ECC system

 

  • Second step is that we need to implement the DQM Add-on to ensure functionality with the CVI_PRECHK report.

Please check out notes

The notes above direct you to the DQM add-on install, however you also need to configure the connection to the DQM Microservice as shown in the above-mentioned diagram.

 

! Please note that to use SAP DQM Microservices you would need a subscription to SAP Extension Suite* (* together with SAP Integration Suite, the Extension Suite is previously known as SAP Cloud Platform). If you do not know if you already have an appropriate license, please contact your account manager from SAP to get information on how to get an ability to use SAP DQM Microservice. You can find more information on SAP DQM Microservice, it’s service plan as well as further services of Extension as well as Integration Suites in SAP Discovery Center: SAP DQM Microservice.

 

In order to facilitate the entire installation (add-on install and establishing the appropriate connection) please get in contact with your technical resource and kindly go through the steps provided in this guide:  https://help.sap.com/viewer/bc498e07313f4195be1d53104b03b2cf/4.1/en-US/0cd8860ec0334163ab4c1852e78ac4d2.html

 

  • Third step is to run the CVI_PRECHK and assess what errors we have and how can DQM help us in fixing them. For this let’s go through the steps and screenshots below:

 

  1. Go to Transaction CVI_PRECHK and select all relevant Business Checks(the Address checkbox is mandatory for this exercise) based on the entity you wish to search (as an example Customer), and of course press Execute

 

2. Please click below the RUN ID the line below as the

   

 

3.  We are now presented with all the master data errors that need fixing from the Customer side.

! Please note that we are looking at a SAP demo system!

 

 

If we look more closely, we can differentiate between the kind of errors we can get help from DQM, for example:

 

4.   As we have a lot of errors in our system, we need to only select the Address ones, therefor the next step is to click on the edit button and on the Address option

 

5.  As soon as we click on the Edit—Address we immediately see that the fields are now editable:

 

! Please pay close attention to Column Adr Ch.!

The different statuses are:

C – Validated address. DQM was able to validate and correct the address.

D – Invalid address. DQM was not able to validate the address due to multiple or no address suggestions. You need to correct the address manually.

Blank – Address not validated by DQM. You need to correct the address manually.

We can only correct address data that has either a Blank or a D .

 

6.   We are now at phase of correcting the data, therefor let us select for example second line and click on Fix Ambiguous Address

 

 

We are prompted with a pop-up, where we need to push Next:

 

 

We are now presented with possible address; therefore, we need to select one and click on Select

 

Right now, we are almost done with the address correction, however we are prompted again with a pop-up showing us the changes we made and giving us the options to proceed, and if everything is ok Accept the Validate Address

 

 

After accepting the proposed address, we can now the status of the line has changed from D to C (Validated Address):

 

 

We can now move on to the next issue and fix it. Of course, we also have the option to Mass Populate by selecting more or all objects and click on:

 

 

The example above was just one of the many possible issues we might encounter that need to be corrected before the Business Partner Synchronization, and with the help of DQM the process is much easier than before.

In conclusion one of the most difficult variables of the CVI to assess and fix has now been addressed with the SAP DQM Microservices which not only identifies the address issues, but also corrects it.

Leveraging this service offering will not only give you peace of mind from a Conversion Project perspective and timeline, but it will also eliminate a possibly substantial risk and extensive work and resource planning in manually correcting master data.

 

As a final point please be aware that implementing the DQM Add-on could also trigger address checks during new Customer/Vendor creation via the XD/XK transactions. Thus, please pay very close attention when installing the add-on and using it in a live system. Always test any new implementation first in a sandbox or development system.

 

Thank you for reading and please stay tuned for upcoming updates.

5 Comments
You must be Logged on to comment or reply to a post.
  • Hi Dorin,

    Great blog. we have S/4 HANA without MDG Activated. I understand that with DQM microservice address cleansing can be done. How does DQM know what is the correct address. When clients get

    DQM add on is that mean the libraries(Containing standard address) is part of it or we need to buy

    address libraries from external source and integrate with DQM micros service.

     

    Thanks

    Geetha

    • Hi Geetha,

      Thank you for your feedback.

      However this blog and the DQM Add-on and DQM Microservice is tailored towards customers moving from SAP ECC to S/4HANA in a Brownfield(conversion) approach.

      The DQM Add-on does not come with any libraries as the Address Proposal will be delivered via the DQM Microservice(for more information please read carefully the Bold text right in the beginning of this blog). Therefor the DQM Add-on is to be a connection point between the CVI_PRECHK transaction and the DQM Microservice.

      Hope this clarifies the concept a bit.

      Let me know if you have any other questions.

      Best Regards,
      Dorin

      • Hi Dorin,
        Thanks for the information. The current client does not use SAP MDG and use a third party MDG to create third party supplier.
        1.In current S/4 they want to know when they create all other suppliers(like carrier, manfacturing supplier) and customers is there a way to correct and validate the address. In your blog you have mentioned corrects and/or validates the address based on referential data sources.
        so you mean DQM can connect to external sources and if so can you please guide to a good blog. what kind of data sources are available and how to connect to DQM in S4 hana.

        2. How to detect duplicates during Business Partner creation in S4. In earlier projects we used TREX. but now it is not clear what SAP recommends for detecting duplicates during BP creation without SAP MDG activated.

        3. My client will be interested on DQM Microservice as they are migrating from ECC to S/4 .
        Based on the information DQM micorservices does address cleansing when connected via DQM Add on. Can we know for what countries DQM address cleansing works.
        I see this sap help website
        https://help.sap.com/viewer/product/ADDRESSING_DIRECTORIES/2021.04/en-US
        we can download all address directories from SAP itself. If so, why should clients pay and use DQM Microservice when SAP provides address directories downloadable for free. If I can articulate the use of DQM micorservice over free download then client will be interested in trying.

        would appreciate if you can please provide any info as this will not only help me but to all consultants who are analyzing.

        Once again thanks
        Geetha.

        • Hi Geetha,

          Thank you for your reply.

          The SAP DQM Microservice was designed to help customers in the address cleansing in their move to SAP S/4HANA and to provide an aid within the SAP RISE movement. For price/licensing questions kindly get in touch with the SAP Account Manager as there are several possibilities to access and use SAP DQM Microservices.

          The above blog was designed to offer customers an insight on how they could tackle the address cleansing issues that they may face within a Conversion/Brownfield Implementation method in their move to SAP S/4HANA, based on the results gathered from the Readiness Check and then the CVI_PRECHK transaction.

          Moreover the questions asked by you are from a consulting/services perspective and as I do not have an analysis of what is the ask I unfortunately cannot answer them. For more clarity kindly submit a service request to SAP for the challenges faced and I am sure your customer will get the needed answers and guidance.

          Thank you and best regards

          Dorin