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.
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.
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
Following are the steps to use the LTMC.
A Detail Steps
- Download Template.
- Upload file.
- Validate Values
- Convert Values
- Simulate Values
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 .
- Process Efficiency Table
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.
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.
Click on Activate button. Once activate button is clicked, it will be grayed out as shown in below screenshot. Click on Start Transfer button.
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.
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.
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.
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:
200MB limit for SAP S/4HANA Migration Cockpit .*
Staging system uses an SAP HANA database.
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.
9. 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
I hope you liked the document. Also if anything is missed out, please highlight. It would be learning for all of us.
All the best.