10. Retrieving data with select statements

Question 1

SQL

Answer 1

is a language specifically designed for use with relational database systems.

Question 2

SQL three main components

Answer 2

Data manipulation language (DML), data definition language (DDL) and data control language (DCL)

Question 3

Data manipulation language

Answer 3

For retrieving and updating information in the database.

Question 4

Data Definition Language (DDL)

Answer 4

For defining database objects and specifying the structure of the data in the database. In SAP, these functions are handled primarily by the ABAP Dictionary and the Database Utility.

Question 5

Data Control Language (DCL)

Answer 5

For controlling access to DML and DDL functions

Question 6

Data Control Language (DCL)

Answer 6

For controlling access to DML and DDL functions.

Question 7

The DML provides the four basic data operations

Answer 7

1. Select (retrieve)
   2. Insert
   3. Update
   4. Delete

Question 8

Open SQL

Answer 8

Open SQL is a subset of standard SQL with a specific syntax recognised by ABAP.

Question 9

SELECT STATEMENT

Answer 9

is used to read records from a database table.

Question 10

Tables statement

Answer 10

Serves two purposes: It declares to the program which ABAP Dictionary tables will be accessed.
and
It creates a work area where individual records from the table can be stored. The work area is an area in memory, just like a program variable, and it is sized so that it can hold exactly one record from the specified table.

Question 11

WHERE clause

Answer 11

The WHERE clause restricts the records that are retrieved from the database.

Question 12

SY-SUBRC

Answer 12

is set after each SELECT from the database. If at least one record was found that matched the selection criteria, SY-SUBRC is set to zero. Otherwise, SY-SUBRC is set to a non-zero value

Question 13

INTO

Answer 13

When selecting individual columns from a database table, an INTO clause is required. Data is not automatically placed into the corresponding fields of the table work area.

Question 14

INTO CORRESPONDING-FIELDS

Answer 14

The SELECT … INTO CORRESPONDING-FIELDS OF replaces coding the individual fields that the values are selected into from the database table and results in code that is easier to read without any performance losses.