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

      2 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