Use of Views instead of base tables

Many 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 tables, so that the data can be filtered out directly, rather than specially coding for it.

Not recommended

            Select * from zcntry where cntry like ‘IN%’.

             Select single * from zflight where cntry = zcntry-cntry and airln = ‘LF’.

            Endselect.

Recommended

            Select * from zcnfl where cntry like ‘IN%’ and airln = ‘LF’.

            Endselect.

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

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