SAP S/4HANA Migration Cockpit
The SAP S/4HANA Migration Cockpit helps you to easily migrate data from an SAP or Non-SAP legacy system to an SAP S/4HANA system.
Follow these steps:
- Prepare your migration project
- Download the migration templates
- Prepare your data for migration
- Validate the data
- Simulate the data migration
- Migrate data into an SAP S/4HANA system
In this example, you will migrate the master data for two banks with branch name S/4HANA from the legacy system to the SAP S/4HANA Cloud system.
The same approach can be used to migrate master data or transactional data for other business objects.
You need the user roles CONFIG_EXPERT_DATA_MIG, SAP_BR_BPC_EXPERT in order to use this tool. The corresponding role for each migration object is also required. For example, role SAP_BR_CASH_MANAGER for the Bank Migration object is required.
The Migrate Your Data app helps you to migrate data from SAP or non-SAP systems into SAP S/4HANA through simple file upload.
Here you can access the predefined data migration objects for SAP Best Practices. The data migration objects will be proposed based on the pre-configured business processes that were selected when the system was configured.
To open the app, select the Migrate Your Data tile.
To start a new migration project, choose Create.
Here, you can specify the name of the project.
For this example:
- Select Transfer Data from File.
- Enter Project Bank Migration
- Choose Create.
The migration project is created.
Here, you can view all available data migration objects.
To migrate data for a specific object, you can select the object name. For this example, to migrate bank master data, select Bank.
Note: The warning message shows that the object will be copied to the customer namespace that runs in the background.
To download the data template for the migration object, choose Download Template
The migration object template downloads to your local PC.
Note: The template file is an MS Excel XML file. You must add the extension .xml if it’s not already added. The migration tool only accepts MS Excel XML files as input. To make any changes you have to open the XML file with MS Excel.
An Excel file for the source data of the migration object opens.
The Field List spreadsheet displays the description and the metadata of the bank master data fields.
In the Bank Master spreadsheet, you can enter the source data for the BANK_MASTER migration object. The mandatory fields are marked with *.
To upload the source data, choose Upload File.
To view the details of the uploaded source data file, you can choose the file name.
Here, you can view the details of the source data file.
Choose Back and Choose Activate.
Note: You could have multiple source data files. The activation determines which file to use for the migration.
To begin the data migration, choose Start Transfer.
The migration of data is a guided activity. The first step of the data migration is Validate Data. In this step, the system verifies the data in the source file
Here, you can view results of the data validation and the description of the errors.
In this example, it shows that the China country key for the record 50000002 is not valid.
To fix the error, choose Next.
In the second step, Convert Values, you can correct and confirm the mapping between the source file data values and the target system field values.
To check the value mappings for the country, select Mapping of Country key.
In this example, the target value CHI for country China, is incorrect. The value is truncated to “CHI” because SAP S/4HANA allows upto three characters for the Country field.
To correct the error, open the S/4HANA Target Value list.
To correct the country key for China, select CN.
In this example, the legacy value for US is automatically mapped.
To accept the mapping, choose Confirm Value.
To proceed to the Simulate Import step, choose Next.
You can view the results of the simulation in the Notifications from Simulation table. The error message does not appear anymore and a warning shows there were no updates during the simulation.
In the final step Execute Import, the tool processes the source file data.
The processing is a success and the tool informs you to complete the migration.
To complete the migration, choose Finish.
The Status field indicates the status of the data migration.The green status icon indicates the migration is successful. To verify the results of the bank data migration, choose Back
To return to the launchpad, choose Home
To verify the results of the bank data migration, select the Manage Banks – Basic tile.
You can see the two banks created from the successful data migration activity.
I was struggling when downloading the template. You are the only one who noted mentioned about the XML file.
Thank you so much for your nice blog.
Very useful information in your blog.
I´m a little confused, I understand that SAP provides the Migration Objects templates that we need to download but my question is: Those templates are filled automatically with the corresponding data of the source object? or we need to fill manually?
Thanks in advance to clarify me.