topic Re: Splitting a large internal table....... in Application Development and Automation Discussions

Splitting a large internal table.......

Former Member — Fri, 06 Jun 2008 11:39:59 GMT

Hi all,

i want to split an internal table of say 1,00,000 entries into 10 internal tables having 10,000 each....

is there a way to move say first 20,000 entries from one internal table to another...based on index...

Thanks in advance,,,

Best Regards,

Sushil.

Re: Splitting a large internal table.......

ThomasZloch — Fri, 06 Jun 2008 11:45:20 GMT

try

APPEND LINES OF itab1 FROM idx1 TO idx2 TO itab2.

you can put this inside a loop and adjust idx1 and idx2 accordingly.

Greetings

Thomas

Re: Splitting a large internal table.......

Former Member — Fri, 06 Jun 2008 11:49:32 GMT

Hello,

DO 10 TIMES.

APPEND LINES OF itab FROM

Re: Splitting a large internal table.......

Former Member — Fri, 06 Jun 2008 11:50:57 GMT

Looping wont be a good option i guess.... since the source table is having more than 8,50,000 records.....

Re: Splitting a large internal table.......

Former Member — Fri, 06 Jun 2008 11:52:01 GMT

I will try the Append option,,,

Thanks

Re: Splitting a large internal table.......

ThomasZloch — Fri, 06 Jun 2008 11:53:21 GMT

Sorry for being unclear, I was talking about a DO n TIMES loop where n = number of table lines divided by desired package size.

e.g. 800,000 / 20,000 = 40

Greetings

Thomas

Re: Splitting a large internal table.......

Former Member — Fri, 06 Jun 2008 11:55:14 GMT

Thanks Thomas i will surely try that

Re: Splitting a large internal table.......

Former Member — Fri, 06 Jun 2008 11:55:22 GMT

for example <itab>this holds 100 records.

itab1[] = itab[]

delete itab1 from 10 to 100.

itab2[] = itab[]

delete itab2 from 20 to 100

delete itab2 from 1 to 10

itab3[] = itab[]

goes on

itab4[] = itab[]

itab5[] = itab[]

itab6[] = itab[]

itab7[] = itab[]

itab9[] = itab[]

Edited by: Anbu B on Jun 6, 2008 1:56 PM

Edited by: Anbu B on Jun 6, 2008 2:12 PM

this will help u lot...........

Reward IF.................

Regards

Anbu

Edited by: Anbu B on Jun 6, 2008 2:12 PM

Re: Splitting a large internal table.......

Former Member — Fri, 06 Jun 2008 12:04:06 GMT

Thanks..to all