topic Re: Internal Table in Application Development and Automation Discussions

Internal Table

Former Member — Wed, 24 Oct 2007 14:56:58 GMT

Hi Experts,

I have two internal tables with different structures.

In My first internal table have fields like,

EMP_ID, EMP_NAME, EMP_CITY, EMP_COUNTRY.

But In my Second Internal have the Structure like,

EMP_ID, EMP_NAME,

So Based on First Internal table's EMP_ID I need to get the EMP-NAME to my second Internal Table.

How Can I do This? Help me on this isssue.

Thanks in Advance,

Points Assured.

Re: Internal Table

SAPAI — Wed, 24 Oct 2007 15:00:34 GMT

Loop at the first internal table and read the second one based on the KEY EMP_ID.

Re: Internal Table

Former Member — Wed, 24 Oct 2007 15:01:10 GMT

Hi,

Here is pseudo logic,

SORT ITAB1 BY ID.

SORT ITAB2 BY ID.

LOOP AT ITAB2.

READ TABLE ITAB1 WITH KEY ID = ITAB2-ID.

IF SY-SUBRC EQ 0.

ITAB2-NAME = ITAB1-NAME.

MODIFY ITAB2 INDEX SY-TABIX TRANSPORTING NAME.

ENDIF.

ENDLOOP.

Hope this helps.

ashish

Re: Internal Table

former_member194669 — Wed, 24 Oct 2007 15:02:16 GMT

Hi,


sort itab2 by emp_id.
data : v_tabix like sy-tabix.
loop at itab1.
  v_tabix = sy-tabix.
  read table itab2 with key emp_id = itab1-emp_id
                                       binary search.
  if sy-subrc eq 0.
     move itab2-emp_name to itab1-emp_name.
     modify itab1 index v_tabix.  
  endif.
endloop.

a®

Re: Internal Table

Former Member — Wed, 24 Oct 2007 15:04:25 GMT

LOOP at itab2.

read table itab1 with key emp_id = itab2-emp_id.

itab2-emp_name = itab1-emp_name.

MODIFY itab2 INDEX sy-tabix.

ENDif.

Re: Internal Table

Former Member — Wed, 24 Oct 2007 15:07:43 GMT

fill the first one with data and read that with that key EMP_ID and fill the 2nd one.

loop at ITAB1.

read table itab2 with key emp_id = itab1-emp_id.

itab2-name = itab1-name.

append itab2.

clear itab2.

endloop.

Regards

Anji