Use of the into table clause of select statement

Instead 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: int_fligh.

            Select * from zflight into int_fligh.

             Append int_fligh. Clear int_fligh.

            Endselect.

Recommended

            Refresh: int_fligh.

            Select * from zflight into table int_fligh.

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

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