How to: SAP MDG Master Data Quality (Remediation) Process on S/4 HANA with BRF plus validation rules
In this blog, we will see, How to configure the Master Data Quality on product data in SAP MDG on S/4 HANA system with BRF plus validation rules.
Master Data Quality (Remediation) for Product data:
Master Data Quality (Remediation) for Product enables to view the data quality issue list for product master data against the data quality rules. With this you can start the correction process to remediate product master data objects with errors to improve the data quality in your company.
SAP MDG (in earlier versions) has provided data quality remediation capabilities like running checks against your data using tools like the SAP Information Steward.
Now, with SAP MDG for SAP S/4HANA 1709, this functionality has been further enhanced to provide more functions and features to manage this process fully within SAP MDG.
With SAP S/4HANA 1709, the data quality remediation process is only available for product master data. Note also that remediation capabilities are only offered on SAP MDG for SAP S/4HANA and are not available on SAP MDG on SAP ERP.
In this blog, we can set specific data quality validation rules in BRF plus and run the data quality remediation process against the rules, identify the data quality issues and start the governance process to improve or rectify the data quality issues.
BRF plus Validations:
We can set the following BRF plus validation rules to validate the
product master data in MDG:
- Product group is mandatory for all product data
-> If MARA-MATKL is empty than raise an error message ( mark as error record in MDQ)
2.If product type is “full product” than division is mandatory
-> If MARA-MTART = ‘FERT’ and MARA-SPART is empty,
than raise an error message ( mark as error record in MDQ)
Configuration of BRF plus Rules in MDG
- In MDGIMG, choose the ‘Define Validation and Derivation Rules’ and it navigate the BRF plus workbench, choose MM data model
- Create validation function (CREATE_MATERIAL) and create ruleset for validations
- Create the following rules inside the ruleset, and activate the ruleset and function
Mater Data Quality Configuration:
We have to do the post installation configurations(using SAP standard configuration guide) for Master data Consolidation for Material, and Master Data Quality configurations.
The post installation configuration brings all the relevant MDQ process data as out-of-the-box (like Process template, Evaluation settings)
- We can check and verify the MDQ configuration using t.code MDQIMG.
- We have to verify and set flag for ‘BRF plus check’ and ‘Worklist’ in the validation configuration, the validation configuration comes under consolidation configuration and we go to consolidation configuration via t.code: MDCIMG
MDQ run all the backed configuration validations of product master data as default, but to bring the additional BRF plus validations, we have to set BRF Plus flag as shown in the above screen shot.
2.Assign the validation config.ID (SAP_VAL_DQ)to the process template (SAP_MM_DQR)
Master Data Quality – Fiori Frontend
Now we can see , how the BRF plus validation rules works inside the ‘Master Data Quality-Product‘ from the Fiori.
For getting Master Data Quality Titles, the role ‘SAP_BR_PRODMASTER_STEWARD’ need to assigned to our user.
- Log on the Fiori, and create new Remediation process for products using the title(Start Remediation Process Products) as below
- Select the existing material using the selection criteria and start the process by press ‘START‘ button in the bottom of the screen
- Validation of BRF plus rules were called in the validation step, and it showed errors records and success records based on the validation rules
We can also drill down to see the validation errors in detail by clicking ‘show result’ link
- Complete the process by click ‘Continue’ button and finish the remediation process, if the process not completed, than the errors logs not transferred to the remediation work list.
- We can see the Master Data Quality Overview (Dash Board) for our last remediation process RUN using the below shown title:
Choose the Evaluation Setting as ‘CONS_PROD’.
The overview dashboard showed the error list from our last run, it split among various dimensions and showed error records.
We can further drill down to break the results down based on further dimensions. For example, we can see errors filtered by “Product Division” field.
We can add further dimensions to our analysis to determine how many errors were caused by a specific combination of attributes.
We can choose various charts (Bar Chart, Pie Chart, Doughnut Chart, etc.) for our analysis.
6. We can see the error list and details logs of the error against products data by selecting the worklist title as below
7. We can start the MDG governance process by selecting the product and click ”process products” button.
Form the MDQ work list, a new MDG Governance Process Material Change Request(CR) was created, and the MDG governance process was launched to change the error data.
Finally, we can improve the data quality of the product data in MDG.