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 | RM07MLBD_DBSYS_OPT | BAdI: Stock on Posting Date |
| Transaction Code | S_EX1_23000009 | (empty) |
| Created on | 20120816 | |
| Customizing Attributes | RM07MLBD_DBSYS_OPT | BAdI: Stock on Posting Date |
| Customizing Activity | RM07MLBD_DBSYS_OPT | BAdI: Stock on Posting Date |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | RM07MLBD_DBSYS_OPT |
Use
This Business Add-In (BAdI) is used in the Inventory Management (MM-IM) component. You can use this BAdI to apply new database techniques for improving the performance in transaction MB5B.
Transaction MB5B #Stock on Posting Date# lists a company's own stocks in a particular time period. The posting date is used for selection. Starting with the current stock balance, the report uses the material documents to calculate the stock balance for the specified posting date.
The report issues a list with the following information for each material:
- Stock quantity and stock value on first date
- Total and value of all receipts
- Total and value of all issues
- Stock quantity and stock value on last date
- List of the material documents that were posted in the specified time period
You can use the corresponding BAdI method CALCULATE_STOCKS to read stocks for certain dates according to specific selection criteria.
Performance improvements from using new database techniques are expected to arise from:
- Generally faster data selection by state-of-the-art databases
- Aggregation of data on database level instead of ABAP server level
- Reduced volume of data transferred from the database to the ABAP server
For information about implementing such an optimization BAdI, seeOptimization BAdIs.
Requirements
Standard settings
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
- RM07MLBD_DBSYS_OPT
The filter DBSYS_TYPE has been defined for this BAdI. When an instance of the BAdI is created, this filter is applied with the value of the static attribute DBSYS_TYPE in class CL_DB_SYS.
SAP Implementations
- The available SAP BAdI implementations read and aggregate data. The BAdI implementation ES_IM_RM07MLBD_DBSYSOPT is assigned to filter value #HDB# for the SAP HANA database. The BAdI implementation ES_IM_RM07MLBD_ANY_DBSYSOPT is assigned to the relevant filter values for the following databases:
- IBM DB2 for i (filter value: DB400)
- IBM DB2 for Linux, UNIX, and Windows (filter value: DB6)
- IBM DB2 for z/OS (filter value: DB2)
- Microsoft SQL Server database (filter value: MSSQL)
- Oracle database (filter value: ORACLE)
- SAP Sybase ASE (filter value: SYBASE)
For more information about the optimization and possible restrictions, see SAP Note 1829603.
More Information
BAdI method documentation:
Activities
Example
Business Attributes
| ASAP Roadmap ID | 207 | Establish Reporting |
| 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 | RM07MLBD_DBSYS_OPT | 0 | HLA0009516 | Inventory Management |
Maintenance Objects
| Maintenance object type | E | Business Add-In - Definition |
History
| Last changed by/on | SAP | 20120816 |
| SAP Release Created in | 616 |
