How to Optimize the Performance of MRP on SAP HANA

  • by Caetano Almeida, Senior Support Engineer, SAP
  • September 30, 2015
Learn how to activate the new material requirements planning (MRP) performance optimizations available as of SAP enhancement package 6 for SAP ERP Central Component (ECC) 6.0, version for SAP HANA. Understand the differences between the classic MRP transactions and the new MRP Live and under which circumstances each one should be used.
Learning Objectives

Reading this article, you’ll learn:

  • How to activate the material requirements planning (MRP) performance optimizations (business functions and Business Add-Ins [BAdIs])
  • The differences between classic MRP and MRP Live
  • Which scenarios are not covered by MRP Live and the impact on MRP performance
  • How to review the production planning master data to get the best performance improvement on MRP Live
Key Concept
As of enhancement package 7 for SAP ERP Central Component (ECC) 6.0, the new material requirements planning (MRP) report, MRP Live, was delivered on the standard ERP system. Because MRP Live is fully executed inside SAP HANA, all the MRP steps, such as the net requirements calculation or the calculation of the procurement proposal quantity, are executed inside SAP HANA.
In standard material requirements planning (MRP) transactions, data is selected sequentially from each database table. That means the system selects each planning element from the table and the record selected is processed by ABAP code. If this record is considered as a valid MRP element, it is included in the internal table MDPSX. At the end of the process of data selection from the database, this table stores all the MRP-relevant planning elements, and this information is considered for further processing during the MRP run.

This approach has been part of the standard MRP for several years and it works very well with traditional SQL databases. However, SAP HANA is a very disruptive technology, which offers much more power and features that are not present in the old databases. For example, instead of selecting data sequentially, the parallelization available on SAP HANA allows several tables to be read at the same time, improving the overall performance of the data selection.


To take advantage of all the new features of SAP HANA, as of SAP enhancement package 6 for SAP ERP Central Component (ECC) 6.0 (version for SAP HANA), the classic MRP transactions are optimized to run on an SAP HANA database. The data selection process in the old MRP transactions was completely redesigned and, instead of selecting data sequentially and processing each record after the selection, all the data selection is triggered at the same time on the SAP HANA database, where the tables can be selected in parallel.


After selection, an ABAP code carries out the post-processing, and the planning elements are available on the internal MDPSX table. Therefore, there is no visible change to the users from the classic MRP transactions, despite the performance improvement.


How to Activate the MRP Performance Optimizations


Even on a system upgraded to the latest releases, the MRP performance optimization is not active by default. Therefore, you can still run the old MRP without any kind of enhancement.


To activate the performance optimizations for MRP, SAP HANA must be the primary database. Having SAP HANA as a secondary database (side car) does not suffice.


If SAP HANA is your primary database and you want to activate this functionality, the first step is to open Business Add-In (BAdI) PPH_MDPSX_DBSYS_OPT. To open this BAdI, execute transaction code SE18, and in the screen that appears (Figure 1), ensure that the following steps are carried out:

  • Enhancement Spot PPH_DBSYS_OPT is active.
  • There is an active implementation of BAdI PPH_MDPSX_PREPARE_READ.

Caetano Almeida

Caetano Almeida is a computer engineer with an MBA in IT management. He has more than nine years of experience in production planning, with the last six years working at SAP Support, where he supports SAP customers and writes documentation and correction notes.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.