int table

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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