Kontakt

Ansicht
Dokumentation

RM07MLBD_DBSYS_OPT - BAdI: Stock on Posting Date

RM07MLBD_DBSYS_OPT - BAdI: Stock on Posting Date

ABAP Short Reference   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.
SAP E-Book

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.

For more information about the standard settings (filters, single or multiple uses), see the Enhancement Spot Element Definitionstab 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.

BAdI method documentation:






rdisp/max_wprun_time - Maximum work process run time   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 3799 Date: 20240523 Time: 190749     sap01-206 ( 50 ms )