CA Report Custom development ALV report

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

  • BP Maintain Business Partner. Shows address and contact data per business partner; no bulk completeness or format check.
  • SE16N General Table Display. Queries tables separately; no combination, rule check or completeness score.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
BUT000Business Partner: General DataBusiness partner: name, category, grouping, archiving flag (driving table)—ECC + S/4
BUT100Business Partner RolesBusiness partner roles for the selectionBUT100-PARTNER = BUT000-PARTNERECC + S/4
BUT020Business Partner AddressesAddress number of the business partnerBUT020-PARTNER = BUT000-PARTNERECC + S/4
ADRCAddresses (Business Address Services)Address: street, postal code, city, country, landlineADRC-ADDRNUMBER = BUT020-ADDRNUMBERECC + S/4
ADR6E-Mail Addresses (Business Address Services)Email addressesADR6-ADDRNUMBER = BUT020-ADDRNUMBERECC + S/4
ADR2Telephone Numbers (Business Address Services)Phone numbers (with mobile flag)ADR2-ADDRNUMBER = BUT020-ADDRNUMBERECC + S/4
DFKKBPTAXNUMTax Numbers for Business PartnerTax numbersDFKKBPTAXNUM-PARTNER = BUT000-PARTNERECC + S/4
T005CountriesPostal code length and check rule by countryT005-LAND1 = ADRC-COUNTRYECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_PARTNBusiness partnerRange / multipleBUT000-PARTNERNo—
S_GROUPBP groupingRange / multipleBUT000-BU_GROUPNoBP01, BP02
S_RLTYPBP roleRange / multipleBUT100-RLTYPNoFLCU01, FLVN01
S_LANDCountryRange / multipleADRC-COUNTRYNoTR
S_TAXTPMandatory tax number typesRange / multipleDFKKBPTAXNUM-TAXTYPENo—
P_EMAILReport missing or invalid emailCheckbox—NoX
P_PHONEReport missing phoneCheckbox—NoX
P_ALLAlso show complete recordsCheckbox—No—

Output columns

#ColumnSource
1Business partnerBUT000-PARTNER
2NameBUT000-NAME_ORG1
3GroupingBUT000-BU_GROUP
4CountryADRC-COUNTRY
5CityADRC-CITY1
6Postal codeADRC-POST_CODE1
7StreetADRC-STREET
8PhoneADRC-TEL_NUMBER
9EmailADR6-SMTP_ADDR
10Tax numberDFKKBPTAXNUM-TAXNUM
11Missing / invalid fieldsCalculated List of failed checks
12Completeness %Calculated Passed checks ÷ total checks × 100

Sample output

Business partnerNameGroupingCountryCityPostal codeStreetPhoneEmailTax numberMissing / invalid fieldsCompleteness %
1000318Marmara Ambalaj San. Ltd. Şti.BP02TRİstanbul34953Organize Sanayi Bölgesi 3. Cadde6120458731Phone and email missing75
1000402Kuzey Yapı Malzemeleri Ltd. Şti.BP01TRSamsun551Sanayi Mah. 12. Sokak+90 362 555 01 23[email protected]Postal code must have 5 digits; tax number missing75
1000455Akdeniz Makine A.Ş.BP01TRAntalya07190+90 242 555 44 10muhasebe@akdenizmakine3340987123Street missing; invalid email format75
1000611Batı Lojistik Hizmetleri A.Ş.BP02TRİzmir35620Atatürk Cad. No: 41+90 232 555 77 00[email protected]8890123456None100
A view built with fictional sample data; not real system data.

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.

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

CA Package Custom

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 …

4 components · v1.0

Related reports

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.

Related report: Business Partner Address and Contact Data Completeness Report