Data Migration – 1 : LTMC – Data Migration Cockpit

Our good old LSMW direct input days are almost over. LTMC is the new migration king.

With the release of S4/HANA 1511 of SAP, introduced us a new way to migrate our master data. Even though LSMW keeps on being available, SAP no longer takes care of its issues.

So proceed with caution using the note 2287723. As SAP says: “LSMW might propose incorrect migration interfaces that cannot be used in SAP S/4HANA anymore.”

Even though LSMW keeps on its life in an ambiguous way, LTMC provides itself as a pretty fine method to upload master data. It works in webdynpro, so we need to configure services first.

First things first

SICF tcode is our guy for services. There are 3 services we need to successfully activate.

  • DMC_WDA
  • DMC_WDA_GAF
  • DMC_WDA_DATA_MIG
SICF

Most of the time, they are initially activated. But if you test the service and get an error like “FPM application DMC_WDA was started with an invalid or without configuration” error, you need to deactivate all three services and re-activate again. That will solve your possible error.

Services

Let’s start migration

So, when we write tcode LTMC to code field, SAP GUI kicks up the browser with the proper LTMC action.

After you login to system with your username and password, we are good to go.

Projects

After we’ve chosen create button to create a project, a popup welcomes us.

Create Migration Project

In the popup you are expected to give the project a name (similar to LSMW projects actually). And choose a “Mass Transfer ID” which is used for uniquely marking the transfer. I usually use the button “Generate New Mass Transfer ID”. But you can assign your own ID too.

SAP Notes

Creating Migration Objects

In my example, I am going to use the Bill Of Materials. In my first trial of BOM; I have come across a series of notes related with BOM. You better check them out before you proceed.

If you’d like to see all notes regarding LTMC, SAP has aggregated all notes at one note link.

Choosing The Migration Object

After choosing the right object, files overview meet us. Since I haven’t uploaded anything yet, this subscreen is clean sheet at the moment. By choosing “Download Template”, SAP gives you an xml file to fullfill all your template need for the object.

Files overview

By opening it on a spreadsheet software (MS Excel, Google Docs etc.) SAP gives you a bunch of tabs.

Introduction And Field List

Introduction

Introduction tab gives you the details you need to know regarding the whole file. How to enter the data, formatting, mandatory fields etc.

Field List

But in second tab, we can see mandatory and optional fields exclusive to the file. This section summarises all fields for the master data and you must certainly check all sections. A field can be mandatory even if you don’t think so.

In the rest of the tabs, you enter all the master data necessary for object. Orange tabs are mandatory, nightblue tabs are optional. Also in each master data tab; mandatory columns are marked with * in case you may skip them. Just be careful with not to interfere with the default cell format in the file.

File Upload

We prepared the file, now we’ve got to upload the file. We chose the “File Upload” button, browsed our way towards the file, then chose upload. If you have multiple files and need to distinguish each file, you can make description and comment entry for each of them.

File Upload

After the upload is complete, the subscreen shows the file as not activated.

Activation

I choose the line and choose activate.

Transfer

Validate Data

After the activation, we are ready to “Start Transfer”.

By pressing “Start Transfer”, SAP starts the “Data Validation” process. Depending on the data amount you have, the process can get a bit longer. By validating data, SAP just checks the data integrity in the file itself.

Validation

If there are no error priority records, we can process by clicking “Next” button. The error records, may represent you format problems, missing mandatory fields etc. since you are obliged to present SAP a file in the right way. In this point you may encounter a lot of the note problems. You better check them.

Convert Values

This is probably the best part of LTMC. Because it shows each of the unrecognizable data for SAP and expects you to give a new value for that wrong value you entered. Mostly based on the customizing against the file.

Convert
Source and target value

Once you map the values matching with HANA system in each ID, all the ID’s must have green light at each row.

Green lights

By this way, we make sure that our data we provide are relevant for SAP, if it’s not, we must provide a translation for it. For example; you forget an unrecognizable character in material code. You can make it right by telling SAP that correct way to interpret it. Only for once.

Simulate Import

We’ve clicked the “Next” button once more. Now we are at the stage that we are trying to upload. (Be careful with note 2638840 ).

Simulation

When the check is done, you see the detailed cross master data errors.

Cross master data check

After you get rid of all missing points, you are able to start uploading.

By clicking to “Next” once more, you’ll start upload your data to system.

Summary

In short; LTMC gives you a solid infrastructure to upload your data. Step by step it makes sure you provide right data in the right way. And does this in the steps below;

  • Provide data format (Data Upload).
  • Check uploaded data by itself (Data Validation).
  • Check data against customizing (Convert Values).
  • Check data against cross master data (Simulate Import).

Thank you.

Levent

PS: Don’t forget to check LTMOM post too, it helps you to create custom data migration models.

4 Comments

  • Still have the same problem in “FPM application DMC_WDA was started with an invalid or without configuration”. even if i deactivate activate service, S4HANA 1809 FPS02 on Premise.

    • Hello Gerard,

      That problem is most of the cases related with component activation.

      Have you tried re-activating all three services including DMC_WDA together?

      If it does not work, we can look for another solution.

      Thank you.
      Levent

  • In template name of local dependence is set as mandatory I don’t know what is the use of local dependence where we are using in BOM and can you tell me where we can set and view local dependence in BOM

    • Hi. It’s probably from variant related setups. Just add ‘001’ must be valid for such requirement. You can use CU02 tcode from SAP GUI by Dependency Group.

Leave a Reply

13 + eighteen =