How to : SAP MDG Consolidation – Standardization of data with BRF plus derivation rules.
Hello Colleagues,
in this blog , We will see, How to call and use BRF plus derivation in the standardization process of MDG consolidation process.
Set up BRF plus Standardization:
Standardization normalizes and enriches the source data before the matching process. We will see how to use BRF plus rules and derivation in the standardization process.
In the Material Master Consolidation process , we derive order unit (BSTME) from the base unit of measure (MEINS) using the BRF plus derivation.-> If order unit is empty, populate the base unit of measure value into order unit field.
MDC Configuration under MDCIMG:
- In the Configure Process Model, chose material business object type (194) and drill down table list.
- Check the BRF+ is marked for the table level. Order unit is present in MARA, so MARA table should marked as BRF+ flag (If the table is not marked, we need to mark it)
- Click the “Resultant Artifacts” button and choose a Z package, and apply the BRF+ Artifacts
It generates all the BRF plus structures and functions.
- In specify process template configuration, Choose BRF adapter class “CL_MDC_ADAPTER_BRF_STD” in the standardization step.
- Click the “Define Rules using BRF plus” (as below) in the configuration node and go the BRF plus workbench
- Search MDC Application for Material, to locate the MDC Application for Material, Search using the following parameters:
Application name as “*MDC*” and Object type as “Application”.
- Once the Material BRF plus application “ZMDC_TESTING_194” (the name vary based on your Z Package) is located, Choose the function “MDC_STD_FOR_MARA_PRC”
- Edit the above function and create a new ruleset as below:
Here, put a simple derivation -> Order Unit (BSTME) = Base Unit of Measure (MEINS).
It is important that, after the derivation you have to set BOOLEAN to ‘True’ because the standard function contains the result object as Boolean, otherwise the derivation will not work in consolidation screen
Activate the ruleset and function.
MDC Consolidation Process – FIORI
Now we can see , how the BRF plus Derivation works inside the MDG Consolidation process from the Fiori.
- Create new Material Consolidation process (already the source data loaded in the consolidation source tables)
- Run the Standardization step with following parameters (BRF Plus)
3.The standardization process called BRF plus and order unit was derived (see the below screen prints)
Order unit was initially empty and new value was derived from base unit of measure.
Order Unit was derived from Base Unit :
- You can do the derivation for different fields (and different table level … like MARC) based on your customer requirements.
Nice blog with detailed Explanation .
Thanks for sharing!
Best,
Markus
Nice blog
Thanks for shaing
Thanks for sharing !
Looking forward to more such blogs on Consolidation.
Hi,
Thanks for sharing the steps with screenshots. It is very useful...
Regards,
Athi
Thanks for Sharing!
Do you know how to write BRF+ rules for best record calculation?
How to write cross entity Validation in this BRF+ Rules fro MDC?
I tried the same way as showed above to add some custom rules under Validation function in BRF for BP, but these rules are not getting triggered in validation process. Can you please let me know if any additional config. to be changed.
Hi Manickam,
I have seen some standard BRFPLUS functions are available for Business Partner consolidation. Can we re-use to create our own custom BRF plus validation ruleset.
Regards
Kumar.
Hi,
With SAP S/4HANA 2021 FSP01 a new version for derivations have been released. Please check this blog: https://blogs.sap.com/2022/05/19/automate-your-master-data-process-with-derivation-scenarios-in-sap-master-data-governance-on-sap-s-4hana/comment-page-1/#comment-623950
Steffen