CA Zunaid Hingora

January 18, 2020 9 minute read

LTMC for Data Migration – Master/Transaction Data – SAP S/4HANA – Simple Steps

32 69 84,019

In ECC, LSMW was the tool to upload Data in the system. It consists of Master/Transaction Data. In S/4 Hana, LSMW is redundant and should not be used anymore. Instead, LTMC functionality have been Introduced. LTMC is Legacy Transfer Migration Cockpit. Ready-made templates are available to upload the data. Nearly all Master/Transaction scenarios are covered in LTMC.

For videos of all my blogs, please click on below link.

https://www.youtube.com/channel/UCx5F7mhmIYye8ETY3cM5zQQ

Benefits of LTMC are as below:

Easier Processing and uploading data in the system.
Recording step is eliminated.
No more Consultant dependency to upload data. End user can also use this functionality.
Functionality can be used through Fiori app.
User friendly navigation.
Ease in filling the templates.
Reusability

In this blog, focus will be on using LTMC for uploading the data in the system.

Note: For Changing the object data, there are no templates in LTMC. LSMW not recommended to be used in S/4 Hana. SAP Note 2287723 – LSMW in SAP S/4HANA on-premise

Process Efficiency Table

Below table list out the Process Efficiency of LSMW vs LTMC. This is very subjective and may vary from person to person or organization to organization

Following are the steps to use the LTMC.

A Detail Steps

Create
Download Template.
Upload file.
Activate
Transfer
Validate Values
Convert Values
Simulate Values
Finish

B. Other Features

Reusing existing LTMC
Uploaded Data Verification
Transfer data from Stagging Tables.
Activating LTMC link
Import/Export of Object
Important SAP Notes
Sap Considerations.
Material Master .

Create

In S/4 Hana when LTMC transaction code is entered, it will take you to below screen. In below screen, there is Create button.

Once you click on create button in above screen, below window will appear. Enter name of the object you wish to upload. Mass Transfer ID is populated automatically. Here we will focus on “Transfer Data from File” scenario.

Data retention file will decide number of days one can retain upload history. Say you uploaded 3 files today and 5 days are mentioned below, after 5 days those 3 files history will disappear. so give maximum number of days in below screen.

After entering the details above, below screen will appear. Complete list of objects that can be uploaded will be displayed. Search for the object that need to be uploaded. In our case, it will be Profit Center.

When object is double clicked, below message will appear. Click on OK.

2.Download Template.

After pressing on OK, below screen will appear. If you see, there is no file as of now. Click on Download Template to download the file.

Once you open the file, first sheet is for introduction of the file. Please read this if you are first time user.

In Second sheet, all the fields are specified. This will provide which fields are mandatory and which are not.

In below screen, entries must be filled. Field with * marks are mandatory.

3. Upload file.

In below screen, there is upload file button. Click on that button.

Below screen will appear. Browse and select the file. Enter Description and Comments, if any. Click on upload button.

One line item will be created as shown in below screenshot. It means file is ready to be uploaded.

4 Activate

Click on Activate button. Once activate button is clicked, it will be grayed out as shown in below screenshot. Click on Start Transfer button.

5 Transfer

Once transfer starts, below screen will appear. Click on OK button.

Below screen will show you the progress. Click on close if it reaches 100%.

6 Validate Values

In below screen we are on Step 1, i.e. Validate Data. Click the Next button in below right-hand corner. Messages reflected below are Information messages.

7 Convert Values

If you see below screen, we need to map the fields for each line. This will be one-time activity. Double click on first line.

Below screen will appear. If Customizing field is blank, enter the value. Click on Check button and confirm. Click on save.

Carry out similar activity for all lines. All should be green.

Click on Next button. Below window will pop up. Progress should be 100%.

8 Simulate Values

Information message will appear. Click on next button.

Below pop up will appear. Once progress is 100%, click on close button.

9 Finish

Now you are on last step. Click on finish button.

Data is uploaded in the system.

B. Other Features

Reusing existing LTMC object.

