MDG Derivation (BRF+)

 In this blog, we will see how to derive some attribute based on another attribute in SAP MDG using the BRF+ application. 

So here, we are going to derive language based on country. If the user selects the country as India, then the language field should derive with the value English. 

In the BRF+ application, we can only do single entity derivations. It means that both derived fields and driven fields should be from the same entity.

Steps:

1. Go to USMD_RULE t-code OR MDGIMG -> General Settings -> Data Quality and Search -> Validation and Enrichments -> Define Validation and Derivation Rules. 


2. Enter BP and Continue. Right click on the Derivation node and create function using following path.


3. Give details like below.



4. The naming convention for creating function is 'DERIVE_<Entity Type>'. As we are doing derivation on Entity 'AD_POSTAL' we will give this entity name. We should follow this naming convention strictly or else our derivation will not work. Click on 'Create and Navigate to Object' button which takes us inside function.



5. Click on Add Existing Data Object button. Search like below.


6. Select type structure -> Physical address (AD_POSTAL).



7. Go to Assigned Rulesets tab.



8. Create Ruleset.



9. Click on Create and Navigate to Object button.



10. Click on Insert Rule and Select Create.



11. Give description and Click on Assign Condition. Now, we want to Derive the Language based on country key. So, in if condition we have to write like IF Country = IN then Language = EN. For that give Country Attribute in If Condition as below. 



12. Search like below and select Country attribute.



13. After that, in Then condition we have to change the value of Language field as EN. For that give Language attribute in Then condition and assign value as EN.


14.After that, save, check, activate the ruleset as well as function. Now test it on MDG UI.




Comments

Post a Comment

Popular posts from this blog

SAP MDG Process Modelling

Image
Overview In SAP MDG, every change to master data is initiated using a change request. After a change request is initiated, it needs to be processed before activation or rollback by applying governance rules and collaborations. The process model provides the required input (metadata) for change request creation and processing, e.g., workflow, CR steps, and objects that can be processes. Submit and activate/rollback are mandatory steps in a change request. MDG reuses the SAP Business Workflow component of an underlying SAP business suite. SAP MDG workflow is an instance of SAP Business Object BUS2250. If the request has parallel processing, then each parallel step of the change request will have one BUS2250 instance. Define Governance Scope: Here we can define governance scope on the entity as well as the attribute level. For example, we have kept ‘NO’ to the below custom entity. As a result of MDG UI, the UIBB for this entity will only be in read-only mode. Business Object An ...
Read more

MDG Derivation (BADI)

Image
In this blog, we will see how to derive MDG attributes using BADI. Derivations can be divided into two types.  Single-entity derivation:  Automatically populating some attribute value in one entity based on an attribute value from same entity. For this, we use 'USMD_RULE_SERVICE' BADI definition. Cross-entity derivation:  Automatically populating some attribute value in one entity based on an attribute value from another entity. For this, we use 'USMD_RULE_SERVICE_CROSS_ET' BADI definition. First, we will see a single entity derivation. Scenario:  We are going to make language English as the default if the user gives the country as India. Steps: 1. Go to SE18. 2. In 'USMD_RULE_SERVICE' BADI defination, create BADI Implementation.  3. For creating BADI Implementation, first we need to create Enhancement Implementation.  4. Give the properties as below. 5. Now, create BADI Implmentation and give following properties. 6. Maintain the filter values. H...
Read more

MDG Validation (Using BADI)

Image
In this blog, we will see how to validate the MDG attributes using the BADI implementation. So, we are taking the example of the 'BP Grouping' field to make it mandatory on the UI. For this, we should know the technical attribute name for the respective field. In our case, 'BU_GROUP' is the technical name for the BP grouping field. Steps for the Implementation of Validation BADI. 1.   Open T-code ‘MDGIMG’ –> General Setting -> Data Quality and Search -> Business Add-Ins -> Execute BADI: Define Validation/Derivation OR SE18 -> BADI name: 'USMD_RULE_SERVICE' -> Create BADI Implementation.  2. After execution, the following screen will appear. Go down, and there you will find the option to create enhancement implementation. Click on that button. 3. Provide the name and short description of the implementation, as follows:   4.  After that, we have to create the BADI Implementation and Implementation class. 5.  You will be directed to the Enha...
Read more