how to write a select query to get 200000 rows from database

[Former Member]

how to write a select query to get 200000 rows from database

[Former Member]

select * from <table > into table <internal table >

up to 200000 rows.

[Former Member]

thnx srinivas

[Former Member]

HI,

IF u fetch huge amount of data it will reduce ur program performance go for pacakage size format of select query

syntax

*SELECT * FROM spfli INTO TABLE it_spfli PACKAGE SIZE 10000.*

go throu this link

[http://sap-img.com/abap/package-size.htm]

Regards,

priya

[Former Member]

hi priya

thnx for ur reply

u mean to say it may go to dump when we are fetching huge data?

[Former Member]

HI,

To select 20,000 rows from the table use the following select query

SELECT <f1> <f2> from <table name> into table <internal tab> upto 20000 rows.

Regards,

vineela.