BC170_2.05.1
Retrieving Data with SELECT
Statements
BC170_2.05.2
Objectives
•
The participants will be able to:
–
Retrieve information from the database
using Open SQL
–
Create basic Select statements for use in
ABAP Code
–
Describe the system field SY-SUBRC and
properly use it in an ABAP Program.
BC170_2.05.3
Retrieving Information From the
Database
DB
Data
John
Sm
ith
Ma
ry
Sti
les
BC170_2.05.4
Open SQL
•
Portable across various databases
•
A subset of standard SQL
BC170_2.05.5
The Basic SELECT Statement
DB
Mary
Stiles
John Smith
Work Area
SELECT <fields> FROM <table
name> […..]
ENDSELECT.
TABLES: <table name>.
BC170_2.05.6
Example Using the SELECT
Statement
TABLES: KNA1.
SELECT KUNNR
NAME1
INTO (KNA1-KUNNR,
KNA1-NAME1)
FROM KNA1.
WRITE: / KNA1-KUNNR, KNA1-NAME1.
ENDSELECT.
BC170_2.05.7
The SELECT Statement with a
WHERE Clause
TABLES: KNA1.
SELECT KUNNR
NAME1
INTO (KNA1-KUNNR,
KNA1-NAME1)
FROM KNA1
WHERE KTOKD = ‘0001’.
WRITE: / KNA1-KUNNR, KNA1-NAME1.
ENDSELECT.
BC170_2.05.8
SY-SUBRC
TABLES: KNA1.
SELECT KUNNR
NAME1
INTO (KNA1-KUNNR,
KNA1-NAME1)
FROM KNA1
WHERE KTOKD = ‘0001’.
WRITE: / KNA1-KUNNR, KNA1-NAME1.
ENDSELECT.
IF SY-SUBRC <> 0.
WRITE: / ‘No records found.’.
ENDIF.
BC170_2.05.9
INTO CORRESPONDING
FIELDS
TABLES: KNA1.
SELECT KUNNR
NAME1
FROM KNA1
INTO CORRESPONDING FIELDS
OF KNA1.
WRITE : / KNA1-KUNNR, KNA1-NAME1.
ENDSELECT.
IF SY-SUBRC <> 0.
WRITE: / ‘No records found.’.
ENDIF.
BC170_2.05.10
Summary
•
The participants should be able to:
–
Retrieve information from the database
using Open SQL
–
Create basic Select statements for use in
ABAP Code
–
Describe the system field SY-SUBRC and
properly use it in an ABAP Program