Skip to Content
Product Information
Author's profile photo Sabine Stellmacher

Automate Your Master Data Process With Derivation Scenarios in SAP Master Data Governance on SAP S/4HANA

Customers often ask me how automation can help master data stewards safeguard high-quality master data. One example of how we are tackling this challenge is the automation in the mining of data quality rules, which was introduced with SAP Master Data Governance on SAP S/4HANA 1909 and has evolved with each new release. ((https://blogs.sap.com/2019/09/23/using-mdg-rule-mining-to-improve-data-quality/))

And now, with SAP Master Data Governance on S/4HANA 2021 Feature Pack Stack 01, we’ve taken an additional step forward by enabling derivation rules for the management of attributes of product and business partner data.

If you’re struggling with piecing together spreadsheets, ABAP code, customizing tables and master data management UIs to get automated processes running, our new Define Derivation Scenarios apps may be a remedy.

What can you expect?

  • Derivation rules are introduced to derive the value(s) of single or multiple fields. This includes the ability to set the derived value as a default value. Derivation rules can also create and update dependent entities (for example, create a storage location when a plant is created).
  • Derivation scenarios are provided to combine derivation rules into executable and manageable units. This facilitates the lifecycle management, configuration and data maintenance by business users.
  • Derivation scenarios can then be used in mass processing and consolidation, for example to automate the extension of materials to plants or to create customer data for a business partner.

How these features look in the system you can see in the following tutorial. The basic functionality of the app ‘Define Derivation Scenarios for Business Partners’ is shown. The shown derivation scenario extends general business partner data with general customer data, customer company code data and dunning data. It is explained step-by-step how you can add a new derivation rule to an existing scenario and apply it in a consolidation process.

 

These new apps for the definition of derivations follow the same pattern as the ones for validation rules. There is a central entry point for the management of your validations and derivations. Users contributing their business know-how collaborate with the IT people – and thanks to the user friendly SAP Fiori apps, the lifecycle management is in the hands of the business users.

For a comprehensive overview of what SAP Master Data Governance on SAP S/4HANA provides so far for data quality management, check out our How-to material.

We offer apps for every step of the data quality management process.

SAP%20MDG%20Data%20Quality%20Management

You can e.g. check it out in the SAP Cloud Appliance Library. with details given in Kefeng’s blog

Thus you can go forward to improve your master data quality and automate your master data processes.

 

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Markus Ganser
      Markus Ganser

      Hi Sabine,

      Thanks for posting! Automation is a key driver in master data management. Derivation scenarios are also explaind in this presentation about data quality management in SAP MDG on S/4HANA 2021.

      Author's profile photo Antonio Carlos Murayama
      Antonio Carlos Murayama

      Good blog.

      Is it possible to use derivation for material? in context of  CLASSIFICATION to fill all characteristics values from external services (web services, SOAP) like UNSPSC external services and providers for um specific class.

      Author's profile photo Sabine Stellmacher
      Sabine Stellmacher
      Blog Post Author

      Generally, derivation rule scenarios are supported for Business Partner and Product (Material) data ((https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/6d52de87aa0d4fb6a90924720a5b0549/7b586ec9ab7f4d9ba5c240ddac4f3a92.html?locale=en-US)). Not all table of the data models can be taken as result tables yet. Derivation of classification data from external sources is a roadmap topic.

      Author's profile photo Wolfram Eisenhardt
      Wolfram Eisenhardt

      Classification is a real "big pain" topic with MDM at the moment...

      Author's profile photo Betsy Wheatley
      Betsy Wheatley

      Using the SAP Master Data Governance tool, you can automate your master data process by defining derivation scenarios. Derivation scenarios use a set of rules to derive one or more master data elements based on another master data element. They can be used to create new values for existing master data, or to create new master data records from scratch.

      Author's profile photo Steven Vazzano
      Steven Vazzano

      A short demonstration of the derivation functionality can be found at the following link. https://sapvideoa35699dc5.hana.ondemand.com/?entry_id=1_knktem6x  We show how a spreadsheet with basic product/material data is uploaded to SAP Master Data Governance S/4HANA and extended out to multiple plants and sales organizations using business rules. In this example  some products are only produced at certain plants and planned by specific MRP Controllers.  The Material Group field is used to determine where to extend the materials.