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.
*   WHERE NOT AGE >= 20.
*   WHERE AGE NOT BETWEEN 10 AND 20.
*    WHERE ADDR LIKE 'HYD%'.
*    WHERE ADDR NOT LIKE 'HYD%'.
*     WHERE ADDR LIKE '%DER%'.
*     WHERE ADDR LIKE '__DER%'.
     WHERE ADDR IN ('HYD', 'HYDER', 'HYDERABAD', 'SEC').

    WRITE:/ ZSTUDENT-ROLLNO,ZSTUDENT-FNAME,ZSTUDENT-LNAME,
            ZSTUDENT-AGE, ZSTUDENT-CLASS,ZSTUDENT-ADDR.
ENDSELECT. 
 
 
Serkan AKKAVAK
Bilgisayar Mühendisi
serkurumsal@yandex.com