CA Program Custom development Mass upload

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

  • BP Maintain Business Partner. Creates business partners one at a time; no bulk load or duplicate check.
  • LSMW Legacy System Migration Workbench. General data transfer tool; recording methods for BP are limited and it offers no duplicate check.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
BUT000Business Partner: General DataBusiness partner general data; created through the BAPI and read for the duplicate checkWriteECC + S/4
BUT100Business Partner RolesBusiness partner roles; added through the BAPIWriteECC + S/4
BUT020Business Partner AddressesBusiness partner address link; created through the BAPIWriteECC + S/4
ADRCAddresses (Business Address Services)Address and landline; written through the BAPI and read for the duplicate checkWriteECC + S/4
ADR6E-Mail Addresses (Business Address Services)Email address; written through the BAPIWriteECC + S/4
T005CountriesPostal code rule by countryReadECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
P_FILEUpload file (XLSX or CSV)Single value—YesC:\temp\yeni_bayiler.xlsx
P_TESTTest mode (check without saving)Checkbox—NoX
P_DUPStop the row on a possible duplicateCheckbox—NoX
S_ROLEAllowed rolesRange / multipleBUT100-RLTYPNoFLCU00, 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.

#ColumnTarget fieldRequired
1GroupingBUT000-BU_GROUPYes
2CategoryBUT000-TYPEYes
3Name 1BUT000-NAME_ORG1Yes
4Name 2BUT000-NAME_ORG2No
5Search termBUT000-BU_SORT1No
6StreetADRC-STREETNo
7House numberADRC-HOUSE_NUM1No
8Postal codeADRC-POST_CODE1No
9CityADRC-CITY1Yes
10CountryADRC-COUNTRYYes
11RegionADRC-REGIONNo
12PhoneADRC-TEL_NUMBERNo
13EmailADR6-SMTP_ADDRNo
14RolesBUT100-RLTYPNo

Sample upload file

1Grouping *Category *Name 1 *Name 2Search termStreetHouse numberPostal codeCity *Country *RegionPhoneEmailRoles
2BP012Doğu Akdeniz Tarım Ürünleri A.Ş.DOGUAKDENIZTurhan Cemal Beriker Blv.41201120AdanaTR01+90 322 555 30 40[email protected]FLCU00;FLCU01
3BP022Trakya Metal Profil Ltd. Şti.TRAKYAMETALOrganize Sanayi 5. Cadde859500TekirdağTR59+90 282 555 11 90[email protected]FLVN00;FLVN01
4BP012Orta Anadolu Yem Sanayi A.Ş.Konya ŞubesiORTAANADOLUFevzi Çakmak Mah. 10650 Sk.1542050KonyaTR42+90 332 555 70 00FLCU00
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1RowCalculated Row number in the file
2Business partnerBUT000-PARTNER
3NameBUT000-NAME_ORG1
4GroupingBUT000-BU_GROUP
5CityADRC-CITY1
6Roles addedBUT100-RLTYP
7Possible duplicateCalculated Existing business partner number with the same name 1 + postal code + city
8StatusCalculated Success / Test / Stopped / Error
9MessageCalculated BAPI return message or check error

Sample result list

RowBusiness partnerNameGroupingCityRoles addedPossible duplicateStatusMessage
11000712Doğu Akdeniz Tarım Ürünleri A.Ş.BP01AdanaFLCU00;FLCU01SuccessBusiness partner 1000712 created, customer 100713 synchronized
2Trakya Metal Profil Ltd. Şti.BP02Tekirdağ1000588StoppedA business partner with the same name and postal code exists
31000713Orta Anadolu Yem Sanayi A.Ş.BP01KonyaFLCU00SuccessEmail empty; business partner created
A view built with fictional sample data; not real system data.

How does the program work?

  1. The file is read; grouping, category, name 1, city and country are mandatory. Roles are a semicolon-separated list (e.g. FLCU00;FLCU01).
  2. Checks: does the postal code follow the country rule in T005, is the email format valid, are the roles in the allowed list.
  3. 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.
  4. General data and the standard address (including phone and email) are created with BAPI_BUPA_CREATE_FROM_DATA; the number is assigned by grouping.
  5. BAPI_BUPA_ROLE_ADD_2 is called for each role. With CVI active, customer/vendor roles create customer and vendor general data automatically.
  6. 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

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 program 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: Mass Creation of Business Partners (BP) from Excel