Batch Duplicate Checking (Window Batch Matching) - trillium_quality - 17.1

The /TRILLIUM/WINDOWMATCH report is developed by Trillium Quality to perform duplicate checking for the existing addresses in an SAP database.

The process utilizes the index keys from the table /TRILLIUM/ADRIDX to extract records with the same key and compare them. The result of the process is a report showing potential duplicates listed by index key.

To initialize the batch duplicate checking

1. Call the /TRILLIUM/WINDOWMATCH report by either:

   • Using transaction /nSA38 – ABAP Editor

   • Selecting ABAP Editor from the SAP Tools menu (Tools > ABAP workbench > Development > ABAP Editor).

2.    Enter the program name /TRILLIUM/WINDOWMATCH in the Program field and click  to run the program.

   The Batch Window Matching window opens.

   Figure 1. Batch Window Matching

3. Enter the required parameters, as described in the table below.

   Table 1. Batch Window Matching Fields

   Field	Value	Description
   Business Object	Radio button	Application database table of the business object type to be processed.   nBusiness Partners nCustomers nVendors nPlants
   Window Key ID	Numeric	The window key ID used to extract the data for the batch duplicate checking.  Defaults to Window Key ID 10.
   Window Key	Text	The window key value.  A range of window key values can be entered and processed for the window key ID selected.
   Show unmatched addresses	Yes/No	Defaults to unchecked.  Check the selection to show both matched and unmatched addresses.

4. After the Batch Window Matching report is processed, a list of potential duplicates is presented. The figure below depicts a sample list and Table: Batch Matching Duplicate List Fields describes the columns in the list.

   Figure 2. Batch Matching Duplicate List