08-21-2007 3:22 PM
Hi can any one let me know the logic for compare the two fields of different tables.
08-21-2007 4:00 PM
hi
good
IF it_1[] = it_2[].
" Tables contents are the same
ELSE.
" Tables contents are different
ENDIF.
If they have different structure, you probably must loop one of the tables, and inside read the other, then compare field by field.
Or if you don't need the contents (just comparing) you can do this, for example:
LOOP AT it_1 INTO wa_1.
READ TABLE it_2 WITH KEY field2 = wa_1-field2
field5 = wa_1-field5
TRANSPORTING NO FIELDS.
IF sy-subrc = 0.
" Record is on both tables (field2 and field5 are the fields in common for both tables).
ENDIF.
ENDLOOP.
thanks
mrutyun^
08-21-2007 3:25 PM
Hi Sudhir,
If you are talking about comparing two fields of different internal tables, then
LOOP ITAB1 into LS_ITAB1.
READ ITAB2 into LS_ITAB2 with key keyfield = LS_ITAB1-keyfield
BINARY SEARCH.
IF LS_ITAB1-field EQ LS_ITAB2-field.
" Enter your logic here
ENDIF.
ENDLOOP.
<b>Reward points for helpful answers.</b>
Best Regards,
Ram.
08-21-2007 3:27 PM
Hi ram
thank you, but i need to compare internal table field with data base table field, pelase advise.
08-21-2007 3:57 PM
hi
if u r validating the field of itab with db table then
select field
from itab into
<some variable of same type as field>
for all entries in <dbtable>
where field = dbtable-field
08-21-2007 3:59 PM
You can use Inner Join or For all entries option for your comparision.
Reward points if usefull.
Thanks,
Veeru.
08-21-2007 4:00 PM
hi
good
IF it_1[] = it_2[].
" Tables contents are the same
ELSE.
" Tables contents are different
ENDIF.
If they have different structure, you probably must loop one of the tables, and inside read the other, then compare field by field.
Or if you don't need the contents (just comparing) you can do this, for example:
LOOP AT it_1 INTO wa_1.
READ TABLE it_2 WITH KEY field2 = wa_1-field2
field5 = wa_1-field5
TRANSPORTING NO FIELDS.
IF sy-subrc = 0.
" Record is on both tables (field2 and field5 are the fields in common for both tables).
ENDIF.
ENDLOOP.
thanks
mrutyun^