Skip to Content
0
Former Member
Jul 01, 2009 at 05:40 AM

Problem while fetching more records in SAP ABAP report program

120 Views

Hello Frinds,

I have SAP ABAP report program which fetches data from usr02 table

Now, program is working fine with less number of records, bot in production there are more than 200000 records and either report gets timed out or there is run time error like buffer area not available.

Below is the fetch statement

SELECT bname FROM usr02 INTO TABLE lt_user

So, do I need to take records in small chunks, I do not think it is needed as I have worked on number of othere databases where there are number of records in single fetch statement and database itself take care of this.

Please provide me some approach to resolve this problem.