Use of ABAP Sort instead of Order By

The order by clause is executed on the database server, while the sort statement is executed on the application server. Thus instead of giving the order by in the select clause statement, it is better to collect the records in an internal table and then use the sort command to sort the resulting data set.

===================================================================================

This tutorial contains a number of pages, each one explaining a tip or trick. You can either browse them one by one (click on the NEXT button, or jump straight to a tip or trick which interests you:

• Introduction

• Selection criteria

• Aggregate functions

• Views instead of base tables

• The "into table" clause

• Modifying a group of lines

• Use of binary search option

• Appending two internal tables

• Table buffering

• Use of "for all" entries

• Proper structure of "where" clause

• Proper use of "move" statement

• Proper use of "inner join"

• Use of "ABAP Sort" instead of "Order By"

• Tools for analysis of performance