SAP S/4HANA Business Partner Conversion – Merge Customer and Vendor into single Business Partner
In prepearation of a technical S/4HANA conversion it is mandatory to convert (CVI conversion) Customers and Vendors into Business Partners. Maybe you struggle with merge of Customer and Vendor into one Business Partner at CVI conversion. This Blog post is about to clarify how to merge Customers and Vendors into one Business Partner and what the result of this merge is.
This CVI conversion has to be processed in ECC environment as a preparation step for technical S/4HANA conversion. CVI Cockpit will guide you through this process. More information about CVI Cockpit you will find in blog post
New CVI Cockpit – Enabling Movement to SAP S/4HANA through seamless BP Synchronization
It might happen that it is needed to merge Customers and Vendors into one Business Partner. In this case the Business Partner represents a legal entity from legal point of view. This legal entity is characterized with
- A single address
- A single communication data
- Several bank accounts
- Several contact persons
- Several credit cards
Target audience: Functional expert, Development expert
Version: SAP ECC 6.0 or higher
At the following example Customer is the leading object. That means Customer data is the main information in regards to address and numbering (dependent on same number set up). If you decide to use Venbdor as leading object, start with Vendor conversion.
As the initial situation there are Customers and Vendors in the system. Usually Customer and Vendor master data is linked with cross reference. Meaning Customer number is stored at Vendor master (field LFA1-KUNNR) and Vendor number is stored at Customer master (field KNA1-LIFNR). If this link is not established yet, this will be a requisit. If this link is not available, alternatively address data can be used. Usually address data for the same legal entity is 100% equal at Customer and Vendor master data. That’s why uing Address data is much more complex and similiar to a duplicate check.
Separated Customer and Vendor master data with Contact Persons and bank accounts.
All 4 synchronization directios have to be activated in customizing:
- Customer -> BP
- Vendor -> BP
- BP -> Customer
- BP -> Vendor
You have to implement your own Enhancement Implementation of BAdI CVI_CUSTOM_MAPPER. With SAP note
an example Implementation CVI_MAP_LEGAL_ENTITY is available at methods
This delivered implementation is a POC only, because following data has to be 100% equal:
- Customer/Vendor has to be linked via LFA1-KUNNR and KNA1-LIFNR as foundation
- Address data
I’ve never seen a system where address data of Customer and Vendor are the same. That’s why you have to create your own matching criteria in your own implementation. You can use standard implementations as template and do your own adjustments. Pay attention to inline documentation at each step. This will help you to decide which steps to take over.
Foundation is the assignment of Customer/Vendor with fields KNA1-LIFNR and LFA1-KUNNR. Sometimes it is enough to just use these assignment to merge Customer and Vendor to one Business Partner.
Conversion steps with MDS_LOAD_COCKPIT
Convert Customer to Business Partner
>Business Partner with Customer role has been created. Business Partner for each contact person and relationship to Customer Business Partner has been created.
Convert Vendor to Business Partner
Vendor data as of Vendor role, Contact Persons, relationships and bank accounts has been added to Customer Busines Partner. Business Partner has now the full set of Customer and Vendor data as foundation for reverse synchronization.
Convert Business Partner to Customer
Business Partner data inclusive vendor information as of Vendor Contact Persons and bank accounts are synchronized into Customer master.
Convert Business Partner to Vendor
Business Partner data inclusive Customer information as of Customer Contact Persons and bank accounts are synchronized into Vendor master.
All 3 data objects, Customer, Business Partner and Vendor, are synchronized now.
Note for S/4HANA: Please pay attention to activate implementation CVI_ASSIGN_CUST_VEND of BAdI CVI_CUSTOM_MAPPER to provide customer number to vendor (LFA1-KUNNR) and vendor number to customer (KNA1-LIFNR).