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

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

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.


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.



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



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.


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.





Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Manish Kumar
      Manish Kumar

      Hello Anirban,

      Thanks for the wonderful blog on MDG DQM Derivation Rules.

      Can we also create Cross Entity Derivation Rules using MDG DQM in Mass Processing and Central Governance? That means if MARA-MTART is ZMDG then it should also process or derive the MARC attributes like Purchasing Group(EKGRP) , ABC Indicator (MAABC), if plant data exists.





      Author's profile photo Anirban Roy
      Anirban Roy

      Hi Manish,

      Yes it's possible, you can define condition fields based on MARC that if plant is not initial and results fields as EKGRP and MABC prepopulated with some values .

      For central governance the steps are completely different and are applicable only for S/4HANA 2022 and higher releases. You can refer to the below document for detailed understanding.



      Author's profile photo Sabine Stellmacher
      Sabine Stellmacher

      Hi Anirban,

      thanks for the nice introduction into derivation scenarios.
      They work on business partner data as well - and there is a video, which contains also a step by step tutorial on 'How to create a derivation rule for dunning data'.

      Regards, Sabine

      Author's profile photo Anirban Roy
      Anirban Roy
      Blog Post Author

      Hi Sabine,

      Thanks, and as you rightly pointed out it does work for business partner data as well.



      Author's profile photo Sabine Stellmacher
      Sabine Stellmacher

      For those who like to see how derivation scnearios are applied in a change request, see Automate the Creation of Products in Central Governance by Implementing Derivation Scenarios for Products

      Author's profile photo Rushail Gopal
      Rushail Gopal

      Thank you for the insight into the app.

      I am trying to derive classification for products based on the material type. But I don't see the "Class" field in the result fields list. Only the KLART class type and sort position fields are available. Is there any way to enable derivation for the class field?

      Author's profile photo Anirban Roy
      Anirban Roy

      Hi Rushail,

      At this juncture derivation of classification data is not fully supported in DQM due to some dependencies.

      I would suggest you open a incident for this component to check with SAP product team for possible workarounds.



      Author's profile photo Rushail Gopal
      Rushail Gopal

      Thanks Anirban.

      A follow up question for Business partner: I do not see the option to derive BUT0ID table entries based on the BUT000 table as a base table. Is there any configuration needed to enable it?