Concento RDG provides a powerful User Interface that helps a business user create multiple validation checks and derivation rules without going through the laborious process of manually defining these rules in BRFPlus
This blog post is a part of series which covers different key capabilities provided by Concento RDG
- Concento RDG simplifies MDG rule-based workflow maintenance
- Concento RDG automates many technical steps for MDG Data Model extension
Below is an SAP document by Andreas Seifried which provides a detailed explanation on steps required to create a validation and derivation rule for an attribute value in MDG using BRFPlus.
How to Check or Derive an Attribute Value in MDG using BRFPlus
In order to manually define the rules, the user has to go through the following steps:
- Select the relevant catalog to define the rule (FMDM_MODEL_<DATA_MODEL>)
- Name the function (as per the naming standards) which will be called for validation/derivation
- Add relevant context parameters for the above created function
- Create ruleset
- Create a rule
- Define condition statements for which the rule is triggered
- Define Action for when the condition is met
- For Validation: Action is to display a log message (Information, Error, Warning) with text maintained in SAP message class or user defined text
- For Derivation: Action is to derive another attribute value
Concento RDG simplifies the process of creating a validation/derivation rule in BRFPlus by automating the configuration steps. The user is only required to provide the conditions and action by making use of the intuitive User Interface.
The below example is based on aforementioned guide to create a validation and derivation rule to be triggered for a specific Change Request Type for attribute values in Entity AD_POSTAL of Data Model BP
Step 1: Create the Validation/Derivation Rule in Concento RDG
- In the main menu, select “Manage Business Rules”
- In the following steps, user can choose a Change request type from the list and select the entity for which the rule has to be created. The user then needs to select the type of Business Rule that he/she wants to create. Value Check Rule to create Validation Rule in BRFPlus and Derivation Rule to create Derivation Rule in BRFPlus
- The user then selects the attribute value for which the rule has to be created and provides the condition and action. The user can subsequently specify for which processing step in the workflow should this rule be triggered. On saving, the rule gets created in corresponding catalog in BRFPlus
-
- Validation Rule: If AD_POSTAL-REF_POSTA = “CN” or AD_POSTAL = “IN”, then display error message “COUNTRY IS INVALID” for all workflow steps
-
- Derivation Rule: If AD_POSTAL-REF-POSTA = “US” and AD_POSTAL-CITY1 = “DENVER”, then derive the attribute value AD_POSTAL-POST-COD1 = “80014” only for Initial processing step
Step 2: Trigger the rule in nwbc application
- The rules created in the previous step are triggered when creating a Change Request of the type for which the rules are created in RDG (ZBP1P5)
-
- Validation Rule
-
- Derivation Rule
Below are the rules that got automatically generated in BRFPlus under the catalog FMDM_MODEL_BP through Concento RDG
- Validation Rule
-
- Condition
-
- Action
- Derivation Rule
-
- Condition
-
- Action
With the help of Concento RDG, you can now create rules without the hassles of attending to the many technical configuration steps of defining these rules in BRFPlus
Concento RDG is certified SAP BTP solution and is available on SAP App Store
Please check out more details about the product here: Partner Add-on Solution
Your thoughts and feedback about the product are greatly appreciated. Please feel free to post them here in the comments section
You can also find and post questions about the product here: SAP Master Data Governance Community