Friday 18 December 2020

How to load customers (business partners) with SAP S/4HANA data migration cockpit

Purpose

This blog explains the different approach for the load of customers, suppliers (vendors), contact persons in S/4HANA, that makes the use of business partners for these objects mandatory and old transactions like XD01, XK01, … have been deprecated and are no longer available. I will explain how the data migration cockpit can be used for customer load and what is the logic to fill the file template for customers with its different sheets (general data, sales view, finance view, contact persons,…).

How customers were loaded with ECC 6.0

With SAP ECC6.0 and previous versions it was common to create LSMW objects linked to different recordings created ad-hoc with transactions XD01 or VD01 or use program RFBIDEK0. File structure had to be defined within LSMW.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Why approach with ECC 6.0 is no longer possible. Business Partner concept.


S/4HANA requires the use of business partner, instead of using previous methods of creating separate objects for customers, suppliers and contacts. Transactions like XD01, VD01 are outdated and SAP will redirect to new transaction BP, which will be the single point of entry to mantain these objects.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

With the business partner approach, one BP can be a customer, vendor (now supplier), contact person, payer, etc. all at once, so there is no need for separate master data objects. The business partner role will define the role they have in the company.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

These roles can be defined in customizing.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

With the new business partner concept, the tables starting with BUT* are the central repository for all BP created. Older tables like KNA1, KNVV, KNB1 are still filled in S/4HANA, but it is necessary to do the necessary customizing settings in Customer-Vendor-Integration (CVI). CVI is used to synchronize customer and vendor master data objects with SAP business partner objects within SAP. With CVI in place, all the customers and vendors are assigned a BP number.

Besides this, with S/4 HANA it is not recommended to use LSMW, as there is a new data migration tool called Data Migration Cockpit, which provides file templates that we will fill to perform the data migration.

Load customers with Data Migration Cockpit. Fill the file template


The Migration Cockpit (transaction LTMC) provides structured migration templates as it is the case for Customer Master and Customer Master Extension.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

To get the file you can click the corresponding option in the migration object. This will download an xml file that can be edited in Excel.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

The Customer Master template contains a number of sheets, each sheet has mandatory fields marked with (*) which must be filled.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

The person responsible of loading customers needs to fill the load template. I start with the general data that covers name, account group, ….  Although it is possible to use internal numbering for customer creation, customer number is mandatory on the template as it serves as the unique identifier to link data in all sheets to the general data in the first sheet.

If for some customer accounts types you need to use external numbering, it is necessary to enter those in the sheet and use them in all sheets. In this example I use sequencial numbers.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Address data also available in this sheet.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

With S/4HANA Business Partner concept it is necessary to specify the business partner role. In this case I have to choose FLCU01 for customers.

The sales views need to be specified in the sheet Sales Data.It is necessary to use the customer number key entered in General Data sheet to link this and other sheets, otherwise there will be an error in the import.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Company code view filled in sheet Company Data. Here is where I set the payment terms, reconciliation account, …

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Contact person data: I assign the contact persons to each customers, using consecutive numbers as ID as numbering will be internal.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Sales partner: The customer numbers are repeated four times to assign each partner role to that customer.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

There are other views that can be filled for sales texts, company texts, … but not included in this exercise. It is necessary to link all possible entries in the file to to the customer numbers specified in the general data view.

Load customers with Data Migration Cockpit. Run LTMC


Inside of the migration object first it is necessary to upload the filled file.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Once uploaded, the file needs to be activated.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Now it is possible to start the transfer.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Next step is the data validation. Depending on the file size, this will take some time.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Once finished, the migration cockpit will show all file validation messages like wrong format, missing mandatory fields, ….

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Next step is the conversion for the field values.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

The template contains an external number for the customer; however, we need internal number assignment so the mapping is maintained as below;

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Remember the number ranges have to be set up in customizing.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Click on save and the internal numbers will be generated in sequence.

For other fields I had to add the conversion values from the file to the S/4HANA instance.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Next step is to simulate the import in SAP, where different errors might appear.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Any errors will appear in the notification screen.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Once done, it is time to import the data in SAP. Executing the import loads the data in SAP.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

data loaded appears in the log. If there are some errors, a Delta file would be created to be processed at a later stage.

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

Once loaded, I check in transaction BP that the customers are loaded. It is also possible to use transaction SE16N with tables BUT000 and KNA1, KNVV, …

SAP HANA Tutorial and Material, SAP HANA Certification, SAP HANA Learning, SAP HANA Exam Prep, SAP HANA Career, SAP HANA Study Material

No comments:

Post a Comment