Hierarchy
SAP_APPL (Software Component) Logistics and Accounting⤷
MM-IM (Application Component) Inventory Management⤷
MB_OPT (Package) Additional application development R/3 inventory management
IMG Activity
| ID | MM_PERF_OPTIMIZATION | BAdI: Activate MM DB-Related Performance Optimizations |
| Transaction Code | S_EX1_23000074 | (empty) |
| Created on | 20121116 | |
| Customizing Attributes | MM_PERF_OPTIMIZATION | BAdI: Activate MM DB-Related Performance Optimizations |
| Customizing Activity | MM_PERF_OPTIMIZATION | BAdI: Activate MM DB-Related Performance Optimizations |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | MM_PERF_OPTIMIZATION |
Use
This Business Add-In (BAdI) is used in the Materials Management component (MM). You can use this BAdI to activate database related improvements which could have an increased overall runtime than before the optimization on a relational database.
The optimization can increase the overall runtime in the following cases:
- complex join operations on non-indexed fields
For this case you may create indexes in your system to improve the performance in a relational database system and then you can use the optimization.
- data is read in multiple steps
For this case the logic inside the transaction has been changed.
The following transactions use this optimization BAdI for alternative data access:
- MB5L (report RM07MBST)
The system reads the aggregated data from the database and displays them on the overview screen. When the user navigates to the detail screen, the system reads the detail data from the database. Prior to this optimization, the data was read from the database in one step. Hence, the time to display the overview screen was longer than with the optimization, but the overall runtime to display the detail screen was shorter than with the optimization.
- MB25 (report RM07RESL)
When the optimization is activated, the report results are retrieved using one Open SQL statement for the main database tables involved. When the optimization is deactivated, the report uses several buffered Open SQL statements to retrieve the data from the relational database systems.
Requirements
The BAdI implementation is only considered by the system if the business function Materials Management, UI and Performance Optimizations (LOG_MM_OPTIMIZATIONS) is active.
Note
SAP recommends to test which data access is faster for your system and to use the faster alternative. The business function is fully reversible; therefore, you can deactivate the business function after a trial in your test system if the classic approach is more convenient for you.
Standard settings
SAP delivers an inactive implementation of the BAdI: Activate MM DB-Related Performance Optimizations. You activate or deactivate this BAdI implementation in Customizing for Materials Management under General Settings for Materials Management -> BAdI: Activate MM DB-Related Performance Optimizations.
For more information about the standard settings (filters, single or multiple uses), see the Enhancement Spot Element Definitions tab in the BAdI Builder (transaction SE18).
BAdI Definition
- MM_PERF_OPTIMIZATION
- SAP Implementations
The SAP BAdI implementation ES_MM_PERF_OPTIMIZATION_IMG activates the DB-related performance improvements.
Activities
To use the optimization approach, you must first activate this BAdI in Customizing for Materials Management under General Settings for Materials Management -> BAdI: Activate MM DB-Related Performance Optimizations.
To use a user-specific implementation of this BAdI, you must first deactivate this BAdI in Customizing for Materials Management under General Settings for Materials Management -> BAdI: Activate MM DB-Related Performance Optimizations.
For information about implementing BAdIs as part of the Enhancement Concept, see SAP Library for SAP NetWeaver under BAdIs - Embedding in the Enhancement Framework.
More Information
BAdI method documentation:
Example
Business Attributes
| ASAP Roadmap ID | 204 | Establish Functions and Processes |
| Mandatory / Optional | 2 | Optional activity |
| Critical / Non-Critical | 2 | Non-critical |
| Country-Dependency | A | Valid for all countries |
Assigned Application Components
| Documentation Object Class | Documentation Object Name | Current line number | Application Component | Application Component Name |
|---|---|---|---|---|
| SIMG | MM_PERF_OPTIMIZATION | 0 | HLA0009510 | Materials Management |
Maintenance Objects
| Maintenance object type | E | Business Add-In - Definition |
History
| Last changed by/on | SAP | 20130205 |
| SAP Release Created in | 616 |
