Select Statements in SAP ABAP
Select statements are used to read data from database table using SAP ABAP programming in SAP, there are different types of select statements in SAP ABAP to read data from database, the below are some of the select statements with examples. 1.Select Single: REPORT ZSELECT_SINGLE . TABLES: MARA. SELECT SINGLE * FROM MARA WHERE MATNR = '100-100'. WRITE:/ MARA-MATNR, MARA-MATKL, MARA-MTART. 2.Select Up To : REPORT ZSELECT_UPTO . TABLES: MARD. SELECT * FROM MARD UP TO 1 ROWS WHERE MATNR = '100-100'. WRITE:/ MARD-MATNR, MARD-WERKS, MARD-LGORT, MARD-LABST. 3.Select Where : REPORT ZSELECT_WHERE . TABLES: ZSTUDENT. SELECT * FROM ZSTUDENT * WHERE AGE = 20. * WHERE AGE <> 20. * WHERE AGE >= 20 AND CLASS <= 40. * WHERE FNAME = 'ABC' OR LNAME = 'AAA'. * WHERE NOT AGE = 20. ...