How to use less or between as condition in read table clause ?

hi Ricky,

yes, you can't use read along with operators like GE, LE. Better using Loop instead.

WHILE and ENDWHILE is also supported, you can check this.

regards,

jimmy.

ricky luo,

You cannot use such logical operators in read statements. If you are reading the internal table with unique key field probably you can have IF Condition check after READ statement.

Suggestion: Why don'y you use FOR ALL ENTRIES in your query and try using this less than condition using WHERE keyword.

Regards!

You ask: READ TABLE itab less or between as condition is not allowed?

YES

You ask: I have to use loop instead?

YES

EDIT: instead of LOOP AT, if your internal table is of type SORTED (or is standard + sort + BINARY SEARCH), you may do an approximate positioning.

Example:

KEY   FR   TO  VAL
FR    B    D   1
FR    E    G   2
FR    H    J   3
GB    A    Z   4 

Code:

DATA itab TYPE SORTED TABLE OF ty_line WITH UNIQUE KEY key fr.
...
READ TABLE itab WITH KEY key = 'FR' fr = 'F' TRANSPORTING NO FIELDS.
DATA(index) = COND i( WHEN sy-subrc <> 0 THEN sy-tabix - 1 ELSE sy-tabix ).
ASSERT index = 2. " just to demonstrate what is expected for F
IF index > 0.
  DATA(line) = itab[ index ].
  IF line-key = 'FR'. " Important to test again the first part of the key
    " Right line is found
  ENDIF.
ENDIF.

Try this.

  SELECT
    RACCT  
    RFAREA  
    HSLVT 
   INTO  TABLE IT_ITAB
   FROM FAGLFLEXT
   WHERE RYEAR  = P_YEAR
   AND RLDNR  = '0L'
   AND RRCTY  = '0'
   AND RBUKRS = P_BUKRS.
SORT it_itab BY racct rfarea.

  SELECT
           BUKRS
           ZFIITEM
           ZFISUIT
           ZFITEXT
           ZFISIGN
           ZFITYPE
           ZFIRAFR
           ZFIRATO
           ZFIFUAR
           ZFIITFR
           ZFIITTO
   FROM ZTFI03
   INTO CORRESPONDING FIELDS OF TABLE IT_ZAFS_FI_01
   WHERE BUKRS = P_BUKRS .
LOOP AT IT_ITAB INTO data(IT_ITAB_l) group by ( key1 = IT_ITAB_l-racct  key2 =  IT_ITAB_l-rfarea ) .
LOOP AT IT_ZAFS_FI_01 WHERE ZFIFUAR = IT_ITAB_1-rfaera
                        AND ZFIRAFR < IT_ITAB_1-racct
                        AND ZFIRATO > IT_ITAB_1-racc.
"Fill what you need
   EXIT.
ENDLOOP.
ENDLOOP.