topic Re: move using index in Application Development and Automation Discussions

move using index

Former Member — Tue, 20 Nov 2007 05:50:55 GMT

hai

Using move statement i want to move the records from internal table to another using index.

is it possible, let me know

actually my requirement is that my final table is having mroe than 2 lakhs but excel can capture 60000 records only so i have to create no of excel files based on no of records, in this case each time i have to move 60000 records to another internal table and then i have to call gui_download.

madhavi

Re: move using index

Former Member — Tue, 20 Nov 2007 05:53:58 GMT

create a counter and sort it loop it using index

Re: move using index

Former Member — Tue, 20 Nov 2007 05:55:38 GMT

i cann't use move statement in this scenario

Re: move using index

Simha_ — Tue, 20 Nov 2007 05:56:48 GMT

Hi,

Read the no of records and based on the records u can divide , how many entries ur itab has to handle.

U can use loop at itab where <cond>.

in condition u have to use index from and to.

The specification TO is only possible with standard tables and sorted tables. The specification only accepts table rows after table index idx2. For idx2, a data object of the type i is expected. If the value of idx2 is smaller or equal to 0, then the loop will not be passed. If the value is larger than the number of table rows, then the value will be set to the number of rows. If idx2 is smaller than idx1, then the loop is not passed as well.

Cheers,

SImha.

Re: move using index

former_member195698 — Tue, 20 Nov 2007 06:06:18 GMT

You can use APPEND statement for moving data from one internal table to a TEMP internal table.

APPEND LINES OF <itab1> [FROM <n1>] [TO <n 2>] TO <itab2>.

n1 and n2 will be variable which you can increment accordingly

ITAB1 will be your main table and ITAB2 will be your temp table to which you will move 60000 entries and then download.

Regards,

Abhishek

Message was edited by:

Abhishek Jolly