topic Re: int table in Application Development and Automation Discussions

int table

Former Member — Wed, 07 Mar 2007 05:04:43 GMT

i want to retrieve 1 million records ,if we use select statement surely get dump...in that case how to retreive the data?

Re: int table

Former Member — Wed, 07 Mar 2007 05:06:54 GMT

Hi,

If you give the correct Key fields in where condition of the Select statement

it will fetch the Million record also wityhout any problem into internal table.

You can also use FIELD GROUPS instead of int Tables, if you feel that the data is too high.

Regards,

Anji

Re: int table

Former Member — Wed, 07 Mar 2007 05:08:46 GMT

HI,

Use the addition PACKAGE in your select statement. For reference refer to the select stmt in the standard program of the tcode 2KEE.

Regards

Subramanian

Re: int table

Former Member — Wed, 07 Mar 2007 05:10:21 GMT

try using package size and retreive

select * from ztable into itab package size 10000 where matnr eq 'XXXX'.

append itab.

endselect.

Message was edited by:

Chandrasekhar Jagarlamudi

Re: int table

Former Member — Wed, 07 Mar 2007 05:10:41 GMT

HI..

U will not get any dump in retreving 1 million records..

select statement will definitely fetch those all records..

But try to get the records which are needed to u only and keep the necessary conditions in where condition at select statement to get better performance

regards Rk

Re: int table

Former Member — Wed, 07 Mar 2007 05:12:07 GMT

Hi,

You can use the Pakage size option

select field1 field2 field3

from Tablename

into table it_tablename package size 10000.

Package size determines the Total # of records that will be picked up in the First loop.

loop at it_tablename.

write:/ it_tablename-field1,

it_tablename-field2.

endloop.

refresh it_tablename.

free it_tablename.

endselect.

In this way the first 10000 records are fetched written on to the screen, the memory is freed and the Internal table is ready for the second set to 10000 records.

Go through these links. it will be helpful to you,

http://www.sap-img.com/abap/performance-tuning-for-data-selection-statement.htm