Ansicht
Dokumentation
ABENAMDP_VS_ABAP_SQL_ABEXA - AMDP VS ABAP SQL ABEXA
Vendor Master (General Section) TXBHW - Original Tax Base Amount in Local CurrencyThis documentation is copyright by SAP AG.
- Comparison of SQLScript with
This example demonstrates the performance of SQL in AMDP when compared with .
Source Code
Description
The AMDP class CL_DEMO_AMDP_VERSUS_ABAP_SQL has an AMDP method AMDP and the regular methods ABAP_SQL_NESTED_SELECT, ABAP_SQL_FOR_ALL_ENTRIES, and ABAP_SQL_SUBQUERY, which all get the same data from database tables in the EPM model. These database tables can be filled using the program RS_EPM_DGC_HANA. The master data must be created again here (X) and, for example, the values 100000 for Number of Sales Orders and 90000 for Number Delivered, plus a time interval of approximately three months must be entered.
The example program selects a random date from the existing change data and uses it to make the selections. The selections pick invoices paid on this date, plus the associated business partners and product information.
The method ABAP_SQL_NESTED_SELECT uses nested SELECT statements and provides the worst result, as expected. However, the use of FOR ALL ENTRIES in ABAP_SQL_FOR_ALL_ENTRIES or the same subqueries in ABAP_SQL_SUBQUERY as in AMDP demonstrates that AMDP does not provide any performance benefits as long as only SQL is implemented that can also be expressed in .
SQLScript Implementation of the Method AMDP
ABAP Implementation of the Method ABAP_SQL_NESTED_SELECT
ABAP Implementation of the Method ABAP_SQL_FOR_ALL_ENTRIES
ABAP Implementation of the Method ABAP_SQL_SUBQUERY
CL_GUI_FRONTEND_SERVICES - Frontend Services BAL_S_LOG - Application Log: Log header data
This documentation is copyright by SAP AG.
Length: 2137 Date: 20240418 Time: 021737 sap01-206 ( 39 ms )