Duplicate Business Partner Detection Report (Name, Tax Number, Address)
Short answer: A custom ALV report that finds cases where the same customer or vendor was created under more than one business partner number, using the tax number, a name comparison that normalizes Turkish characters and legal form suffixes, the address and the phone number. Likely duplicates are grouped with a match score and reason, so the master data team can quickly decide which record to keep.
- Estimated effort
- M · 5–7 working days
- System
- ECC and S/4HANA
- Tables
- 5
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
The duplicate check in transaction BP only runs when a new record is created and needs the address search service to be set up separately; it does not scan thousands of existing records and list the duplicates. Spelling differences such as "Atlas Ambalaj A.Ş." and "ATLAS AMBALAJ SANAYİ TİC. AŞ" stay separate records in the standard search. The custom report scans the whole master data, compares normalized names and returns duplicate groups with a score.
Who uses it? Master data management teams, accounting and purchasing master data owners, S/4HANA conversion projects.
Closest standard alternatives
- BP Maintain Business Partner. Can check for duplicates when a new record is created (needs the address search service); it does not scan existing records in bulk.
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| BUT000Business Partner: General Data | Business partner general data: type, grouping, name, creation (driving table) | — | ECC + S/4 |
| DFKKBPTAXNUMTax Numbers for Business Partner | Tax numbers; the strongest match criterion | DFKKBPTAXNUM-PARTNER = BUT000-PARTNER | ECC + S/4 |
| BUT020Business Partner Addresses | Address number of the business partner | BUT020-PARTNER = BUT000-PARTNER | ECC + S/4 |
| ADRCAddresses (Business Address Services) | Postal code, city, street and phone | ADRC-ADDRNUMBER = BUT020-ADDRNUMBER | ECC + S/4 |
| BUT100Business Partner Roles | Business partner roles (customer, vendor) | BUT100-PARTNER = BUT000-PARTNER | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_PARTNR | Business partner | Range / multiple | BUT000-PARTNER | No | — |
| S_BUGRP | Grouping | Range / multiple | BUT000-BU_GROUP | No | BP01, BP02 |
| S_TYPE | Partner category (1 person, 2 organization) | Range / multiple | BUT000-TYPE | No | 2 |
| S_CRDAT | Created on | Range / multiple | BUT000-CRDAT | No | — |
| S_CNTRY | Country | Range / multiple | ADRC-COUNTRY | No | TR |
| S_RLTYP | Role | Range / multiple | BUT100-RLTYP | No | FLCU01, FLVN01 |
| P_SCORE | Minimum match score | Single value | — | Yes | 60 |
| P_TAXON | Tax number matches only | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Duplicate group | Calculated Group number given to records that match each other |
| 2 | Business partner | BUT000-PARTNER |
| 3 | Name | BUT000-NAME_ORG1 |
| 4 | Grouping | BUT000-BU_GROUP |
| 5 | Tax number | DFKKBPTAXNUM-TAXNUM |
| 6 | City | ADRC-CITY1 |
| 7 | Postal code | ADRC-POST_CODE1 |
| 8 | Street | ADRC-STREET |
| 9 | Phone | ADRC-TEL_NUMBER |
| 10 | Roles | Calculated List of BUT100-RLTYP values |
| 11 | Created on | BUT000-CRDAT |
| 12 | Created by | BUT000-CRUSR |
| 13 | Match score | Calculated Tax no 100, name 60, similar name 40, address 30, phone 20 (best pair) |
| 14 | Match reason | Calculated Criteria that make up the score |
Sample output
| Duplicate group | Business partner | Name | Grouping | Tax number | City | Postal code | Street | Phone | Roles | Created on | Created by | Match score | Match reason |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1000245 | Atlas Ambalaj San. ve Tic. A.Ş. | BP02 | 1234567890 | İstanbul | 34775 | Ataşehir Bulvarı 12 | 0216 555 01 01 | FLCU01, FLVN01 | 03/14/2019 | MDVERI01 | 160 | Tax no + name |
| 1 | 1000981 | ATLAS AMBALAJ SANAYİ TİCARET AŞ | BP02 | 1234567890 | İstanbul | 34775 | Ataşehir Blv. No:12 | 0216 555 01 01 | FLVN01 | 07/02/2025 | SATINALMA03 | 160 | Tax no + name |
| 2 | 1001302 | Ege Kimya Ltd. Şti. | BP02 | 9876543210 | İzmir | 35410 | Gaziemir Sanayi Sitesi 4 | 0232 444 20 20 | FLCU01 | 11/20/2021 | MDVERI02 | 110 | Name + address + phone |
| 2 | 1001877 | EGE KIMYA LIMITED | BP02 | 9876543201 | İzmir | 35410 | Gaziemir San. Sit. 4 | 0232 444 20 20 | FLCU01 | 02/09/2026 | SATIS05 | 110 | Name + address + phone |
How does the report work?
- Business partners in the selection are read from BUT000 (type, grouping, creation date); records flagged for archiving (XDELE) are skipped.
- Name normalization: NAME_ORG1 (for persons NAME_FIRST + NAME_LAST) is converted to upper case, Turkish characters are folded (İ→I, Ş→S, Ğ→G, Ü→U, Ö→O, Ç→C), legal form suffixes (A.Ş., AŞ, LTD. ŞTİ., SAN. TİC. and so on), punctuation and spaces are removed.
- Tax numbers are read from DFKKBPTAXNUM; the same tax type and number is a strong match.
- The standard address is read from ADRC through BUT020: postal code, city, normalized street and phone.
- Score: same tax number 100, same normalized name 60, name similarity above the threshold 40, same postal code and street 30, same phone 20. Pairs above the score threshold are merged into duplicate groups.
- Roles (customer, vendor and so on) are added from BUT100, so it can be checked which record has open items or documents. The result is listed per group in ALV.
Performance notes
Run the name similarity comparison not over all pairs but within blocks that share the postal code, the city or the same normalized name prefix. On systems with hundreds of thousands of partners, run the report in the background; on a HANA database, fuzzy search can be used for name similarity.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the partner number opens BP in display mode.
- Export to Excel
- Runs as a background job
Authorization objects
- B_BUPA_GRPDisplay authorization by business partner grouping
- B_BUPA_RLTDisplay authorization by business partner role
Frequently asked questions
Does the report merge duplicate records?
No, it only lists them. The master data team decides which record to keep; the other one is blocked or flagged for archiving. For records with open items, accounting has to clean up first.
Does this report work on ECC too?
Yes, on ECC systems that use business partners it works with the same tables. For ECC systems that still keep customer and vendor master data in KNA1/LFA1, the same logic can be adapted to those tables; this is often requested as a clean-up before an S/4HANA conversion.
How is name similarity measured?
The edit distance (Levenshtein) between the normalized names is calculated and converted into a percentage similarity based on length. The default threshold is 85% and can be changed on the selection screen.
Packages that include this solution
Business Partner Master Data Quality Pack
A four-component pack for keeping customer and vendor master data clean: mass business partner creation from Excel with a duplicate check, duplicate …
Related reports
Business Partner and Vendor Bank Details Change Control Report
A custom ALV report that lists every change to business partner or vendor bank details (IBAN, account, bank key, account holder) in a period with old …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.