Reading large amount of data from a database table

76 Views

Hi everyone,

I need to read large amount of records almost 1.5lakhs records from BKPF table into an internal table .i will upload many document no's from a text file in the selection screen and i need to read data related to these doc no's. when i use into table statement in select it is going into short dump saying this statement could not be executed since data in the database is huge.It also suggests to use for all entries option.even that doesn't work well. can anyone suggest a better option.my code

data : begin of i_bkpf occurs 0,

bukrs like bkpf-bukrs,

belnr like bkpf-belnr,

jahr like bkpf-gjahr,

blart like bkpf-blart,

bldat like bkpf-bldat,

budat like bkpf-budat,

monat like bkpf-monat,

xblnr like bkpf-xblnr,

stblg like bkpf-stblg,

bktxt like bkpf-bktxt,

waers like bkpf-waers,

kursf like bkpf-kursf,

end of i_bkpf.

select bukrs

belnr

gjahr

blart

bldat

budat

monat

xblnr

stblg

bktxt

waers

kursf

from bkpf

into table i_bkpf

where bukrs = p_bukrs

and gjahr in s_gjahr

and belnr in s_belnr.

if sy-subrc eq 0.

TAKE NO ACTION

endif.

Message was edited by:

KURUVELLA NAVEEN

Message was edited by:

KURUVELLA NAVEEN

Message was edited by:

KURUVELLA NAVEEN