SAP ABAP IMG Activity RM07KOF2_ALV_DBSYS_O (BAdI: Stock Consistency Check)
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 RM07KOF2_ALV_DBSYS_O BAdI: Stock Consistency Check  
Transaction Code S_EX1_23000008   (empty) 
Created on 20120816    
Customizing Attributes RM07KOF2_ALV_DBSYS_O   BAdI: Stock Consistency Check 
Customizing Activity RM07KOF2_ALV_DBSYS_O   BAdI: Stock Consistency Check 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name RM07KOF2_ALV_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 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.

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

  • 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.

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 
Maintenance Objects
Maintenance object type E   Business Add-In - Definition 
History
Last changed by/on SAP  20120816 
SAP Release Created in 616