Deletion of Duplicates
USE:
Deletion of Duplicates is an optional configuration for the comparison of the tables.
Suppose you want to make sure that unique records (based on fields' value) are compared. In that case, you can select fields for value comparison here. Records will be compared one by one, and only the first record with the same value will be kept for further processing. You can define the order of the records in the Sorting Criteria configuration.
If the configuration is not maintained, no action will be performed.
EXAMPLE:
Below is a sample configuration for the VBAK table:
In this case, VBAK records will be compared by values of the BSTNK field. The only first record with the same value will be kept for comparison.
VBELN | BSTNK | ERDAT | Kept/Removed |
---|---|---|---|
320 | Customer_PO_1 | 20210614 | Kept for Ref/Act comparison |
310 | Customer_PO_1 | 20210610 | Removed from Ref/Act comparison |
300 | Customer_PO_2 | 20210601 | Kept for Ref/Act comparison |
© 2017 - 2022 Int4 AG All rights reserved