how to compare the two same fields of different tables
Hi can any one let me know the logic for compare the two fields of different tables.
IF it_1 = it_2.
" Tables contents are the same
" Tables contents are different
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).