Ansicht
Dokumentation

ABENAMDP_VS_OPEN_SQL_ABEXA - AMDP VS OPEN SQL ABEXA

rdisp/max_wprun_time - Maximum work process run time   General Material Data  
This documentation is copyright by SAP AG.

- Comparison of SQLScript with

This example demonstrates the performance of SQL in AMDP when compared with .

Source Code

Execute

Description

The AMDP class CL_DEMO_AMDP_VS_OPEN_SQL has an AMDP method AMDP and the regular methods OPEN_SQL_NESTED_SELECT, OPEN_SQL_FOR_ALL_ENTRIES, and OPEN_SQL_SUBQUERY. All take the same data from database tables in the EPM model. These database tables can be filled using the program RS_EPM_DGC_HANA. Create the master data again here (X) and enter, for example, the values 100000 for Number of Sales Orders and 90000 for Number Delivered, plus a time interval of approximately three months.

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 OPEN_SQL_NESTED_SELECT uses nested SELECT statements and provides the worst result, as expected. However, the use of FOR ALL ENTRIES in OPEN_SQL_FOR_ALL_ENTRIES or the same subqueries in OPEN_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 OPEN_SQL_NESTED_SELECT

ABAP implementation of the method OPEN_SQL_FOR_ALL_ENTRIES

ABAP implementation of the method OPEN_SQL_SUBQUERY

CPI1466 during Backup   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 2107 Date: 20240419 Time: 071209     sap01-206 ( 42 ms )