# Business Partner Address and Contact Data Completeness Report

> 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.

- Type: Report, Custom development, ALV report
- Module: CA
- Estimated effort: M (4–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/business-partner-address-and-contact-data-completeness-report/


## 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.

### Closest standard alternatives

- BP: Shows address and contact data per business partner; no bulk completeness or format check.
- SE16N: Queries tables separately; no combination, rule check or completeness score.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| BUT000 | Business partner: name, category, grouping, archiving flag (driving table) | Read | - | ECC + S/4 |
| BUT100 | Business partner roles for the selection | Read | BUT100-PARTNER = BUT000-PARTNER | ECC + S/4 |
| BUT020 | Address number of the business partner | Read | BUT020-PARTNER = BUT000-PARTNER | ECC + S/4 |
| ADRC | Address: street, postal code, city, country, landline | Read | ADRC-ADDRNUMBER = BUT020-ADDRNUMBER | ECC + S/4 |
| ADR6 | Email addresses | Read | ADR6-ADDRNUMBER = BUT020-ADDRNUMBER | ECC + S/4 |
| ADR2 | Phone numbers (with mobile flag) | Read | ADR2-ADDRNUMBER = BUT020-ADDRNUMBER | ECC + S/4 |
| DFKKBPTAXNUM | Tax numbers | Read | DFKKBPTAXNUM-PARTNER = BUT000-PARTNER | ECC + S/4 |
| T005 | Postal code length and check rule by country | Read | T005-LAND1 = ADRC-COUNTRY | ECC + S/4 |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_PARTN | Business partner | Range / multiple | BUT000-PARTNER | No |
| S_GROUP | BP grouping | Range / multiple | BUT000-BU_GROUP | No |
| S_RLTYP | BP role | Range / multiple | BUT100-RLTYP | No |
| S_LAND | Country | Range / multiple | ADRC-COUNTRY | No |
| S_TAXTP | Mandatory tax number types | Range / multiple | DFKKBPTAXNUM-TAXTYPE | No |
| P_EMAIL | Report missing or invalid email | Checkbox | - | No |
| P_PHONE | Report missing phone | Checkbox | - | No |
| P_ALL | Also show complete records | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Business partner | BUT000-PARTNER |
| Name | BUT000-NAME_ORG1 |
| Grouping | BUT000-BU_GROUP |
| Country | ADRC-COUNTRY |
| City | ADRC-CITY1 |
| Postal code | ADRC-POST_CODE1 |
| Street | ADRC-STREET |
| Phone | ADRC-TEL_NUMBER |
| Email | ADR6-SMTP_ADDR |
| Tax number | DFKKBPTAXNUM-TAXNUM |
| Missing / invalid fields | Calculated: List of failed checks |
| Completeness % | Calculated: Passed checks ÷ total checks × 100 |

## How does the report work?

1. 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.
2. The standard address number comes from BUT020; street, house number, postal code, city, region, country and landline phone are read from ADRC.
3. 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).
4. The postal code is validated against the country rule in T005 (LNPLZ length and PRPLZ check rule).
5. 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.
6. Completeness % = passed checks ÷ total checks × 100. The result is listed starting with the lowest completeness; double-clicking the business partner opens BP.

## Authorization objects

- B_BUPA_GRP: Display by business partner grouping
- B_BUPA_RLT: Display 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=ca-business-partner-address-completeness
