Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

8 REPLIES 8

ThomasZloch
Active Contributor
0 Kudos

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

0 Kudos

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

0 Kudos

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

0 Kudos

Thanks Thomas i will surely try that

Former Member
0 Kudos

Hello,

DO 10 TIMES.

APPEND LINES OF itab FROM

0 Kudos

I will try the Append option,,,

Thanks

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks..to all