Skip to Content
0
Former Member
Sep 22, 2005 at 07:37 AM

runtime error in SQL statement

48 Views

hello,

I have a runtime during selection from database table due to large ranges in where condition. for example:

select * from cosp into corresponding

fields of table gt_cosp

where objnr in r_objnrs

and lednr = lv_lednr

and versn = p_vercost

and wrttp = lv_wrttp

and gjahr in r_gjahr

and kstar in r_kstar.

The suggested solution is to use internal table instead of a range and use "for all entries" or to divide the ranges to smaller units.

As you see I have few ranges and this solution could be not effective in this case.

Do you have a better idea?

Thanks in advance,

Far