top of page

Migrate your data with DMC: successor of LTMC & LSMW

Updated: Dec 7, 2023

Data Migration Cockpit (DMC) in SAP is a tool within the SAP system that is used to migrate data from Legacy data system into the SAP S/4 HANA system.

The DMC in SAP S/4HANA offers a user-friendly interface for managing various aspects of the data migration process, including data mapping, upload, and error handling. It aims to simplify and accelerate the migration of business data.

Users can use the DMC to define mapping rules, execute data migration activities, monitor the progress of migrations, and handle any errors that may occur during the process.


Evolution of Data Migration tool over time by SAP

SAP Data Migration Cockpit

LSMW (Legacy System Migration Workbench) - In S/4 HANA, LSMW was redundant and was not be used anymore. Instead, LSMON (Migration Object Modeler) and LTMC functionality was Introduced.

LTMC (Legacy Transfer Migration Cockpit) -Here ready-made templates were available to upload the data. later, Transaction LTMC was deprecated and now can no longer be used to migrate data to SAP S/4HANA.

DMC (Data Migration Cockpit) - DMC is advanced Version of LTMC in S/4 HANA, SAP came up with this New Tool using Fiori Application to Migrate Data.


Scenario :

Let's try to create the below G/L Accounts in mass for Company Code ADD1.

G/L Text

A/c Type

Account Group

Co.Element

Field Status

Bank Account

X

ASST(100000)

YB05

Share Capital

X

LIAB (200000)

YB01

Asset Sale

X

REVN(300000)

YB29

Salaries Paid

P

EXPN(400000)

01

YB04

Steps to Migrate G/L Master data into SAP system :

( DMC tool in S/4 HANA work with Fiori Application)


STEP 1: To open FIORI launchpad, use Transaction code ui2/flp in SAP GUI screen.

SAP Data Migration Cockpit

STEP 2: Log on to Fiori with user credentials in the Web Browser.

SAP Data Migration Cockpit

STEP 3: Search for keyword "Data Migration Cockpit " Application in the Search bar.

SAP Data Migration Cockpit

STEP 4: Click on create and select Migrate Data using Staging Table to create Migration Project.

SAP Data Migration Cockpit

STEP 5: Provide name to Create New Project.

SAP Data Migration Cockpit

STEP 6: Select as Local Package and proceed to Step 3.

SAP Data Migration Cockpit

STEP 7: Choose the migration object based on the data you want to migrate (e.g., customers, vendors, materials) and move the "Migration Objects" to right side which is to be migrated(or to be created) in SAP System and click on Review.

SAP Data Migration Cockpit

STEP 8: After Review, click on Create Project to Save your New Project.

SAP Data Migration Cockpit

STEP 9: Go back to the DMC screen, select the New Project and click on arrow below.

SAP Data Migration Cockpit

Process of DMC Project -

SAP Data Migration Cockpit

STEP 10: Click on "Download Template" to download Sheet of your Migration Objects fields. The template file with predefined column headers and structures for a specific migration object serves as a guide for organizing data in the correct format before uploading it into the system

SAP Data Migration Cockpit

STEP 11: Select File type in XML File and click OK (to fill values in Excel Sheet)

SAP Data Migration Cockpit

STEP 12: Select the Download file and open in MS Excel.

SAP Data Migration Cockpit

STEP 13: Fill the required fields of Migration object data in the sheets which you want to migrate into system and save.

SAP Data Migration Cockpit

STEP 14: Click on "Upload file" to Upload the prepared data files to the Data Migration Cockpit.

SAP Data Migration Cockpit

STEP 15: Click on upload to select the Saved Excel file.

SAP Data Migration Cockpit

STEP 16 : Select your Excel file and click on open.

SAP Data Migration Cockpit

STEP 17 : Click on "Prepare" to create Staging tables.

SAP Data Migration Cockpit

STEP 18: Select Prepare Staging Tables and bring the data from source tables of migration Objects. Prepare Staging Tables is setting up temporary database tables where data can be initially loaded before being transferred to the final production tables

SAP Data Migration Cockpit

STEP 19: Select "Mapping Tasks" which shows all values to check & confirm your Data before you migrate it into SAP System.

SAP Data Migration Cockpit

STEP 20: If no Error or no Changes to be made, Select all Mapping values and Confirm.

SAP Data Migration Cockpit

STEP 21: Click on OK to proceed to next Step.

SAP Data Migration Cockpit

STEP 22 : Select "Simulate" to run a simulation to check for any errors or issues that might occur during the actual data load.

SAP Data Migration Cockpit

STEP 23: Click on Start Simulation

SAP Data Migration Cockpit

STEP 24: Review the simulation results in monitoring screen and If simulation is successful without errors then proceed to click on "Migrate", last Step of Migration Process where Data Actually gets uploaded into System.

SAP Data Migration Cockpit

STEP 25: Click on "Start Migration" .

SAP Data Migration Cockpit

Migration Project "Monitoring" is a screen which shows the Progress and status of project.


The below Project progress show 100% Completed.

SAP Data Migration Cockpit

Check in S/4 system, as you can see below, the G/L Accounts in screen FS00 is successfully created.

Similarly, you can also migrate any master data and transactional data of other SAP Modules.

.

Thank you for taking the time to read my blog. I appreciate your support and hope you found this content valuable. Stay tuned and follow me for more insightful articles in the future.


New SAP S/4 HANA Finance (FICO) online weekend batch - 20th Jan'24 @8AM, IST (Sat & Sun). Get 15% discount till 30th Nov'23



For complete video package visit the link below: