LTMC Migration Template Editing
As many of us are aware of LTMC process which is available from S/4 HANA version onwards,
Now in this blog post, I wanted to share a few important tips which are required to edit LTMC standard Template.
Before we go in further just an overview why edit its required in LTMC Upload template?
LTMC is and advanced Migration Cockpit compared to LSMW, even though as per our client requirement we will be having Customized fields to incorporate in our day to day master data,
Which is not possible to add such Custom fields data in Standard LTMC Program, So SAP has delivered an application where we can edit standard upload program by using LTMOM.
Now once Standard Upload program is edited by adding Custom Fields, the same we need to make changes in Template as well.
Steps to Edit Template.
- Open template which we need to edit like inserting new columns in upload file
- Click on File to allow permission
As its sensitive data because all the fields and linked to program SAP strongly recommends not to change template, so edit option will be restricted.
- Once opened on File option we can see a list of sheets as below
4. Click on unprotect under which sheet custom field needs to be inserted
5. Once done click on Unprotect click Home and go to the sheet where the insert is required. And insert as per requirement
6. Which sheet is still in Protected Status we can’t edit or do anything as shown below options will be disabled.
Do not make any changes to the structure of the migration template, specifically:
- Do not delete, rename or change the order of any sheet in the migration template.
- Do not change the formatting of any cells.
- Do not use formulas.
- Do not hide, remove, or change the order of any of the columns in the migration template.
Any changes to the sheets will result in a corrupted XML structure. Such modified migration templates are not supported by the SAP S/4HANA migration cockpit.
So please make changes carefully with help of ABAP Help change in LTMOM and accordingly in Template
In this way, we can enable Edit option and upload custom fields in Master data objects, by using standard LTMC Template.
Very good article, i wanted to know can we edit or change the fields through LTMC for the GL master which are already created in SAP ECC system, i need to change Alternative account Field in GL master which are already created and updated some other value in Alternative account field.
I am part of SAP FI , i have tried to use GL account and try to upload file with alternative account, getting error the “Account xxxx has already created in chart of Account xxxx”
if you know, can you please guide me.
if we need to do through LTMOM, please guide me how to do or steps to do.
Hi Sai Krishna,
Thank you for the detailed blog, I would like to know if we can use the same process to make changes to the existing data? Please let me know if I can make changes to the Business partner records I already created last month.
Your help is sincerely appreciated.
Hello Saiteja Joginapally
It depends on what changes you are trying to make try with Change Business partner object,
How do you set a mandatory field into a non-mandatory. In the standard template for Material, Valuation Category (MBEW-BWTTY) is set mandatory.
Hi Carl Beltran
That you need to do at program level using LTMOM and Migration Object which is not recommendable at all.
Sai Krishna V
I would add a comment based on what I have done so far it is if you use LTMOM to add a new field into your migration project. After adding, the upload template will automatically be updated the added field so you just need to download the template and that's it, the new field is there in the template.
The point here is you do not need to change the template manually by excel.
Hope this help!