Document toolboxDocument toolbox

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.

VBELNBSTNKERDATKept/Removed
320Customer_PO_120210614Kept for Ref/Act comparison
310Customer_PO_120210610Removed from Ref/Act comparison
300Customer_PO_220210601Kept for Ref/Act comparison

© 2017 - 2022 Int4 AG All rights reserved