topic Re: appending two internal tables in Application Development and Automation Discussions

appending two internal tables

Former Member — Fri, 21 Dec 2007 16:00:37 GMT

hi friends,

i met with a situation, where i have to join 3 tables using the common fields using inner join.

i wrote 2 select statements and added contents to two different internal tables.

Re: appending two internal tables

former_member156446 — Fri, 21 Dec 2007 16:07:19 GMT

I dint find a question in ur post..

but if you are looking to append that two internal table.. if the structures are same then say

> append lines of itab1 to itab2 ( structure of both need to be >same)

Re: appending two internal tables

RoySayak — Fri, 21 Dec 2007 16:07:46 GMT

loop at one internal table and append it to the other.

or use INTO APPENDING TABLE T_XXXX in the second select statement.

Thnaks

Sayak

Re: appending two internal tables

former_member194669 — Fri, 21 Dec 2007 16:09:08 GMT

if 2 internal fields are same then


appending lines of i_tab1 to i_tab2.


if fields are not same


loop at i_tab1
  v_tabix = sy-tabix.
  read table i_tab3 with key <key fields of i_tab1>
  if sy-subrc eq 0.
    move corresponding fields i_tab1 to i_tab3.
    modify i_tab3 index v_tabix..
  else.
    move corresponding fields i_tab1 to i_tab3.
    append i_tab3.    
 endif.
endloop.

loop at i_tab2
  v_tabix = sy-tabix.
  read table i_tab3 with key <key fields of i_tab2>
  if sy-subrc eq 0.
    move corresponding fields i_tab2 to i_tab3.
    modify i_tab3 index v_tabix..
  else.
    move corresponding fields i_tab2 to i_tab3.
    append i_tab3.    
 endif.
endloop.

After this I_tab3 cotnains the combined results of i_tab1 & I_tab2

a®

Re: appending two internal tables

Former Member — Fri, 28 Dec 2007 06:11:57 GMT

Thanks for your suggestions. i have reached the solution.