Mass Creation of Business Partners (BP) from Excel
Short answer: A custom program that mass creates organization business partners with general data, address, phone, email and roles (e.g. customer, vendor) from an Excel file through the standard BP BAPIs. Before loading, possible duplicates with the same name and postal code are searched; nothing is saved in test mode, and the result of each row is kept in a log.
- Estimated effort
- M · 5–7 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
Transaction BP creates business partners one at a time. The S/4HANA migration cockpit is designed for the initial data load; for hundreds of new dealers or suppliers during operations it does not offer a duplicate check and a simple Excel template. BP creation methods in LSMW are limited. This program enables operational bulk creation with a fixed template, a duplicate check and a test mode.
Who uses it? Master data management teams, sales and purchasing operations onboarding new dealer or supplier networks, and project teams transferring data in company mergers.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| BUT000Business Partner: General Data | Business partner general data; created through the BAPI and read for the duplicate check | Write | ECC + S/4 |
| BUT100Business Partner Roles | Business partner roles; added through the BAPI | Write | ECC + S/4 |
| BUT020Business Partner Addresses | Business partner address link; created through the BAPI | Write | ECC + S/4 |
| ADRCAddresses (Business Address Services) | Address and landline; written through the BAPI and read for the duplicate check | Write | ECC + S/4 |
| ADR6E-Mail Addresses (Business Address Services) | Email address; written through the BAPI | Write | ECC + S/4 |
| T005Countries | Postal code rule by country | Read | ECC + S/4 |
BAPIs and functions used
- BAPI_BUPA_CREATE_FROM_DATACreate Business Partner. Creates the business partner with general data and standard address
- BAPI_BUPA_ROLE_ADD_2Add Business Partner Role. Adds each role from the file to the business partner
- BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Saves a successful row permanently
- BAPI_TRANSACTION_ROLLBACKRoll Back BAPI Transaction. Rolls back changes in test mode or on error
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_FILE | Upload file (XLSX or CSV) | Single value | — | Yes | C:\temp\yeni_bayiler.xlsx |
| P_TEST | Test mode (check without saving) | Checkbox | — | No | X |
| P_DUP | Stop the row on a possible duplicate | Checkbox | — | No | X |
| S_ROLE | Allowed roles | Range / multiple | BUT100-RLTYP | No | FLCU00, FLCU01, FLVN00, FLVN01 |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Grouping | BUT000-BU_GROUP | Yes |
| 2 | Category | BUT000-TYPE | Yes |
| 3 | Name 1 | BUT000-NAME_ORG1 | Yes |
| 4 | Name 2 | BUT000-NAME_ORG2 | No |
| 5 | Search term | BUT000-BU_SORT1 | No |
| 6 | Street | ADRC-STREET | No |
| 7 | House number | ADRC-HOUSE_NUM1 | No |
| 8 | Postal code | ADRC-POST_CODE1 | No |
| 9 | City | ADRC-CITY1 | Yes |
| 10 | Country | ADRC-COUNTRY | Yes |
| 11 | Region | ADRC-REGION | No |
| 12 | Phone | ADRC-TEL_NUMBER | No |
| 13 | ADR6-SMTP_ADDR | No | |
| 14 | Roles | BUT100-RLTYP | No |
Sample upload file
| 1 | Grouping * | Category * | Name 1 * | Name 2 | Search term | Street | House number | Postal code | City * | Country * | Region | Phone | Roles | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | BP01 | 2 | Doğu Akdeniz Tarım Ürünleri A.Ş. | DOGUAKDENIZ | Turhan Cemal Beriker Blv. | 412 | 01120 | Adana | TR | 01 | +90 322 555 30 40 | [email protected] | FLCU00;FLCU01 | |
| 3 | BP02 | 2 | Trakya Metal Profil Ltd. Şti. | TRAKYAMETAL | Organize Sanayi 5. Cadde | 8 | 59500 | Tekirdağ | TR | 59 | +90 282 555 11 90 | [email protected] | FLVN00;FLVN01 | |
| 4 | BP01 | 2 | Orta Anadolu Yem Sanayi A.Ş. | Konya Şubesi | ORTAANADOLU | Fevzi Çakmak Mah. 10650 Sk. | 15 | 42050 | Konya | TR | 42 | +90 332 555 70 00 | FLCU00 |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Row | Calculated Row number in the file |
| 2 | Business partner | BUT000-PARTNER |
| 3 | Name | BUT000-NAME_ORG1 |
| 4 | Grouping | BUT000-BU_GROUP |
| 5 | City | ADRC-CITY1 |
| 6 | Roles added | BUT100-RLTYP |
| 7 | Possible duplicate | Calculated Existing business partner number with the same name 1 + postal code + city |
| 8 | Status | Calculated Success / Test / Stopped / Error |
| 9 | Message | Calculated BAPI return message or check error |
Sample result list
| Row | Business partner | Name | Grouping | City | Roles added | Possible duplicate | Status | Message |
|---|---|---|---|---|---|---|---|---|
| 1 | 1000712 | Doğu Akdeniz Tarım Ürünleri A.Ş. | BP01 | Adana | FLCU00;FLCU01 | Success | Business partner 1000712 created, customer 100713 synchronized | |
| 2 | Trakya Metal Profil Ltd. Şti. | BP02 | Tekirdağ | 1000588 | Stopped | A business partner with the same name and postal code exists | ||
| 3 | 1000713 | Orta Anadolu Yem Sanayi A.Ş. | BP01 | Konya | FLCU00 | Success | Email empty; business partner created |
How does the program work?
- The file is read; grouping, category, name 1, city and country are mandatory. Roles are a semicolon-separated list (e.g. FLCU00;FLCU01).
- Checks: does the postal code follow the country rule in T005, is the email format valid, are the roles in the allowed list.
- Duplicate check: a business partner with the same name 1 + postal code + city combination is searched through BUT000 and the standard address (BUT020/ADRC); depending on the selection the row is stopped or continues with a warning.
- General data and the standard address (including phone and email) are created with BAPI_BUPA_CREATE_FROM_DATA; the number is assigned by grouping.
- BAPI_BUPA_ROLE_ADD_2 is called for each role. With CVI active, customer/vendor roles create customer and vendor general data automatically.
- In test mode BAPI_TRANSACTION_ROLLBACK is called; in a real run BAPI_TRANSACTION_COMMIT is called when the row succeeded. The result is shown in ALV with business partner number, status and message; failed rows can be downloaded with the template.
Performance notes
Each row is processed in its own logical unit of work (LUW); a few thousand business partners are created in 10–20 minutes. Load existing names and postal codes into memory once for the duplicate check. Run large files in the background from a file on the application server.
Features
- Test mode (check without posting)
- ALV list (sort, filter, subtotals)
- Line-by-line result and error log
- Download failed lines as a separate file Failed or stopped rows can be downloaded in the same template and uploaded again.
- Runs as a background job
Authorization objects
- B_BUPA_GRPCreate in the business partner grouping (ACTVT 01)
- B_BUPA_RLTAdd business partner roles
Frequently asked questions
Are company code, sales area and purchasing data loaded too?
The basic version covers general data, address and roles; with CVI active, customer and vendor general data are created automatically. Company code (reconciliation account, payment terms), sales area and purchasing organization data can be added as an extension with extra template columns; this takes about three extra days.
Can tax numbers and bank details be loaded?
Yes, as an extension: tax numbers and bank accounts are written with the standard business partner interfaces in the same logical unit of work, and the duplicate check also uses the tax number. This takes about two extra days.
Can the program be used on ECC as well?
Yes. The BP BAPIs used also exist in ECC 6.0. If CVI is not active on ECC, only the business partner is created; customer and vendor records must be created separately.
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 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 …
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 program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.