Hierarchy
SAP_APPL (Software Component) Logistics and Accounting⤷
PS-ST (Application Component) Structures⤷
PS_DBSYS_OPT (Package) Package to hold BADI's which call HANA artefacts
IMG Activity
| ID | PS_RESB_GR_OPT | BAdI: Optimization for GR and PO for Reservations |
| Transaction Code | S_EBJ_98000250 | (empty) |
| Created on | 20130212 | |
| Customizing Attributes | PS_RESB_GR_OPT | BAdI: Optimization for GR and PO for Reservations |
| Customizing Activity | PS_RESB_GR_OPT | BAdI: Optimization for GR and PO for Reservations |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | BADI_PS_RESB_GR_DBSYS_OPT |
Use
This Business Add-In (BAdI) is used for various Project Systems (PS-ST, PS-IS) components. You can use this BAdI to apply new database techniques for improving the performance in transactions CJ20N and CN41N.
You can use the corresponding BAdI method PS_GET_RESB_GR_DETAILS to read the overall quantity of goods received at the material component level. The method also returns the latest Goods Receipt date and the unit of measure of all Purchase Orders for a material component. This is done for all material components for a given list of networks.
Performance improvements from using new database techniques are expected to arise from:
- 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
Note that possible performance improvements depend on the available techniques in the chosen database.
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
BADI_PS_RESB_GR_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.
BAdI Implementations
The available SAP BAdI implementations read and aggregate data. The BAdI implementation BADI_PS_RESB_GR_DBSYS_OPT_IMPL is assigned to filter value #HDB# for the SAP HANA database. The BAdI implementation BADI_PS_RESB_GR_ANYDB_IMPL 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.
See also
BAdI method documentation:
For information about implementing such an optimization BAdI, see Optimization BAdIs
.
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 | 20130212 |
| SAP Release Created in |
