Reading large amount of data from a database table

[Former Member]

Hi everyone,

I need to retrieve large amount of records almost 1.5lakhs records from BKPF 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.

Message was edited by:

KURUVELLA NAVEEN

Message was edited by:

KURUVELLA NAVEEN

[Former Member · Accepted solution]

Hi,

You have to have an input file parameter. ( no copy/paste in selection screen )

Then you read your file and do the select in BKPF.

If you guess that this will required a lot of ressources, run your abap in bckgrnd, and also use : Open Dataset...,Transfer...,Close Dataset statements to handle your input file.

Hope this helps,

Erwan