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.