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.

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

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.