Hierarchy
BBPCRM (Software Component) BBPCRM⤷
CRM (Application Component) Customer Relationship Management⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages⤷
WSOR (Package) IS-R: Assortments
IMG Activity
| ID | WSLI_DB_OPTIMIZATION | BAdI: Listing Optimization for Change Documents |
| Transaction Code | S_E17_83000030 | IMG Activity |
| Created on | 20130912 | |
| Customizing Attributes | WSLI_DB_OPTIMIZATION | BAdI: Listing Optimization for Change Documents |
| Customizing Activity | WSLI_DB_OPTIMIZATION | BAdI: Listing Optimization for Change Documents |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | WSLI_DB_OPTIMIZATIONS |
Use
This Business Add-In (BAdI) allows you to optimize the database access for the determination of change documents for listing conditions. 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 Display Change Documents for the Listing Conditions (transaction code WSLI).
The corresponding interface offers one method: READ_CDHDR_FROM_VIEW. This method can be used to read the change documents for the values entered on the selection screen. The input parameters IT_MATNR_RANGE, IT_ASORT_RANGE, IT_DATUM_RANGE, I_VKORG, and IVTWEG respectively contain the materials, assortments, dates, sales organization, and distribution channel that are entered on the selection screen. The parameter IT_MATNR_LIST contains a list of all the materials if the checkbox for variants/components is selected on the selection screen.
Note
This BAdI is intended exclusively for database providers. It allows them to optimize functions for their database that SAP has already optimized for SAP HANA, without making 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 WSLI_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 Implementation
The BAdI implementation WSLI_DBSYS_HDB uses an external view based on an SAP HANA object, instead of reading the data by using individual SELECT queries in the database. This BAdI implementation is assigned to filter value HDB.
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 | 20130918 |
| SAP Release Created in |
