MDG DQM: Enriching product master data with derivation rules in S/4 HANA

[0012anirban]

Hi All,

In the previous blogs around MDG DQM i talked about the overall positioning of DQM in the MDG portfolio and how MDG DQM can be used to create rules at a single place for use in mass processing, consolidation, governance and quality evaluation.

If you have missed those blogs then you can find them here:

1. 
   

   MDG DQM:Employing rules in central governance & mass processing in S/4 HANA

   
   


2. 
   

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

   
   

Today in this blog we move our focus to performing derivations using MDG DQM.

INTRODUCTION

MDG DQM from S/4 HANA 2021 can be used to derive attributes of product data and business partner data in both mass processing and consolidation. From S/4 HANA 2022 MDG DQM also provides the capability of derive product and business partner attributes in central governance as well.

With the strong push of moving processes to cloud with SAP BTP, MDG also is moving towards cloud with SAP MDG cloud edition.Come S/4 HANA 2023 for MDG will also see significant transition to cloud as a result use of DQM for rules and derivations becomes cruical, as we need to re discover the traditional way of doing development in MDG.

However,In this blog we will only focus on creating a basic derivation rule for product master and see how it helps in MDG mass processing.

 

MAIN CONTENT

1. Activate the fiori app for Define Derivation scenarios: Products.

Fiori app

2. We can create a new derivation rule using the create button in the fiori app.

3. Give the scenario ID, scenario name and the base table for the rule, then create it.

4. Once the rule is created, click on send for implementation.

5. Prepare scope expression of the rule, this will restrict the data on which the derivation rule will apply.

6.Click on SCENARIO_SCP, this will open up the BRF+ workbench where you can define the scope.

Here i have restricted to a specific material type

SCENARIO_SCP

7.Once the scope expressions are created, we move to creation of derivation for fields by clicking on the create button.

8. Give the rule id, name and the result table. The result table describes to derivation rule will effect which table.

9. Add the condition fields. There might be a intuitive thought that after defining the scope why again condition fields are needed, my take on this will be that the scope expressions limits the data on which the derivation has to apply for a base table, and with condition field you can add, additional filter on dependent tables to narrow down the search criteria.

 

10. Add the result fields, these are the fields which will get auto derived by using this rule.

11. Click on Apply and save the rule.

12.  Change the status to "To be implemented".

13. In this step you will be able to create the condition and result tables.

14. Activate the decision tables and post that set the rule status to "To be approved"

15. In next step change status to "Approved".

16. Once the status is approved you can set the execution status to Green.

17. We open mass processing: product data app, and select the process template as "Change product data with derivation.

18. You can pass a particular material number for testing purpose, and at the derivation step you can see that the value of the industry sector field was changed.

 

19. Once the process is activated data will be reflected to the backend S/4 HANA tables.

CONCLUSION

This blog walks you through the steps which needs to be performed if you want to use derivation through DQM in MDG.These rules are easily built using a no-code/low-code approach, enhancing readability for business users. Integration with creation/change processes makes it a powerful tool for data enrichment.Benefits include automation, reducing errors and effort. DQM incorporates data quality checks, improving accuracy. User-friendly approach empowers non-technical users. Seamless integration ensures real-time enrichment.

In the future blog posts, i hope to talk about using derivations for central governance.

Hope you like this blog, and do share your thoughts.

 

Regards

Anirban