Kontakt

Ansicht
Dokumentation

RM07KOF2_ALV_DBSYS_O - BAdI: Stock Consistency Check

RM07KOF2_ALV_DBSYS_O - BAdI: Stock Consistency Check

ROGBILLS - Synchronize billing plans   Fill RESBD Structure from EBP Component Structure  
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 MB5K.

Transaction MB5K 'Stock Consistency Check' compares the overall quantities in valuation tables MBEW, EBEW, and QBEW with the overall quantities from various stock tables such as MARD, MARC, and MSSA. The material number as well as the valuation area can be used as selection criteria. The report issues detailed information if the overall quantities from the valuation and the stock tables do not match.

You can use the corresponding BAdI method CALCULATE_TOTALS to read valuation quantities and stock quantities 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

  • RM07KOF2_ALV_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_RM07KOF2_ALV_DBSYSOPT is assigned to filter value 'HDB' for the SAP HANA database. The BAdI implementation ES_IM_RM07KOF2_ALV_DBSYSOPTANY 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   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 3467 Date: 20240523 Time: 205354     sap01-206 ( 53 ms )