• For SELECT-OPTIONS statement, the system creates a selection table. The purpose of selection tables is to store complex selection limits in a standardized manner. Their main purpose is to transfer the selection criteria directly to database tables using the WHERE clause of Open SQL statements. Selection table It is an internal table(with name <seltab>) with a header line. Its line structure is a field string of four components,

* SIGN : The data type of SIGN is C with length 1. Possible values are I and E.

* OPTION : The data type of OPTION is C with length 2.
OPTION contains the selection operator.

• If HIGH is empty, you can use EQ, NE, GT, LE,
LT,CP, and NP.

• If HIGH is filled, you can use BT and NB.

* LOW : The data type of LOW is the same as the column type of the database table, to which the selection criterion is attached.

* HIGH : The data type of HIGH is the same as the column type of the database table, to which the selection criterion  is attached.




The SELECT-OPTIONS statement has several variants which are:

SELECT-OPTIONS <seltab> FOR <f> DEFAULT <g> [TO <h>]

SELECT-OPTIONS <seltab> FOR <f> ... NO-EXTENSION .....

SELECT-OPTIONS <seltab> FOR <f> ... NO INTERVALS .....

SELECT-OPTIONS <seltab> FOR <f> .. NO DATABASE

SELECTION……..

SELECT-OPTIONS <seltab> FOR <f> ... NO-DISPLAY ..............

SELECT-OPTIONS <seltab> FOR <f> ... LOWER CASE ..............

SELECT-OPTIONS <seltab> FOR <f> ... OBLIGATORY ..............

SELECT-OPTIONS <seltab> FOR <f> ... MEMORY ID  <pid>..........

SELECT-OPTIONS <seltab> FOR <f> ... MODIF ID <key>...........

SELECT-OPTIONS <seltab> FOR <f> ... MATCHCODE OBJECT <obj>...