SAP articles
71 tutorials, cross-tagged with 17 SAP modules.
SAP ABAP Performance Tuning - Proper Structure of the WHERE Clause
When a base table has multiple indices, the where clause should be in the order of the index, either a primary or a secondary index.To choose an index, the optimizer checks the field names specified i...
SAP ABAP Performance Tuning - Use of FOR ALL Entries
Outer join can be created using this addition to the where clause in a select statement. It speeds up the performance tremendously, but the cons of using this variation are listed below 1. Duplicates...
SAP ABAP Performance Tuning - Using Table Buffering
Use of buffered tables is recommended to improve the performance considerably. The buffer is bypassed while using the following statements Select distinct Select … for update Order by, group by,...
SAP ABAP - Appending Internal Tables
Appending 2 internal tables Instead of using the normal loop-endloop approach for this kind of programming, use the variation of the append command. Care should be taken that the definition of both t...
SAP ABAP - Use of Binary Search Option
Use of binary search optionWhen a programmer uses the read command, the table is sequentially searched. This slows down the processing. Instead of this, use the binary search addition. The binary sear...
SAP ABAP - Modifying a Group of Lines
Modifying a group of lines of an internal tableUse the variations of the modify command to speed up this kind of processing. Not recommended Loop at int_fligh. If int_fligh-flag is initial. Int_fligh-...
SAP - Using the Into Table Clause
Use of the into table clause of select statementInstead of appending one record at a time into an internal table, it is advisable to select all the records in a single shot.Not recommended Refresh: in...
SAP - Using Views instead of Base Tables
Use of Views instead of base tablesMany times ABAP programmers deal with base tables and nested selects. Instead it is always advisable to see whether there is any view provided by SAP on those base t...
SAP - Using Aggregate Functions
Use the already provided aggregate functions, instead of finding out the minimum/maximum values using ABAP code.Not recommended Maxnu = 0. Select * from zflight where airln = 'LF' and cntry =...
SAP ABAP - Use of selection criteria
Instead of selecting all the data and doing the processing during the selection, it is advisable to restrict the data to the selection criteria itself, rather than filtering it out using the ABAP code...
SAP ABAP Performance Tuning Tips & Tricks Introduction
Need for performance tuningIn this world of SAP programming, ABAP is the universal language. In most of the projects, the focus is on getting a team of ABAP programmers as soon as possible, handing ov...