MRP on HANA: What’s new?
On the latest SAP ERP releases, MRP has been optimized to improve the overall performance using a HANA database.
This optimization can be activated by the business function LOG_PPH_MDPSX_READ and now there are two different MRP modes:
Classic MRP: The old MRP transactions, (such as MD01, MD02, etc…) were optimized to improve the performance when reading planning elements from the database, when running on a HANA database.
The internal logic to read the planning elements from the database to the internal table MDPSX has been completely redesigned for a better performance with HANA.
There is no substantial change on the transaction design but you can find a flag pointing that the optimization was active during the MRP execution:
This optimization is available as of SAP enhancement package 6 for SAP ERP 6.0 (version for SAP HANA).
MRP Live: This is a new MRP mode, where MRP has been fully redesigned to run an in-memory planning run.
Instead of several different transactions (MD01, MD02, MD03…) there is only one transactions, with more fields for selection, which provides you more flexibility when running MRP.
The new transaction code is MD01N and the report name is PPH_MRP_DISPATCHER:
On this new transaction you can plan a specific group of materials, a product group or all the materials of an MRP controller, for example. It is also possible to run multi-level MRP (same as MD02) checking the flag “BOM Components” or MRP for a single materials (such as on MD03).
The already existing MRP functionalities are still supported, but with a few exceptions.
Even if MRP finds one of these exceptions, this material can still be planned on transaction MD01N. However, instead of running MRP live, it changes internally to classic MRP. A complete list of these restrictions can be found on the following note:
1914010 – MD01N: Restrictions for Planning in MRP Live on HANA
MRP live generally provides a more effective performance improvement than the classic MRP. However, the improvement in performance in MRP live on HANA compared to classic MRP depends on the following:
- MRP features used
- Number of materials to be planned
- Number of materials not to be planned
- Number of low-level codes
Basically, the more materials are planned on MD01N with MRP live, better is the performance improvement.
For more details about the performance optimizations using MRP Live, see the the note below:
2023766 – MRP Live/MRP Classic: Performance Information
MRP Live is available as of SAP Enhancement Package 7 for SAP ERP 6.0, support package 01.
At last, these optimizations are not available on MRP if you are only using SAP HANA as a side car
You can also find more details about the Performance Optimizations for MRP (both classic MRP and MRP live) on the following link of SAP help:
See also the blog Is your system prepared to take advantage of MRP on HANA? and the WIKI MRP on HANA FAQ – ERP Manufacturing (PP) – SCN Wiki, with the frequently asked questions about MRP on HANA and the MRP Cockipit.