Skip to Content
0
Former Member
Feb 19, 2009 at 09:38 PM

Select Query - Optimized Way

19 Views

Hello ABAP Gurus..

I dont have much idea about ABAP side but we have a requirement in our project where we need to fetch huge amount of data from backend and display it on the WebDynpro Java screen. I was going through the paging solution provided by SAP so that we can minimize the Java AS server memory and performance issues.

I was wondering if we can get the selective no of records from tables based on pagesize. What I mean here:

Suppose total no of record that I want to display on the WebDynpor screen is say 10000.

PageSize of my webdynpro table = 100 records

Now Can I write a select query (or is there any other way) to get data from backened table pagewise like at first hit I get records from 1 - 100, second hit I should get records from 101 - 200 , third hit from 201 - 300.. and so on till the lat record?

Is it possible? If yes, how can I acheive this?

-Abhinav