Compare two tables and display different entries
The example program select in the source table infoobjects from the table rsdiobj which are active in the system. The target table select all infoobjects from the table rsdiobj. The comparison class creates an internal table with a color column to display the color in an ALV grid.
As you see in the below, the source table has all active records and the target table has active, modified and delivered records. The result is that all delivered and modified records are displayed in red because they do not appear in the source table.
Per default the key fields of the table will be choosen to compare the data. But you can add own key fields you want to consider. Just fill the paramter it_key_fields.
You can display the data directly in an ALV grid (default: false) or export it and use it in your logic for further analysis.
The method compare_tables has the following parameter:
- it_table_old
- it_table_new
- it_key_fields
- iv_display
- et_table
SELECT * FROM rsdiobj INTO TABLE @DATA(lt_source) WHERE objvers = 'A'.
SELECT * FROM rsdiobj INTO TABLE @DATA(lt_target).
NEW zcl_compare_tables( )->compare_tables( it_table_old = `your_source_table`
it_table_new = `your_target_table`
iv_display = rs_c_true ).This is the result of an ALV grid
If you find one or something isn't working, just open an issue.