Hierarchy
SAP_APPL (Software Component) Logistics and Accounting⤷
LO-MD-MM (Application Component) Material Master⤷
WSTO (Package) Stock Overviews
IMG Activity
| ID | RWBE_DB_OPTIMIZATION | BAdI: Optimization for Retail Stock Overview |
| Transaction Code | S_E17_83000021 | (empty) |
| Created on | 20130821 | |
| Customizing Attributes | RWBE_DB_OPTIMIZATION | BAdI: Optimization for Retail Stock Overview |
| Customizing Activity | RWBE_DB_OPTIMIZATION | BAdI: Optimization for Retail Stock Overview |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | RWBE_DB_OPTIMIZATIONS |
Use
This Business Add-In (BAdI) allows you to optimize the database access for the determination of the open purchase order quantity and the open stock transport order quantity. The filter-dependent BAdI allows you to create separate implementations, depending on the database used. Separate coding can therefore be executed for each database. The BAdI is called during execution of transaction Stock Overview (transaction code RWBE).
The corresponding interface offers two methods: Method READ_OPEN_PO_QUANTITY can be used to read the open purchase order quantity for a set of materials. Method READ_OPEN_STK_TRANSP_ORDER_QTY provides the capability to read the open quantities from stock transport orders. Both methods offer the same importing parameters. The parameter IT_MATNR contains a set of materials where the open order quantities are selected. The parameter IT_WERKS contains all plants where the open order quantities are selected. As changing parameter a table is returned with the open order results.
Note
This BAdI is intended exclusively for database providers. It allows you to optimize functions that have already been optimized by SAP for SAP HANA for their database without modifications.
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).
To display the BAdI definition in SE18 choose BAdI Name and enter RWBE_DB_OPTIMIZATIONS.
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.
BAdI Implementations
The BAdI implementation RWBE_DBSYS_HDB is using external views based on SAP HANA objects instead of calling the function modules MB_ADD_PURCHASE_ORDER_QUANTITY and MATERIAL_QUANTITIES_ULBS. This BAdI implementation is assigned to filter value HDB.
Activities
Example
Business Attributes
| ASAP Roadmap ID | 257 | Create User Exits |
| 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 | 20130821 |
| SAP Release Created in |