Here we will use existing LTMC for further uploads. We will take Cost Center example which is already in Finished status. It means we have uploaded the Cost Center before.

Upon double click on the object, it will take you to next screen as below. Click on Edit button to proceed further.

If you see below screen, already cost centres are uploaded with this programme.

Click on upload file. Try to upload the same file again. Here I tried to upload EN_Cost center1.xml again and it throwed error. It means if you want to retain your upload history, every time you need to upload the file with unique name.

Now in below screen if you observe, file is renamed to EN_Cost centre2.xml. If you adopt renaming approach, upload history can be maintained. Now Activate and initiate the transfer of file. Rest all steps are similar as mentioned in above part of document.

2. Uploaded Data Verification

Once file is uploaded, you want to verify as what is uploaded than double click in EN_Cost center3.xml. (Screenshots may differ from above post as steps are carried out at different time).

Below screenshots reflects the data uploaded in the system. Some screens are cropped due to confidentiality factor. As of now excel download feature is not available.

3.Transfer data from Stagging Tables.

This functionality supports to fetch data from Sap or other system without uploading the excel file in the system.There are details steps to use this functionality. Many blogs are written for this and it can be searched on forum. Here i am mentioning one blog which could be very useful to all of you.

https://blogs.sap.com/2019/03/13/working-with-staging-tables-in-s4hana-migration-cockpit/

4. Activating LTMC link

Sometimes it may happen we have last minute surprises. You click on LTMC Tcode and below message appear. In spite of full authorization, below screen appears. To get rid of this, you can try steps mentioned in below steps. If it does not help than contact you basis team.

Copy below part from above link. Go to Tcode SICF and paste as shown in below screenshot. Click on execute.

/sap/bc/webdynpro/sap/dmc_wda.

Right click on below inactive option and Activate the function. Try again and it may launch the screen.

5. Import/Export of Object

LTMC allows import/export of Migration object from one system to another. Object tested in Development can be imported in Quality. Identical Mass Transfer ID is the prerequisite to import the object.

Enter the object you wish to export. Click on export button.

Click on execute button and zip file will be downloaded.

Below is the screenshot of zip file.

Click on import button in System you wish to import the object. Click on execute button. Object will be imported.

I could not find any significant advantage of this Import/Export process as LTMC provides ready made templates and there is no need to record the screen as we use to do in LSMW. Only one benefit I observed is system does not require mapping of fields after import.

6. Important SAP Notes

2287723 – LSMW in SAP S/4HANA on-premise
2537549 – Collective SAP Note and FAQ for SAP S/4HANA Migration cockpit (on premise)
2550904 – LSMW: Presentation server file could not be read/found

7. SAP Consideration

Note the following considerations when deciding on the most suitable approach for your project:

Consideration	Files	Staging Tables
Size Limit	200MB limit for SAP S/4HANA Migration Cockpit .*	No Limit.
System Considerations	None.	Staging system uses an SAP HANA database.
Data Provisioning	Enter data manually in each Microsoft Excel XML file.	Fill tables manually or by using preferred tools (for example SAP Agile Data Preparation).

8 Material Master

In 1909, Material Master still cannot be created with Internal Number range.
For Cloud edition there was recently a new object released called “Product”, which is replacing the old “Material” object, which will support internal numbering. This object will be released for customers using on premise solution with the next release (2020) expected to be introduced this September.

Important Note : At this moment i am Leading Data Migration Team in ECC. We have to develop Programs, identify LSMWs for Reusing, Write LSMW, Modify LSMW, Create Template and Many more things. After carrying out above task, i feel LTMC is the most important tool offered by S/4HANA.

Tips – If you are working on ECC Data Migration, kindly download all required templates from LTMC and identify important fields first. Share this identified field templates to User for data filing. Post this you can create LSMW/Program. In this way, Data Migration will be Fast.

I hope you liked the document. Also if anything is missed out, please highlight. It would be learning for all of us.

#ltmc #ltmcsap #Datamigration #dataupload

All the best.

Zunaid Hingora

Other Blogs