help on Ranges

Hi all,

I am using Ranges table R_HKONT. When i am selecting data from table using R_HKONT it is not retreiving any values.

This is R_HKONT table

E |BT |12999996 |12999999

E |EQ |16999999 |

E |EQ |34999999 |

I |BT |10000000 |10999998

I |BT |12000000 |14099998

I |BT |15099999 |17099998

I |BT |20000000 |20059998

I |BT |30000000 |30999998

I |BT |33000000 |33999998

I |BT |34000000 |35999998

I |BT |39000000 |39999998

I |BT |41000000 |41999998

The query i am using is

SELECT HKONT WAERS BUKRS

FROM BSIS

INTO TABLE I_TEST

WHERE BUKRS = 'ABC' AND

HKONT IN R_HKONT AND

WAERS <> 'USD'.

THEN SY-SUBRC IS 4.

However when i using all the data from the R_HKONT table and input it manualy through se11 and Run it gives me all the required values. I think may be Query is wrong

please help me in this.

Thanx in adv.