Loading an Object using File based LTMC

By Imran, Mohammad February 16, 2023 under LTMC

LTMC offers an option which is file based approach to load the data in S4HANA. The inbuilt templates for various objects make data load very easy for low volume data. To get started you just need to download, fill the data, upload the template to the Portal and ready for the loading.

The first thing that you will have to do is to run a t-code (LTMC). Make sure you are running this t-code from the client you want to upload the data to. A browser with LTMC screen will be opened, follow the steps below.

Create a Project

If a project is already created, you can use the same if Data Source is File or if you want seperate project for your migrations then you can create one more as below.

Click on Create.

• Give a suitable name to your project.
• Choose the option Transfer Data from File
• Ensure Mass Transfer ID is generated. It is required to transport the project to another environment. Click Create.

Now, Lets begin how we can load an object using File based LTMC.

1. Download the template

Once the project is created, you can search and download the template of the object you want to migrate to S4HANA.

2. Fill the Template

Open the template that you have downloaded and following activitis:

• Check the the tabs and list of fields required in your migration.
• Tabs in yellow color are mandatory tab, cannot be left blank. Tabs in blue color are optional, you can left them blank if those are not in scope for your migration.
• Fields with * are mandatory to populate. You can notice in description of the fileds that there will be a star(*) in end.
• Save the template once it is filled.

3. Upload the Template

You have filled required data now upload the template to the portal

• Click on the Upload and browse the file. You may encounter some errors during upload for example Mandatory tab is not filled or Mandatory fields left blank. or field position got misplaced etc.

4. Start Transfer

Once your template with data is ready and uploaded to LTMC portal, now it is time to start transfer.

• Select the file you just uploaded and click on Activate to Activate the Transfer.
• You will notice Start Transfer button is highlighted as soon as it is activated. Click Start Transfer.
• Validation of the data will begin (not validation against S4HANA). The validation takes sometime. Ignore if there is any warning.
• You may encounter some errors - Data entered incorrectly like date is not is not in correct format, in integer field decimal or character data is put.
• You will then need to correct the data in file and start from the begining. Delete old uploaded file and re-upload the corrected file then Activate and Start Transfer.
• If no error encountered then you will see Information in the dropdown.

5. Field Mapping

This is very important step, LTMC checks your input and validate possible values available in S4HANA. If the value you have put in your file does not exist in S4HANA then it will ask you enter the mapping manually, if found then LTMC will do the mapping automatically but still you can change the mapping if you want to.

• Sellect All from the dropdown then click on Confirm Mapping Values for the Auto-Mapping.
• Signifies mapping required either auto-mapping or manual mapping.
• Signifies no action required because the field is free-text.
• Signifies mapping found and no further action required. But you still can change the mapping if required.

In case any of the filds left with the Auto-Mapping then you will need to it manually.

• Click on the field name highlighted then choose a possible value from S4HANA Target Value drop down. You will notice icon will turn to green. Click Save.
• All the reds will turn to green. Now proceed further. Click Next.

6. Data Simulation

Simulation step is to check your input against S4HANA. If system finds anything wrong with the data or setting in S4HANA is not proper as per the input, you will get to know in this steps. if no error encountered then simulation will finish with Information in dropdown. Click Next

7. Data Import

When all the steps went without any error then you are good to start import, this step is to create the data in S4HANA. Once done click Finish