Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Psandeep
Newcomer
Hello All,

In this Blog post, I would like to explain

  1. Data Migration Cockpit Overview

  2. Migrate Data directly from SAP System.

  3. Migrate Data using Staging Tables

  4. Export Migration project


Context:

Previously  we have  Used  LTMC to access the Migration Cockpit, SAP S/4 HANA 2020 an Later Versions We have Migrate Your Data  that Support for Data Migration Activities.

Introduction

Migration Cockpit is a S/4HANA Fiori app that replaces LTMC.

In SAP S/4HANA 2020 and Later versions Support Migrate Your Data app.

  1. Data Migration Cockpit Overview.


With this app, you can migrate business data to SAP S/4HANA. You can migrate data directly from certain SAP source systems, or you can use staging tables to migrate data.

Key Features

You can use this app to:

  • Create migration projects to migrate data, and to monitor the status of the migration.

  • Select the migration objects that are relevant for your migration scenario (the app uses migration objects to identify and transfer the relevant data).

  • Process any mapping tasks for the migration objects.

  • Simulate the migration before migrating your data to SAP S/4HANA, and monitor the status of the simulation process.

  • Migrate your data to SAP S/4HANA, and monitor the status of the migration.


Migrate Your Data App –Migration Approaches

  • Migrate Data Directly from SAP System

  • Migrate Data using Staging Tables


Available Migration Objects in  Migration Cockpit and Migration Approaches.

 





  1. Migrate Data directly from SAP System.


Prerequisites

  • Add-on DMIS needs to be installed in the source system (included in the license for SAP S/4HANA), check SAP Note 2973957.

  • RFC connection from ERP/AFS/EWM/CRM/APO SPP source to SAP S/4HANA target system.

  • Further details on section Project Setup.


Open SAPGUI:

T Code: /n/ui2/flp to Open Firoi Apps


Create the project:


a)General Data: Specify the Name/Scenario/RFC Details/Development Package.

b) Data Selection : Specify the required Company Code to Select the Data from Source.

c) Select the Object: Select the object


 


 




Key Features

  • Monitoring tab Will be use to track the status of activity and extract the logs(Errors/Warnings/information).

  • Job Management Tab will be used to increase the Background Jobs.


Select Data: in this Step Data Will be selected from the Source system.

We can exclude the selected instances based on field values.


Mapping Tasks:  Field Conversion according to the business rules and Requirements.

Example:











Source Company code Target Company code
0001 1000


 Download the all mapping  values and  populate the values according to the Mapping   sheet/Rules and Upload.
Simulation: Simulation is a test run against the target and provides the information/Errors/Warnings we can extract the logs by using monitor tab.


Finally Migrate Your Data.


Once Migration is completed we can check the data in the Target.


Common Errors:




  • Configuration Missing in Target.

  • Number ranges not defined.

  • RFC Related Errors


3.Migrate Data Using Staging tables.

Migrate using Staging table is widely used Method in Data Migration Cockpit.


Create the Project by Providing Name/Mass Transfer ID/Database connection Details and select the required object.

Mass Transfer ID: 

  • it will be auto generated and unique for project(We can also populate valid ID).

  • Mass Transfer ID Will be used to Export the Project into another environment.


Database Connections: We have two option Local and Remote Database.



Staging tables will be created automatically along with project creation.

Populating Data into Staging Tables:

  • XML/CSV File Upload.

  • ETL Tools.


XML File Upload:

Populate the all mandatory sheets and fields in the template and upload.



 



Once file Uploaded We need to perform below steps.


Prepare: will prepare the staging tables in this step.


Provide the mapping task and proceed with the simulation and migration.


Once migration is completed if we have any errors Create Correction file option will be enabled.

Correction file :it will contain the failed records.

ETL Tools: (Data Services ,SDI)

We will use the BODS to populate the staging tables.

HANA Database Datastore required to import the DMC Staging tables into Data service.


Once Staging table imported into the data service Connect  Source and LT table by using Query transformation, Provide the Required mapping and execute the job.


Provide the mapping task and proceed with the simulation and migration.

Correction file Option not available in ETL Approach.

 

4.Export Migration project.

scenario: if we have any Customized Migration Object available in system and want to move it to another system.

  • Version of the two system should be same.


Go to SE38 : /LTB/MC_PROJ_Q2P


Execute the Program and Provide Mass Transfer ID of the Project that you want to Export(Mass Transfer id will be available in Project settings.


Specify the Path to download attachment.

Once downloaded go to the system that you want import  the Project and use the same T Code.

Select import and execute ,provide the file path to import.


Summary and Conclusion:

it's a over View of Fiori  Data Migration Cockpit  and loading Methods.

 

Please follow and refer the Page for DMC Updates

https://community.sap.com/topics/s4hana-migration-cockpit

 

Thanks for reading, please provide the your valuable feedback for the Blog.

 

Regards

Sandeep
1 Comment
Labels in this area