topic Splitting Large internal tables in Application Development and Automation Discussions

Splitting Large internal tables

Former Member — Fri, 26 Dec 2008 11:15:15 GMT

Hi All,

How to split large internal table into smaller ones of fixed number of lines.

The total number of lines are not known and is subjected to vary.

Regards,

Naba

Re: Splitting Large internal tables

vinod_vemuru2 — Fri, 26 Dec 2008 11:23:51 GMT

HI,

Check below logic.


DESCRIBE TABLE i_main LINES l_lines.
IF l_lines GT 100.
l_num = l_lines / 100.
ENDIF.
l_start = 1.
l_end = 100.
DO l_num TIMES.
APPEND LINES OF i_main FROM l_start TO l_end INTO i_subtab.
Process ur subtab.
ADD 100 TO: l_start, l_end.
IF l_end GT l_lines.
l_end = l_lines.
ENDIF.
CHECK l_start GT l_lines.
EXIT.
ENDDO.

Thanks,

Vinod.

Re: Splitting Large internal tables

Former Member — Fri, 26 Dec 2008 11:29:54 GMT

I am not sure about your requirements, you try with the below solution

Itab : contains all entries let us say 3000

Itab1

itab2

itab3

No.of entries to be split based on 3000/n ( 3000/3) = 1000

split_val = 1000

N_split_from = 1

N_split_to = 1000

APPEND LINES OF ITAB1 FROM N_split_from TO N_split TO ITAB1.

N_split_from = 1 + split_val

N_split_to = 1000 + split_val

APPEND LINES OF ITAB1 FROM N_split_from TO N_split TO ITAB2.

N_split_from = 1 + split_val

N_split_to = 1000 + split_val

APPEND LINES OF ITAB1 FROM N_split_from TO N_split TO ITAB3.

Regards

Sasi