SELECT..ENDSELECT command
The select command is the most fundamental function of writing ABAP programs allowing the retrieval of data from SAP database tables. Below is an example of how to retrieve data using the SELECT..ENDSELECT command.
REPORT ZSELECTCOMMAND.
*Select... endselect command
data: it_ekko type STANDARD TABLE OF ekko,
wa_ekko like line of it_ekko,
it_ekpo type standard table of ekpo,
wa_ekpo like line of it_ekpo.
SELECT ebeln BUKRS BSTYP BSART
FROM ekko
INTO wa_ekko.
APPEND wa_ekko TO it_ekko.
ENDSELECT.
write:/ 'SELECT... endselect command'.
loop at it_ekko into wa_ekko.
write:/ wa_ekko-ebeln.
endloop.
Related Articles
ABAP DELETE statement keyword to delete data from SAP internal and database tables
ABAP DESCRIBE statement keyword to get information about tables and fields
PERFORM TABLES command passing internal table as parameter
ABAP read command to read line of internal table in SAP
ABAP UPDATE command to modify database field values
AUTHORITY-CHECK abap Statement / command
ABAP delete command in SAP
ABAP MODIFY statement to update SAP data within database and internal tables
ABAP WRITE statement command with in SAP to display data report to users
SAP ABAP Statement syntax including basic implementation code
Concatenate ABAP statement syntax for concatenating data objects, sting values or rows of an SAP internal table
ABAP EXPORT data TO MEMORY ID and import it back again
IF, CHECK & WHEN ABAP commends example source code and information
Call Function module IN BACKGROUND TASK - Execute abap code in seperate background process
Function module IN UPDATE TASK statement - Execute abap code in seperate unit of work
ABAP STRLEN command to get the value length of a SAP field
SAP ABAP SELECT command and its different uses
ABAP FOR ALL ENTRIES SELECT statement addition in SAP data retrieval
ABAP SELECT inner join statement to select from two tables at the same time
SELECT directly into an internal table
SELECT directly into an internal table when field order is different
Function module STARTING NEW TASK statement - Execute abap code in seperate work process
