topic Re: problem in internaltable in Application Development and Automation Discussions

problem in internaltable

Former Member — Mon, 05 Jan 2009 14:33:26 GMT

hi folks,

i have 2 internal tables like itab1 and itab2.

itab1 say zkna1 with 5 fields one field say kunnar

itab2 say zkna2 with one field say zkna2-kunnner.

i would like to get the all data for kunnr data from zkna1

put into zkna2.

here both are internal tables.

how can we solve this problem.

thank u

advance

Re: problem in internaltable

Former Member — Mon, 05 Jan 2009 14:41:06 GMT

Hi Sailaja,

do the following:

1) select data from the kna1 into it_kna1

2) loop it_kna1 into wa_kna1.

wa_kna2-kunnr2 = wa_kna1-kunnr1.

append wa_kna2 to it_kna2.

clear wa_kna1.

endloop.

Solves your problem.

Thanks!!

Re: problem in internaltable

former_member191735 — Mon, 05 Jan 2009 15:44:27 GMT

Loop at internal table ZKNA1 and move them to ZKNA2.

Re: problem in internaltable

tarangini_katta — Mon, 05 Jan 2009 15:52:33 GMT

HI sailiaja,

Aparna solution will solve u r problem.

I am agrre with aparna.

Thanks,

Re: problem in internaltable

Former Member — Mon, 05 Jan 2009 18:44:46 GMT

Hi,

You can try this statement..

insert lines of itab1 <condition> into itab2 <condition>.

Regards

Vasavi Kotha

Re: problem in internaltable

Former Member — Tue, 06 Jan 2009 09:33:09 GMT

thanks aparna

my problem is solved.

thanks a lot.

Re: problem in internaltable

Former Member — Tue, 06 Jan 2009 09:40:38 GMT

No need to fetch data into another internal table

Straight away loop at zkna1 into wa_kna1.

wa_kna2=wa_kna1.

append wa_kna2 to zkna2.

clear wa_kna2.

endloop.

this will help and will improve performance.

regards

prashant.

Re: problem in internaltable

Former Member — Tue, 06 Jan 2009 09:46:48 GMT

Loop on the 1st internal table and move the kunnr filed values from 1st internal table to second internal table, you will get the entire data of kunnr from 1st internal table to 2nd internal table.

Re: problem in internaltable

Former Member — Tue, 06 Jan 2009 10:01:21 GMT

Hi,

Try this,

Loop i_kna1 into wa_kna1.

wa_kna2-kunnr = wa_kna1-kunnr.

append wa_kna2 to i_kna2.

clear: wa_kna1, wa_kna2.

endloop.

Regards,

Joan