ERROR: DBIF_RSQL_INVALID_RSQL

[Former Member]

Hi,

001590   FORM get_data.                
001600                                 
     >     SELECT *                    
001620        FROM kna1                
001630        INTO TABLE ta_kna1       
001640       WHERE kunnr IN so_kunnr.  

In so_kunnr I set 3200 customers..this is the problem..

What is the maximum values in select option, so_kunnr ??

tnx, Adibo.

[Former Member]

I think values are populated in so_kunnr-low only .. try to give

values in a range ..

The limit is around 1500 ...

[Former Member]

hi do like this..

loop at s_kunnr .

r_ranges-low = s_kunnr-low.

r_ranges-sign = 'I'.

r_ranges-option = 'EQ'.

r_ranges-high = s_kunnr-high.

append r_ranges.

endloop.

SELECT * FROM kna1

INTO TABLE ta_kna1

WHERE kunnr IN r_ranges.

[vinod_vemuru2]

Hi Adibo,

There should not be any limit for select options.

But for range to be used in select query there is limitation

of 2000 entries. Probably same thing is applied gere also

If u have more than 200 entries in range and if u use it select query u will get this dump. Try to split ur select option into different ranges in chunks of 2000. Use appending table of

addition of select to get all the records into single table.

Hope this will be helpfull...

Thanks,

Vinod.