Skip to Content
Technical Articles
Author's profile photo Andreas Seifried

How to create and use data quality rules with SAP Master Data Governance on SAP S/4HANA 1809 (Part 2)

By following the instructions of part 1 you have created a data quality rule that is in status active and ready for evaluation.

Before you continue, ensure that there is corresponding product master data in your system, products that fit to our example score expression products of type finished goods (MARA-MTART = FERT) that also have a product number starting with ZDEMO (MARA-MATNR = ZDEMO*). It is fine to create a few products, for example using the app Manage Product Master Data. It would be nice though if some of the example data comply with the rule and some don’t.

After you are done with this blog series, you might want to have lots of data in your system to experiment with larger and different data sets. Have a look at MDG’s master data consolidation capabilities that also include the upload of master data in CSV or spreadsheet format.

Part 2 – Evaluating data quality rules

Create a data quality evaluation

  1. Launch the app Manage Data Quality Evaluations – Products.
  2. A list with previous evaluations is displayed.
  3. Choose Create Process.
  4. You can give your evaluation process a description, but can also just accept the defaults…
  5. … and choose Save.
  6. There are various parameters to clean up previous evaluations. Please keep the defaults.
  7. Choose Start.
  8. The status of the process changes to Initializing Process.
  9. After that the system starts the evaluation.
  10. Once done with the evaluation, the process is finalized.
  11. After that, it changes to the final state Completed.
  12. There are statistics about the evaluation displayed. These are rather to see of the evaluation itself run correctly. There as a dedicated app for the analysis of the evaluation result.
  13. Click on Back to return to the Fiori Launchpad

 

See the evaluation result for your particular rule

  1. Launch the app Manage Data Quality Rules – Products.
  2. Click on the Expand Header button to display the filter bar.
  3. Search for your rule.
  4. Click on your rule to display its details.
  5. Note that there is now a section Evaluation that displays a summary of the evaluation result of the rule. To see the details of the evaluation result, click on the score.
  6. You navigate to the app Evaluation Results for Products. You should find the example products that you created. We will have a closer look at this app in the next part.

Stay tuned…

Now, that you have evaluation results available you surely want to examine them more closely. And you might ask: how do I correct the erroneous data? Well, see the 3rd part of this blog series.

Follow this blog: Click on Follow at the top of this page to get informed when the next part is posted.

Assigned Tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Andreas Seifried
      Andreas Seifried
      Blog Post Author

      Part 3 is published!

      Author's profile photo venu gopal
      venu gopal

      Hello Andreas, nice document and keep sharing

      ...thanks a lot

      Author's profile photo Suresh Ravella
      Suresh Ravella

      Hi Andreas,

      Thank you for sharing valuable information on Data qualiy management on MDG on 1809 S/4HANA. Shall the Data quality tool on 1809 S/4 HANA configured for ERSA/PACK/INGR material types ? I mean indirect materials as well. Are we replacing material with product moving forward ?

      Author's profile photo Andreas Seifried
      Andreas Seifried
      Blog Post Author

      Hi Suresh,

      it is not limited to certain material types. There is a set of tables that can be used as Base Tables for rules. These are a subset of the tables of the model we use for consolidation and mass processing. See the IMG activity Configure Process Models for details.

      Regardless what Base Table you choose, you can always do a Break-out in BRFplus, for example using a DB lookup expression.

      The applications to analyze the evaluation results are already based on the product CDS views.

      Author's profile photo Yugesh Adalam
      Yugesh Adalam

      Hi Andreas,

      On our S/4 HANA 1909 system, we are trying to  implementing Manage Mass Process - Products and Data Quality Evaluation Process applications.

      We have followed AS-IS steps that are mentioned in the above article. We were successful until step 8 (The status of the process changes to Initializing Process).

      We are unable to proceed further. The status is still showing the Initializing process as shown below.

       

       

      Kindly let us know if we are missing any key configurations.

      Thank you,

      Yugesh A

       

      Author's profile photo Yugesh Adalam
      Yugesh Adalam

      Hi Andreas,

      The above issue is sorted out after setting up the workflow. We were able to see the progress.

      In Mass Processing, we are unable to progress as we are unable to see the fields to edit. The status is showing as In Process(Edit), but we are unable to view the Fields to Edit.

      Kindly let me know if I have missed any configuration.

       

      Thank you,

      Yugesh A

       

       

       

      Author's profile photo Michael Veth
      Michael Veth

      Hi Yugesh,

      It seems, that the EDIT step is hanging. Please check the background RFC queues using transaction SBGRFCMON. It seems, that the EDIT step is hanging.

      If there are hanging queues, you can unlock them.

      If the problem persists, you should raise a ticket.

       

      Best Regards,

      Michael

      Author's profile photo Yugesh Adalam
      Yugesh Adalam

      Hi Michael,

       

      Yes, you are correct. The issue is now resolved.

       

      Thank you,

      Yugesh A

      Author's profile photo Antonio Guzman Trigueros
      Antonio Guzman Trigueros

      Hi Yugesh

      I'm the same problem, where is the solution?

      Thanks

      Author's profile photo Yugesh Adalam
      Yugesh Adalam

      Hi Antonio,

      Inform the Basis team to enable bgRFC configuration.

      Refer to the below link for more details.

      https://help.sap.com/viewer/753088fc00704d0a80e7fbd6803c8adb/7.5.14/en-US/489709f255493987e10000000a421937.html

       

      Thank you,

      Yugesh A

       

      Author's profile photo Antonio Guzman Trigueros
      Antonio Guzman Trigueros

      Thanks !!!!

      Author's profile photo Antonio Guzman Trigueros
      Antonio Guzman Trigueros

      Hi,

      I had inconsistency in the queues. I sort out the problem use the report: RS_BGRFC_DB_CONSISTENCY

      Thanks

      Author's profile photo Tatiana Trepenkova
      Tatiana Trepenkova

      Hi, please tell me

      1) how to run a Evaluating data quality rules:

      • according to selected rule(s);
      • based on materials that have been changed since the date of the last evaluation.

      2) how to test a rule (status "To Be Tested")?

      2020 FPS02

      Thanks

      Author's profile photo Andreas Seifried
      Andreas Seifried
      Blog Post Author

      Hi Татьяна,

      1. is currently only possible by implementing such conditions in the scope expression.
      2. In past releases, the rule owner would review the implementation and use the test functionality in BRFplus. Meanwhile, we have released a by far extended test functionality. Please see https://roadmaps.sap.com/board?PRODUCT=901B0ED1A0641EDA9FF75276E440C0EF&range=2022Q1-2023Q4#;INNO=40F2E9281A631ED9AECF85BEBF4FC0EE

      Kind regards
      Andreas

      Author's profile photo Tatiana Trepenkova
      Tatiana Trepenkova

      Hello Andreas, thanks for the answer!

      But what about running the evaluation on only one rule?