topic Re: comparing field data in two itabs in Application Development and Automation Discussions

comparing field data in two itabs

Former Member — Mon, 10 Nov 2008 09:54:00 GMT

Hi All

Iu2019m calling on FM and it returns tab ITAB1 (with fields user,data, tcode & etc.). I have another structure Itab2 (with fields sing, option, low & high). Now I want to check each row in Itab2 is in the Itab2 range or not. And finally I want to save in another Itab.

Suggest me in ABAP statements,

Regards,

Re: comparing field data in two itabs

Former Member — Mon, 10 Nov 2008 10:02:23 GMT

Loop at itab1 .

Read table itab2 with key ( Comparing fields ).

If sy-subrc eq o.

Move what ever your require in the 3rd itab.

Append itab3.

clear itab3.

endif.

endloop.

Re: comparing field data in two itabs

Former Member — Mon, 10 Nov 2008 10:03:22 GMT

declare a range r_range and pass the values of itab2 to r_range.

loop at itab1 into wa_itab1.

if wa_itab1-data in r_range .

els.

endif.

endloop.

regards,

Ramya

Re: comparing field data in two itabs

JozsefSzikszai — Mon, 10 Nov 2008 10:03:44 GMT

for example you can use:

LOOP AT ITAB1 INTO ... WHERE field IN itab2.

==> this value of field is in itab2

ENDLOOP.

Re: comparing field data in two itabs

Former Member — Mon, 10 Nov 2008 10:06:08 GMT

data: itab3 like table of itab1 with header line.

loop at itab1.

    read table  itab2 with table key  <condition>.
       if sy-subrc = 0.
         move itab1 to itab3.       
       endif .
enloop.

Hope this logic will help ful

Regards

Srinivasu

Edited by: srinivasu bv on Nov 10, 2008 11:06 AM

Re: comparing field data in two itabs

Former Member — Mon, 10 Nov 2008 10:39:05 GMT

Hi Srinivas,

Sorry for asking this question.

In ur replay, in Read stat I need to write some contion. But the confustion is Itab1 contains a field Tcode but Itab2 contain fields Low & High (as Tcode fields).

So, How can i write a condition at this case. Plz help me on this.

Thnks.

Re: comparing field data in two itabs

Former Member — Mon, 10 Nov 2008 10:43:00 GMT

Hi Sandya

Give the Declerations of itab1 and itab2 internal tabels

then it is easy to understand your requiremnt

Regards

Re: comparing field data in two itabs

Former Member — Mon, 10 Nov 2008 10:52:42 GMT

REPORT ZSRK_035 .

DATA : BEGIN OF ITAB1 OCCURS 0,

USER LIKE USR01-BNAME,

DATA(30),

TCODE LIKE TSTC-TCODE,

END OF ITAB1.

DATA : BEGIN OF ITAB2 OCCURS 0,

SIGN,

OPTION(2),

LOW LIKE TSTC-TCODE,

HIGH LIKE TSTC-TCODE,

END OF ITAB2.

ITAB2-SIGN = 'I'.

ITAB2-OPTION = 'BT'.

ITAB2-LOW = 'MM01'.

ITAB2-HIGH = 'MM03'.

APPEND ITAB2.

CLEAR ITAB2.

ITAB1-USER = SY-UNAME.

ITAB1-DATA = 'AAAAAAAAAAAA'.

ITAB1-TCODE = 'VA01'.

APPEND ITAB1.

CLEAR ITAB1.

ITAB1-USER = SY-UNAME.

ITAB1-DATA = 'BBBBBBBBBBBB'.

ITAB1-TCODE = 'MM02'.

APPEND ITAB1.

CLEAR ITAB1.

ITAB1-USER = SY-UNAME.

ITAB1-DATA = 'CCCCCCCCCCCCCCC'.

ITAB1-TCODE = 'MM01'.

APPEND ITAB1.

CLEAR ITAB1.

ITAB1-USER = SY-UNAME.

ITAB1-DATA = 'DDDDDDDDDDDDD'.

ITAB1-TCODE = 'VA02'.

APPEND ITAB1.

CLEAR ITAB1.

ITAB1-USER = SY-UNAME.

ITAB1-DATA = 'EEEEEEEEEEEE'.

ITAB1-TCODE = 'MM03'.

APPEND ITAB1.

CLEAR ITAB1.

LOOP AT ITAB1 WHERE TCODE IN ITAB2.

WRITE : / ITAB1-DATA.

ENDLOOP.

Re: comparing field data in two itabs

Former Member — Mon, 10 Nov 2008 12:11:49 GMT

Hi Ramy,

Can you explain a little bit clearly. I hope this process will solve my problem.

Thkx