Skip to Content
User Experience Insights
Author's profile photo Penghong Jiang

Migration Cockpit (LTMC) 1 – Migrate Asset balance for fixed assets

Data migration has been extremely simplified by introduction of SAP S/4HANA Migration Cockpit, which is easy to learn and use. It can be accessed via tcode LTMC. Here I am going to share experience by step-by-step demo, which you can learn how to migrate financial related transaction data via LTMC, such as asset balance, open AR/AP and account balance, etc.

Let’s start with Asset balance migration.

1: Launch migration tool via tcode LTMC, fiori apps would get opened.

LTMC

2. Create a new migration project. Mass Transfer ID can be manually updated or generated by system.

Create%20migration%20project

Create migration project

3. Search fixed asset object and open it.

4. Standard template can be downloaded here.

5. A xml file would be downloaded. Multiple pre-defined sheets are available in each xml template for migration, as well as field explanation. To be noted that sheets highlighted in yellow color are mandatory, and blue ones are optional for your migration. Eg

6. Preparation for migrate assets balance.

Before migrate asset to S4, we need to set parameter also like in ECC. T-code: FAA_CMP, set take over date and closed fiscal year. Screenshots from testing system.

7. Update asset balance template.

Suppose below assets to be migrated.

Update sheets to be used in template, all fields marked with “*” are mandatory.

Master detail sheet:

Posting information sheet:

Time-dependent data:

Depreciation areas:

Cumulative Values sheet, which contains APC value and accumulated depreciation till end of last fiscal year of assets capitalized before current fiscal year. In this case, only legacy asset 1 need to be updated in this sheet.

Posted value sheet, which contains all assets’ depreciation value of current fiscal year. In this example, both assets need to be updated.

Transactions (Transf. dur. FY) sheet, which contains APC value of assets those capitalized in current year, transaction type 100 used here for demo. Different project might use different take over transaction types. In this example, need to update asset 2’s APC value here.

Note: if parallel currency function activated, then you need to make sure areas with the same target ledger group should have the same value of column “Sequence No. of Asset Line Items in FY*”. Otherwise, system will treat them as different line, and convert another group currency amount from local currency in this demo case.

Once done, save it.

8. Upload template.

After upload template in, then it is ready to be transferred, first active the template like highlighted above.

Follow step active->validate->convert->simulate->execute

9. Validate data

Start transfer, system will start data validation, without any error, then process next.

10. Convert value, confirm value mapping between system and upload template. System already proposed the default mapping, it can be confirmed one by one, all confirm all together.

Process task -> one by one

Confirm mapping values – confirm all together

Make sure all field mapped.

11. Data simulation

Without any error, process next.

12. Execute import.

In case there is any error happened for value mapping, we can go back to update confirmation, and repeat the simulation and import.

Resolve error first, then process repeat execute.

LTMC data transfer done. Now assets can be checked in SAP.

 

You can also find other LTMC related articles –

https://community.sap.com/topics/s4hana-migration-cockpit

SAP LTMC help linked here-

https://help.sap.com/viewer/29193bf0ebdd4583930b2176cb993268/1909.000/en-US/8f97f0b407024465a283809f0bbe000c.html

 

Kindly give me your valuable feedback / suggestions to make this article as more useful.

Next, I will share experience on AUC items migration by using LTMC.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Afshin Irani
      Afshin Irani

      Hi Penghong Jiang,

      Firstly a very well written blog , much appreciated for this.

      What would be best approach to create  GL Master Data into S4/HANA using LTMC ? Any pointers would be much appricated.

       

      Thanks

      Afshin

      Author's profile photo Penghong Jiang
      Penghong Jiang
      Blog Post Author

      Hi Afshin,

      Thanks. GL accounts can be created via LTMC tool as well via standard template provided.

       

      Regards

      Fisher

      Author's profile photo Regys Mene
      Regys Mene

      Hello Penghong Jiang,

      thanks a lot for the great blog. A short question: we are using the Direct Transfer Method to transfer fixed assets (including balances) object, and I managed to migrate the assets through Migration Cockpit, however only the master data, not the transactional data of it (CUMULATIVEVALUES, POSTEDVALUTION, TRANSACTIONS). Do you perhaps have an Idea why these are not being migrated?

      I see the values already in the source system ANLC table, however in the target system, in the ANLC table are only the new assets created without Values basically 0,00 for the KFs of the table (Column KANSW, KAUFW etc.)

      Thank you in advance!

      Regys