WHERE - BETWEEN

Syntax

... col [NOT] BETWEEN dobj1 AND dobj2 ...

Effect

This expression is true if the content of the column col lies (not) between the values of data objects dobj1 and dobj2 (interval limits enclosed). You can define no column descriptor for the interval limits.

Example

Readout of all flights within the next 30 days.

DATA sflight_tab TYPE TABLE OF sflight.
DATA date        TYPE d.

date = sy-datum + 30.

SELECT carrid connid fldate
       FROM sflight
       INTO CORRESPONDING FIELDS OF TABLE sflight_tab
       WHERE fldate BETWEEN sy-datum AND date.