Slide 33 of 60

SELECT Statement

You use the SELECT statement to read the entries in a database table.

• You can display the table structure (field names, field characteristics) via the ‘i’ pushbutton. Also, if you double-click a table name in the Editor, the table structure displays with a listing of the fields in the table.
  
• You address the fields of a table with the table name followed by the field name.
  
• This example contains only the simple basic form of the SELECT statement. More comprehensive forms of the statement are examined in subsequent lessons.
  
• The SBOOK table is a table of flight bookings that is used in exploring ABAP/4 programming in these lessons and is included in the IDES training data.

Authored by: Roger Hayen © Central Michigan Univeristy and/or © SAP America, Inc. All rights reserved.