Working with Data Migration Cockpit

By Imran, Mohammad February 16, 2023 under LTMC

The implementation of S4HANA is not complete without Data Migration. There are some tools such as BODS, IDoc, BAPI available to take care of the Data Migration activities but they are little complex hence a Data Migration consultant will be required even to deal with low volume data.

Data Migration Cockpit is a standard tool available in only S4HANA for data migration purposes and can be run by functional consultants or end users. This web based tool has various approaches to migrate data to S4HANA such as File based upload or Staging table based upload.
The tool has in-bulit objects to migrate the data such as Material Master, Customer Master, Vendor Master, Sales Order or Purchase Order etc. We just need to download template or load stating table to start the data migration for various objects.

Access the tool

It can be accessed by running a t-code called /N/UI2/FLP from S4HANA screen. Once you hit enter a web browser with a login based SAP Fiori screen will open. You can login SAP Fiori with same login details you used for your S4HANA.
Make sure the Data Migration or Migrate Your Data app is available and accessible. If not then reach out to your security team to add required roles to your id.

Once you entered into the Data Migration App, do the following steps to complete your data migration activity.

1. The first thing you need to do is create a project or use already existing one.
Note


Create button may not be visible for you. it is because the client is closed or you do not have proper authorization. Check with your security team to get client opened or ask for proper authorization to be added to your Id.



2. To create new project click on Create button and choose Migrate Data Using Staging Tables
1. Enter a meaning full name.
2. Choose Remote SAP HANA Database Schema.
3. Click on Step 2.
Note


You may not see anything when you choose Remote SAP HANA Database Schema, This is because you dont have any database connectivity in the t-code DBCO. Please get help from basis team to get connectivity done or read this article



3. Select a package from the down by choosing Other Package option or choose Local Package option. Then click Step 3.
4. Select your objects you want to Migrate or select all of the objects. If you select only required objects then you can reselect other objects. You will have to create new project to select other objects if new requirements arises. Then click Review.
5. Review and Create
6. Your project will be listed down here once created and you will notice Running Activities active. Let it complete, it may take time depending upon the number of objects you have selected. You can monitor if you want.
7. Once the activity is complete you can start your data migration by selecting required object under project you created.

Load an Object using Data Migration Cockpit

The object we will load is Sales Contract. The object I have taken is just to explain the steps.

1. Search the object under the project you have created. For example Sales Contract.
1. Download the template from the dropdow. You can download CSV or XML. XML is better option as this does not have datatype issue in numeric values.
2. If you do not want to load data using a template file then you can import staging tables to your BODS. You can use same database connectivity to create a datastore in BODS. Then import and insert records to staging tables in a dataflow. Once the tables are loaded with required data, come back to Data Migration Cockpit and refresh the page, you will notice records displayed here. Click on 4 at the Table to come to this screen.
   Note - The Technical ID is table name which begins with /1LT.

2. We will continue with File Template as both approaches are mostly same, it is just that staging tables use BODS to insert the records and template can be manually loaded, you just need you have the source data available. if your source data is in excel or any text file and less number of records then tempale option should be good for you or if your source data is there in any table form then staging table should be good option as BODS can extract from your source tables and insert in staging tables, the manual effort will be avoided in this case.
1. Open your File Template and fill it with certain records. The Yellow sheets are mandatory sheets and Blues ones are optional, you can leave them blank. Also, you will notice tiny star as postfix on certain fields, that means those fields are mandatory, you can leave them blank.
2. Once the records are populated properly, upload the template to DMC under the Sales Contract Object. Choose the option Upload File and click upload.
3. Once the template is uploaded, wait for few seconds or minutes depending upon the number of records you have populated, because transfer to staging tables start automatically. in case of of BODS then this step is avoided as BODS insert the records on Staging tables. If successfully transferred, you will see a successfully transferred message else error message in case of any inconsistency in populating the data in the template.

3. Go back to the home screen of the object and you will notice Mapping Task is automatically selected under the Action column.
1. Click on the Mapping Task and confirm the mappings. Complete all the mappings one by one listed there. There will be one mapping related to internal or external number. If your configuration for Sales Contrcat is internal then select internal in the mapping and cofirm. 00001 means internal and 00002 means external. Choose any of the options from the dropdown.

4. Come back to the home screen of the objec and will notice that Prepare option is ready. Click on it and Prepration for Staging tables will be strated.
5. Once the prepration is complete, you can start the simulation. You can keep monitoring at any step under the Running Activities. If it 1 or more than 1 that means any of process is running and you should wait for it to compate to to next step. During the process if something goes wrong then Activities with Error will increase and you should analyse and fix the issue before you go to next step.
6. If there is no any error you can click on the last step which is Migrate. Notice one thing if all your steps getting completed without any errors, your next step will be automatically selected.