Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
aseem_arora2
Discoverer
There are many migrations to S/4 HANA happening around the globe. Business have a variety of requirements in order to meet their reporting needs. They would not like to lose any important piece of information so that their business processes can run smoothly in S/4 HANA. I had been involved now in few of these migration to S/4 HANA. Specially with mid year migrations there is additional complexity of bringing all the transactions to S/4 HANA which are posted during the year including periodic depreciation postings in ECC. All this data has to migrated in S/4 HANA in mass accurately and preferably in automated way within a short span of cutover timeline.

I have tried to share my experience in this blog with the approach to be followed for fixed asset migration with ECC data at the end of year or during the year.

 

  • Below are the asset values which can be migrated at the beginning of a fiscal year:



  1. Cumulative acquisition and production costs, which have been posted to the asset up to the beginning of the current fiscal year. This must be considered for migration.

  2. Cumulative revaluation of the replacement value of the asset that was posted up to the beginning of the current fiscal year.

  3. Cumulative Investment Grants with total of investment support that was claimed for the asset up to the beginning of the fiscal year displayed.

  4. Accumulated Ordinary Depreciation with total of ordinary depreciation that was posted to the asset up to the beginning of the current fiscal year. This must be considered for migration.

  5. Cumulative Special Depreciation with total of special depreciation, which was posted to the asset up to the beginning of the current fiscal year.

  6. Cumulative Unplanned Depreciation with total of unplanned depreciation that was posted for the asset up to the beginning of the current fiscal year.

  7. Cumulative Revaluation of Ordinary Depreciation that has occurred up to the beginning of the current fiscal year.

  8. Cumulative Reserves Transfer with total of reserves, which were transferred to the asset up to the beginning of the current fiscal year.

  9. Cumulative Interest with interest planned (posted) for the asset up to the beginning of the fiscal year displayed.

  10. Cumulative down payments, which have been made for the asset up to the beginning of the current fiscal year.


Point 1 and 4 listed above should always be considered. The others depend on asset transactions posted in legacy and asset accounting setup. For example, if assets have been revaluated in the past, you should enter cumulative revaluation values as well.

  • Configuration required for Asset Cutover



  1. Define offsetting account for legacy data transfer via IMG: Asset Accounting (New) -> Asset Data Transfer -> Parameters for Data Transfer -> Define Offsetting Account for Legacy Data Transfer



Figure 1 : Define Offsetting Account for Legacy Data Transfer




  1. Define document type for legacy data transfer via IMG: Asset Accounting (New) -> Asset Data Transfer -> Parameters for Data Transfer -> Define Transfer Date and Additional Parameters


In the Legacy data transfer tab specify transfer date as 31.12.2021 for year end migration.

Legacy transfer data status: Ongoing (Other postings allowed)

Document type: AA Asset posting


Figure 2: Define Transfer Date and Additional Parameters


 

Click on the ledger 0L leading ledger and specify highest fiscal year as 2022. SAP will automatically set closed FY as 2021.


Figure 3: Ledger 0L leading ledger


 


Figure 4: Ledger N1 (Local GAAP)


 In S/4 HANA, to post an asset below three transactions are used:

  1. Transaction code AS91 for Asset Master Data



Figure 5: Asset Master Data




  1. Transaction code AB01 to transfer the acquisition transaction of legacy asset posted in current year.


There are various types of transactions which can be considered for during the year migration like:

External asset acquisition, asset transfers from one company code to another, retirements, Write ups, Revaluation, Special and unplanned Depreciation, interests and down payments posted during the year.


Figure 6: Asset transactions


 

  1. Transaction code ABLDT to post APC Values and Accumulated Depreciation:



Figure 7: APC Values and Accumulated Depreciation using ABLDT


 


  • Asset Legacy Data Migration (Asset Cutover)




 

  • Mid year migration scenario


 

For mid-year migration only (for example, cutover date is 30.09.2022, period 9 of fiscal year 2022). Fiscal calendar followed is from January to December.

There are 2 options here:

Option 1:

