Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
I am created one classical report with selection option, the selection option have ranges, if i give the range ( My data are very very huge ) its giving dump error of Times out.. so how to rectify the error.. urgent..
There is a restriction for SELECT clause WHERE condition for not to exceed some 999 criteria. So the solution is, Loop to your RANGES1 table and populate other RANGES2 table until the count reaches to 800. Then Write the Select Clause using RANGES2 table and then Refresh it. Check the below code.
data count type i.
data itab like VBAK occurs 0 with header line.
clear count.
clear RANGES2.
refresh RANGES2.
loop at RANGES1.
count = count + 1.
append RANGES1 to RANGES2.
if count = 800.
SELECT * from vbak appending table itba where XXX in RANGES2.
clear RANGES2.
refresh RANGES2.
clear count.
endif.
endloop.
if count > 1.
SELECT * from vbak appending table itba where XXX in RANGES2.
I am created one classical report with selection option, the selection option have ranges, if i give the range ( My data are very very huge ) its giving dump error of Times out.. so how to rectify the error.. urgent..
There is a restriction for SELECT clause WHERE condition for not to exceed some 999 criteria. So the solution is, Loop to your RANGES1 table and populate other RANGES2 table until the count reaches to 800. Then Write the Select Clause using RANGES2 table and then Refresh it. Check the below code.
data count type i.
data itab like VBAK occurs 0 with header line.
clear count.
clear RANGES2.
refresh RANGES2.
loop at RANGES1.
count = count + 1.
append RANGES1 to RANGES2.
if count = 800.
SELECT * from vbak appending table itba where XXX in RANGES2.
clear RANGES2.
refresh RANGES2.
clear count.
endif.
endloop.
if count > 1.
SELECT * from vbak appending table itba where XXX in RANGES2.
Bluesky
