SAP Master Data Governance, cloud edition: Create a validation rule
Nevertheless, were are some differences to the on-premise world: As you can see in screenshot 2 “SAP Master Data Governance, cloud edition” is using the “Simplified BRF+ Workbench” which comes with some limitations compared to the full version. Besides others the following expressions are available in the “Simplified BRF+ Workbench”: Decision table, Case, Formula and Loop. The artifact “DB Lookup” which I used often is not supported. I used the “DB Lookup” to check the existence of a BP object in a dependent table. An example is the implementation of the check “at least one industry must be assigned to an BP of type organization”.
After some research I found out that even if the expression type “DB Lookup” is not available you can implement the checks in “SAP Master Data Governance, cloud edition”. In fact the check can be implemented with “procedure calls” in an easier way and most likely with an better performance.
The modeling of the check “CHECK_INDUSTRY” include the following steps:
- Create a new Validation Rule by using the app “Data Quality Rules for Business Partners”
- Enter the meta data for the rule and define base table (“BUT000”) and checked field (“BUT0IS-IND_SECTOR”)
- Save the rule and add the usage for “Data Quality Evaluation” ( or any other). Use the button “prepare” to generate the BRF+ application.
- Define scope expression: As simple as on the on-premise version you use BRF+ capabilities to model the scope definition: Click on the link with in section “Implementation” and without any coding you can define that only Business Partner of type “Organization” are in scope of the rule. The framework has generated the complete context for you out of the Business Partner data model.
- Define condition expression:
Explanation: To be able to check if each BP which is in the scope of the condition has also an industry assigned you need to “correlate” the tables BUT000 and BUT0IS. Instead of using an “DB Lookup” you need to use an expression “Table Operation”. In the artifact itself you select as an table-operand an type “procedure call”, This “procedure call” is provided by the MDG framework for you to support such checks.
Steps in the system:
- Open the condition expression in the “Simplified BRF+ Workbench” by clicking on the link the Validation Rule
- Remove the dummy condition and add new condition
- On the new condition select the context menu and “Create Expression”
- Select “Table Operation” from the drop down list and enter any “Name”
- In the “Table Operation” expression itself select the Operation “Has at least”
- Now you need to assign a procedure call as a table. For the industry example please choose “BUT0IS lookup ALL”
- As a last step you need to define a condition for the table operation. One example is to define the attribute “Standard Industry” should not be initial.
The following screenshots gives you some more information on the steps above:
As you can imagine you can use this approach also for other dependent tables and use cases. For instance you can make sure that each Business Partner of type “Person” has at least one bank account defined.
Hope this blog helps you to have fun with “SAP Master Data Governance, cloud edition”
PS: Many thanks to Stefan Geiselhart and Sabine Stellmacher for helping me doing the research and writing this blog.