1.Migration Approach (AS91) legacy asset master is created. Post APC Values and Accumulated Depreciation using ABLDT. In legacy data transfer mention migration key date as cutover date i.e 30.09.2022. In S/4 HANA, Asset balances at end of last year are posted through ABLDT, it updates Assets Accounting and General Ledger Accounting at the same time; due to this, no reconciliation issues occur.


Figure 8: Asset APC values and accumulated depreciation using ABLDT


 

2. Run the depreciation in SAP for the period 9 2022 which posts the depreciation for all the periods from 01.01.2022 to 30.09.2022. It posts in period 9 fiscal year 2022 hence set the expectations with the business as they won't get the monthly depreciation from SAP for these periods.


Figure 9: Asset explorer


 


Figure 10: Asset Explorer - Posted values


 

Option 2:

  1. In legacy data transfer mention migration key date as cutover date i.e 31.12.2021. For all ledgers maintain highest fiscal year as 2022 and closed fiscal year 2021.



Figure 11 : Legacy data transfer


 


Figure 12 : Legacy data transfer - Leading ledger 0L


 


Figure 13: Legacy data transfer - Local ledger N1


 

  1. Migration Approach (AS91) legacy asset master is created. Post APC Values and Accumulated Depreciation using ABLDT.



Figure 14 :  APC Values and Accumulated Depreciation using ABLDT


 


Figure 15 : Asset explorer - Planned values 2021



Figure 16 : Asset Explorer - Planned Values 2022


 

3. Perform Balance carry forward to FY 2022 for all ledgers using FAGLGVTR transaction code.

 

4. Perform depreciation run using transaction AFAB from period 1 to cutover period 9 one by one. SAP will calculate depreciation and post it period by period.


Figure 17: AFAB - Depreciation calculation



Figure 18 : Asset explorer - Posted values after Period 1 depreciation run



Figure 19 : Asset explorer - Posted values after Period 2 to Period 9 depreciation run


 

  • Year – End fixed asset migration:


For example, Go live is on 01.01.2022. Then set cutover date as 31.12.2021, period 12 of fiscal year 2021. Fiscal calendar followed is from January to December.

  • Migration Approach (AS91) legacy asset master is created. Post APC Values and Accumulated Depreciation using ABLDT. In legacy data transfer mention migration key date as cutover date i.e 31.12.2021. In S/4 HANA, Asset balances at end of last year are posted through ABLDT, it updates Assets Accounting and General Ledger Accounting at the same time; due to this, no reconciliation issues occur.


 

  1. In legacy data transfer mention migration key date as cutover date i.e 31.12.2021. For all ledgers maintain highest fiscal year as 2022 and closed fiscal year 2021.


 


Figure 20 : Legacy data transfer



Figure 21: Legacy data transfer Leading Ledger 0L



Figure 22: Legacy data transfer - Local ledger N1


 

 

  1. Migration Approach (AS91) legacy asset master is created. Post APC Values and Accumulated Depreciation at end of year 2021 using ABLDT.


 


Figure 23 : APC Values and Accumulated Depreciation using ABLDT



Figure 24: Asset explorer - Planned values 2021


 

Conclusion:

Hope after reading my blog, you got information on how fixed asset migration is carried out from ECC to S/4 HANA  with data at end of the year or during the year.

I would like you to share your feedback or thoughts on this blog in a comment

 

Link to important information/source:


 

Below are some useful SAP’s notes for reference:

 

Below are some useful links for further study:

https://blogs.sap.com/2017/03/25/s4-hana-new-asset-accounting-considering-key-aspects/

https://blogs.sap.com/2022/01/16/sap-s-4hana-fixed-asset-legacy-data-migration/

https://blogs.sap.com/2018/06/25/sap-finance-sub-module-comparison-from-ecc-to-s4-hana/

Read other FIN Asset Accounting and follow blog posts: https://blogs.sap.com/tags/253758978139952938680563247610563/)

Asset accounting 2022 latest release: Asset Accounting (FI-AA)

 

Ask questions about FIN Asset Accounting and follow: (https://answers.sap.com/tags/253758978139952938680563247610563)

 

Please follow my profile for future posts: aseem.arora2

 

Disclaimer:

This blog post is my opinion and not linked to any organization. All screen shots are from test systems and any similarity is coincidence.

 
1 Comment
Labels in this area