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

comparing two internal tables

Former Member — Fri, 22 Aug 2008 09:06:57 GMT

how to compare two internal tables based on specific fields?

Re: comparing two internal tables

Former Member — Fri, 22 Aug 2008 09:11:46 GMT

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/comparing%2btwo%2binternal%2btables%2b-%2ba%2bgeneric%2bapproach

Re: comparing two internal tables

Former Member — Fri, 22 Aug 2008 09:11:54 GMT

Hi!

Check out these links...

Regards

Tamá

Re: comparing two internal tables

Former Member — Fri, 22 Aug 2008 09:16:33 GMT

hi Mathew Parera

chk this sample code

Entries: 100 (ITAB1), 1000 (ITAB2)
Line width: 100
Both tables sorted by key K

LOOP AT ITAB1 INTO WA1.

LOOP AT ITAB2 INTO WA2

WHERE K = WA1-K.

" ...

ENDLOOP.

Entries: 1000 (ITAB1), 300 (ITAB2)
Line width: 100
Both tables sorted by unique key K ascending

LOOP AT ITAB1 INTO WA1.

READ TABLE ITAB2 INTO WA2

WITH KEY K = WA1-K BINARY SEARCH.

IF SY-SUBRC = 0.

" ...

ENDIF.

ENDLOOP.

regards

Deva

Re: comparing two internal tables

Former Member — Fri, 22 Aug 2008 09:18:55 GMT

Hi,

plz try this way :

sort : itab1 by num,

itab2 by num.

loop at itab1.

read table itab2 with key num = itab1-num binary search.

if sy-subrc = 0.

flag = 'X'.

else.

exit.

endif.

hope this helps.

thanx,

dhanashri.

Re: comparing two internal tables

Former Member — Fri, 22 Aug 2008 09:25:58 GMT

Try it this way:

loop at itab1 into wa1.

  describe table itab2 lines w_line.
  
 do w_line times.

   read table itab2 into wa2 index counter.

   if wa2-field = wa1-field.
   .........
   endif.
  counter = counter + 1.  
 enddo.
endloop.

With luck,

Pritam.

Re: comparing two internal tables

Former Member — Fri, 22 Aug 2008 09:34:18 GMT

Hi,

Try this.

Loop at itab1 into wa_itab.

read table itab2 into wa_itab2 with key f1 = wa_itab1-f1.

if sy-subrc eq 0.

< carry out ur requirement>

endif.

endloop.

Sharin.

Re: comparing two internal tables

Former Member — Fri, 22 Aug 2008 09:35:02 GMT

hi,

check out this code. i am giving the raw idea to compare internal table field.

types: begin of gs_vbak,

vbeln TYPE vbak-vbeln,

erdat TYPE vbak-erdat,

end of gs_vbak.

data: it_vbak type standard table of gs_vbak,

wa_vbak type gs_vbak.

****************************************************

types: begin of gs_vbap,

VBELN type vbap-VBELN, "sales order

MATNR type vbap-MATNR, "material no

ARKTX type vbap-ARKTX, "material description

end of gs_vbap.

data: it_vbap type standard table of gs_vbap,

wa_vbap type gs_vbap.

****************************************************

select-options: s_vbeln for vbak-vbeln.

select vbeln

erdat

kunnr

ernam from vbak into table it_vbak where vbeln in s_vbeln.

select VBELN

MATNR

ARKTX

from vbap into table it_vbap up to 20 rows.

loop at it_vbak into wa_vbak.

read table it_vbap into wa_vbap INDEX sy-index.

if wa_vbak-vbeln = wa_vbap-vbeln.

write: 'vbeln for both table are equal'.

elseif wa_vbak-vbeln GT wa_vbap-vbeln.

write: -

else.

write: -

endif.

endloop.