Business Partner Address and Contact Data Completeness Report
Short answer: A custom ALV report that checks business partners' address, phone, email and tax number data for missing fields, postal codes that break the country's postal code rule and invalid email formats, and gives each record a completeness percentage. It gives the master data team a correction list before e-invoicing, e-delivery notes and bulk email campaigns.
- Estimated effort
- M · 4–5 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
Transaction BP shows each business partner one by one; there is no standard completeness list such as "business partners without email or tax number". The tables can be queried separately in SE16N, but address, contact and tax number are not combined in one row and postal code and email formats are not checked. The custom report runs these checks with rules and gives a completeness score.
Who uses it? Master data management, accounting and e-document owners, and sales and purchasing operations teams.
Closest standard alternatives
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: name, category, grouping, archiving flag (driving table) | — | ECC + S/4 |
| BUT100Business Partner Roles | Business partner roles for the selection | BUT100-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) | Address: street, postal code, city, country, landline | ADRC-ADDRNUMBER = BUT020-ADDRNUMBER | ECC + S/4 |
| ADR6E-Mail Addresses (Business Address Services) | Email addresses | ADR6-ADDRNUMBER = BUT020-ADDRNUMBER | ECC + S/4 |
| ADR2Telephone Numbers (Business Address Services) | Phone numbers (with mobile flag) | ADR2-ADDRNUMBER = BUT020-ADDRNUMBER | ECC + S/4 |
| DFKKBPTAXNUMTax Numbers for Business Partner | Tax numbers | DFKKBPTAXNUM-PARTNER = BUT000-PARTNER | ECC + S/4 |
| T005Countries | Postal code length and check rule by country | T005-LAND1 = ADRC-COUNTRY | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_PARTN | Business partner | Range / multiple | BUT000-PARTNER | No | — |
| S_GROUP | BP grouping | Range / multiple | BUT000-BU_GROUP | No | BP01, BP02 |
| S_RLTYP | BP role | Range / multiple | BUT100-RLTYP | No | FLCU01, FLVN01 |
| S_LAND | Country | Range / multiple | ADRC-COUNTRY | No | TR |
| S_TAXTP | Mandatory tax number types | Range / multiple | DFKKBPTAXNUM-TAXTYPE | No | — |
| P_EMAIL | Report missing or invalid email | Checkbox | — | No | X |
| P_PHONE | Report missing phone | Checkbox | — | No | X |
| P_ALL | Also show complete records | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Business partner | BUT000-PARTNER |
| 2 | Name | BUT000-NAME_ORG1 |
| 3 | Grouping | BUT000-BU_GROUP |
| 4 | Country | ADRC-COUNTRY |
| 5 | City | ADRC-CITY1 |
| 6 | Postal code | ADRC-POST_CODE1 |
| 7 | Street | ADRC-STREET |
| 8 | Phone | ADRC-TEL_NUMBER |
| 9 | ADR6-SMTP_ADDR | |
| 10 | Tax number | DFKKBPTAXNUM-TAXNUM |
| 11 | Missing / invalid fields | Calculated List of failed checks |
| 12 | Completeness % | Calculated Passed checks ÷ total checks × 100 |
Sample output
| Business partner | Name | Grouping | Country | City | Postal code | Street | Phone | Tax number | Missing / invalid fields | Completeness % | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000318 | Marmara Ambalaj San. Ltd. Şti. | BP02 | TR | İstanbul | 34953 | Organize Sanayi Bölgesi 3. Cadde | 6120458731 | Phone and email missing | 75 | ||
| 1000402 | Kuzey Yapı Malzemeleri Ltd. Şti. | BP01 | TR | Samsun | 551 | Sanayi Mah. 12. Sokak | +90 362 555 01 23 | [email protected] | Postal code must have 5 digits; tax number missing | 75 | |
| 1000455 | Akdeniz Makine A.Ş. | BP01 | TR | Antalya | 07190 | +90 242 555 44 10 | muhasebe@akdenizmakine | 3340987123 | Street missing; invalid email format | 75 | |
| 1000611 | Batı Lojistik Hizmetleri A.Ş. | BP02 | TR | İzmir | 35620 | Atatürk Cad. No: 41 | +90 232 555 77 00 | [email protected] | 8890123456 | None | 100 |
How does the report work?
- The selected business partners are read from BUT000; depending on the selection they are narrowed by BUT100 roles (e.g. only those with a customer or vendor role). Archived ones are excluded.
- The standard address number comes from BUT020; street, house number, postal code, city, region, country and landline phone are read from ADRC.
- The default email is added from ADR6 and the mobile phone from ADR2 (R3_USER = 3). The email format is checked by rule (one @, domain and extension).
- The postal code is validated against the country rule in T005 (LNPLZ length and PRPLZ check rule).
- The selected tax number types are read from DFKKBPTAXNUM; if a mandatory tax number is missing for an organization or the length rule fails, a finding is written.
- Completeness % = passed checks ÷ total checks × 100. The result is listed starting with the lowest completeness; double-clicking the business partner opens BP.
Performance notes
Narrow business partners by grouping and role; read address and contact tables in bulk with FOR ALL ENTRIES on the address numbers. Load the country rules into memory once. With large master data, run the report at night in the background and distribute the result as Excel.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the business partner opens BP.
- Export to Excel
- Runs as a background job
Authorization objects
- B_BUPA_GRPDisplay by business partner grouping
- B_BUPA_RLTDisplay by business partner role
Frequently asked questions
Can the check rules be changed?
Yes. Which fields are mandatory is kept per business partner grouping and role in a settings table. For example, bank details can be mandatory for vendors and email for customers; rules are added without changing the program.
Is it also checked that the tax number is actually valid?
The report checks format and length. If a validity query through an official service is needed, it can be added as a separate integration; it is assessed at installation against the current terms of that service.
What if business partners are not used on ECC?
On ECC, customer and vendor addresses are stored in the same address tables (ADRC, ADR6, ADR2). The report can be adapted to work with the KNA1/LFA1 address number; this takes about one extra day.
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
Customer/Vendor to Business Partner (CVI) Sync Check Report for S/4HANA Conversion
A custom ALV report that lists, before and after an S/4HANA conversion, customers and vendors not linked to a business partner, linked ones missing an …
Duplicate Business Partner Detection Report (Name, Tax Number, Address)
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, …
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.