14. SELECT Statements

Question 1

Difference between SELECT statement and GET event

Answer 1

With GET the authorisation checks are carried out automatically. the SELECT statement does not carry out any authorisation checks. The programmer has to manually code the proper checks for authorisation on the database tables.

Question 2

The select statement can access data by three methods

Answer 2

• Single access with fully qualified key
  
  • Loop processing with restriction
  • Loop processing without restriction

Question 3

Where clause

Answer 3

is made up by comparing a table field to another field or to a value, using one of the relational operators shown above.

Question 4

SELECT SINGLE

Answer 4

statement allows accessing a single table entry.

Question 5

SY-SUBRC

Answer 5

Will be set to either of the following values after the SELECT statement finishes: 0 = Read was successful,4 = Record does not exist.

Question 6

WHERE clause

Answer 6

is to specify selection condition.

Question 7

RANGES statement

Answer 7

creates the identical internal table that is created in the DATA statement with the columns SIGN, OPTION, LOW, and HIGH.