Skip to Content
Technical Articles
Author's profile photo Anirban Roy

MDG DQM: Empowering Your Business with High-Quality Data in S/4HANA

Hi All,

As organizations embark on the journey of digital transformation and re-discovering their business processes,at the heart of this transformation is the master data. Most of the organizations miss to capture valuable insights in their businesses due to lack of master data quality, starting from supplier records, customer records, product data etc.

INTRODUCTION

SAP already has a robust solution in the MDM space which is SAP MDG, and from S/4 HANA 1909 SAP came up with a solution of data quality management which can be integrated along with the governance of the master data. This solution will provide insights about the current data quality in the system and will help organizations cleanse their master data.

In this blog post we will look at how to create data quality quality rule for product master and run data evaluations based on this rules and see how the data quality dashboards looks like in FIORI.

MDG%20DQM%20process%20flow

MAIN CONTENT

1.At the outset we need to provide access to the role SAP_BR_PRODMASTER_STEWARD, activate the Odata services and SICF nodes to start working with the below tiles in FIORI.

Fiori%20group

Fiori group

2. Click on validation rules( products ) and create a new rule. You will have to provide the rule ID, a rule name, base table on which the rule will be applied.

Rule%20creation%20fields

Rule creation fields

3.Once the rule is created it’s status will be “NEW” and you can add usage for this rule. The usage of the rule implies whether the rule can be used in change request request processing, consolidation& mass processing and data quality evaluation. In this blog we will only look at data quality evaluation.

Rule%20usage

Rule usage

4.Once the usage is added we will prepare “USAGE ACTION”, this will create  BRF+ expressions where we can write our rules

Usage%20action

Usage action

5. There will be 2 expressions created, one is the scope expression and another will be the condition expression. The scope expression will help in selection of data for which the condition has to applied.

BRF+%20expressions

BRF+ expressions

6. Once expressions are created then you can send the rule for implementation which will change the status to “TO BE IMPLEMENTED”.

7. Click on the scope expression and it will navigate you to the BRF+ application. Here you can add the field which will determine the records of base table which has to be selected. In this case i considered the weight unit in MARA to be KG or G. Then click on activate to activate the expression.

Creation%20of%20scope%20expression

Creation of scope expression

8. Click on condition expression and follow the same steps as pt6. My condition is net and gross weight should not be equal to 0.

Condition%20expression

Condition expression

9. Approve the rule, and then enable the usage for Data quality evaluation.

10. To run the data quality evaluation we need to activate the BC set as shown below.BC%20set%20for%20DQM

BC set for DQM

 

11. We need to create data quality scores, which can be done from the “Configure data quality scores” app.  Create a global category and provide the values for target, warning and critical.

Data%20quality%20score%20category

Data quality score category

 

12. Add rule ID, which is the rule we created above and provide a dimension(“free text”). Set the target, critical, warning values for this rule along with it’s weight and impact.

rule%20ID

rule ID

 

13. Now run the data quality evaluation and see how many records satisfy the rule and how many don’t.

data%20quality%20run

data quality run

final%20result

final result

Reconciled%20with%20MARA%28%20base%20table%20%29

Reconciled with MARA( base table )

14. The data quality score is 10.9 which calculated as ( OK records/( OK + NOT OK records ) ).

Score

Score

CONCLUSION

In this blog, we see the step by step process of creating a basic validation rule for products and how it can be used for data quality evaluation.

In future blog posts, i hope to share how to use the rules in the change request processing, mass processing and consolidation. With each release of S/4 HANA the SAP MDG DQM feature is evolving with the goal to become the single rule repository for all kinds of processes in MDM.

Hope you like this blog.

Do share your comments.

 

Regards

Anirban

 

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sabine Stellmacher
      Sabine Stellmacher

      Hi Anirban, thanks for that step-by-step description that shows how easy validation rules can be implemented. To make use of that rule implementation in change requests, mass processing or consolidation you just have to add the additional usages. No further BRFplus implemenation is needed.
      More information on DQM within MDG can be found in our how-to-section.

      Regards,Sabine

      Author's profile photo Anirban Roy
      Anirban Roy

      Hi Sabine,

      Thanks for your comment, Yes the same BRF+ expressions can be used across all the usage types.

      Regards

      Anirban

      Author's profile photo Srihari Narayandas
      Srihari Narayandas

      Hi Anirban.

      Thanks for the informative blog. I always follow your blogs as its very helpful for initial understanding of new topics.

      I also creating a POC on DQM and used the same use case but when I am used the app "Configure data quality scores” app. My screen is completely blank , I cannot see anything as Global parameter etc. Below is screenshot for your reference. Could you please guide what could be the reason for this.

       

      Thanks,

      Mahak

      Author's profile photo Anirban Roy
      Anirban Roy

      Hi Srihari,

      Thanks.

      Could you please check the gateway logs when you open this app and see if any odata services are not activated. You can also check SU53 logs as well to see if there is an authorization issue.

      Regards

      Anirban

      Author's profile photo Jayraj Chavan
      Jayraj Chavan

      Hi Anirban,

       

      I am trying to follow the steps you mentioned above in the screenshots and I wanted to create a POC for DQM however when I select the template and start the validation process , it gets stuck at 0% and does not process anything further. Could you help me understand how to solve this issue?

       

      Author's profile photo Anirban Roy
      Anirban Roy

      Hi Jayraj,

      It's difficult to analyze what the issue might be without looking at the system or the system logs.

      You can check if the SLG1 logs for your process and see if you can find something.

      One thing i can suggest is you that you can check the BGRFC settings.

      https://blogs.sap.com/2021/02/01/mass-processing-of-business-partners-using-mdc-in-fioripart-1/

      Regards

      Anirban

      Author's profile photo Lasse Svendsen
      Lasse Svendsen

      Dear Roy

       

      When a press the expression in your step 7, I get the following error message:

      "Navigation to this application is not supported."

       

      I have access to the BRF+ Workbench when i open it in the Webdynpro via the back end, but cannot access it in Fiori.

       

      Do you have any idea, what configuration I am missing out on.

       

      Best regards, Lasse Louis

      Author's profile photo Anirban Roy
      Anirban Roy

      Hi Lasse,

      I think there is some specific Odata service which is not active in your system.

      You can check the gateway error logs and also SU53 errors to find out what is missing.

      Regards

      Anirban

      Author's profile photo Samyak Jain
      Samyak Jain

      Hello Guys,

       

      any idea, what is the use of Allow Configuration of Additional Condition Fields in DQM Apps. We are in SAP S4 2022 version and looks like we want to add additional conditional field in BRF+ Decision table from result of other DQM Derivation rules,but system does not allows it.

      Error comes like " Field should be added only using DQM App"

       

      Regards

      Samyak

      Author's profile photo Amr Elaasar
      Amr Elaasar

      Data quality evaluation Score is not reflecting on my rules or dimensions configured does anyone has a solution for this since all configuration looks correct, and data quality evaluation enabled