SAP BLOG SAP S/4HANA Fixed Asset Legacy Data Migration

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,580
Tepki puanı
7
Puanları
6

Introduction​


As an introduction, I would like to highlight this blog is for fixed asset legacy data migration in S/4HANA (and not for conversion). There are many contents available online for SAP Fixed Asset Legacy Data migration, and this could be one of it. But in this blog, I would like to touch upon multiple points which I was looking before starting fixed asset legacy data migration in S/4HANA. Instead of duplicating details, I have provided link to the content wherever applicable. Please note details provided here are relevant for S/4HANA 2020 version and may or may not be valid for other versions.

Important configuration for Fixed Asset Legacy Data Migration​


Configuration related to Fixed Asset Legacy Data migration in S/4HANA can be set using path ‘SAP Customizing Implementation Guide –> Financial Accounting –> Asset Accounting –> Asset Data Transfer –> Parameters for Data Transfer’, predominately company code status, transfer date, transfer status, document type, offsetting account and transaction types.

#Configuration Accounting Entries
1Define Transfer Date and Additional Parameters
  • Transfer date – This date depends upon whether legacy data transfer is at fiscal year-end or during the year
  • Transfer status – Select transfer status from In Preparation, Ongoing, Ongoing (Other Postings Allowed) or Completed.
  • Document type – This document type will be used when posting fixed asset migration documents.

Screenshot-2022-01-14-120817.png

2Specify Offsetting Account for Legacy Data TransferMention offsetting account for transferring the asset balances. This GL account will be used for asset data migration.
3Define Transaction Types for Transfer of Open ItemsDefine transaction types for the takeover of open items from a previous system. If you do not have any assets under construction with line-item management, you do not need this kind of transaction type.
Screenshot-2022-01-14-121216.png
Screenshot-2022-01-14-121255.png

Alternatively, configuration can also be set using procedure described in the BH5 test script (Link) on SAP Best Practices Explorer.

Key Accounting Entries​


Below example accounting entries are posted at time of fixed asset legacy data migration: –

#Scenario Applicable TransactionsAccounting Entries
1Year-end migration and Mid-year migrationPrevious year accumulated Values
Dr. Accumulated Acquisition

Cr. Accumulated Dep.

Cr. Offsetting/Takeon Account

2Mid-year migrationCurrent year Dep.
Dr. Offsetting/Takeon Account

Cr. Accumulated Dep.

3Mid-year migrationCurrent year Acquisition or additions
Dr. Accumulated Acquisition

Cr. Offsetting/Takeon Account

4Mid-year migrationCurrent year Retirements
Dr. Offsetting/Takeon Account

Dr. Accumulated Dep.

Cr. Accumulated Acquisition

Fixed Asset Legacy Data Migration options​


With S/4HANA, SAP has improved data migration by providing S/4HANA migration cockpit tool. However, Legacy System Migration Workbench (LSMW) and transaction code AS100 is also available in S/4HANA. Please find below further details for S/4HANA migration cockpit and LSMW: –

S/4HANA migration cockpit​


S/4HANA migration cockpit has provided multiple Migration Objects (click link to access latest/full list). Migration Object Fixed asset (incl. balances and transactions) is used for migrating fixed asset master data and transactional data. SAP has provided standard template for uploading master data and balance. Below is detail of some of the important tabs and fields in upload format: –



Sr. No.TabComment
1Master Details (mandatory)
This worksheet/tab hold important information for creation of the assets. Some of the fields are Asset number, sub-number, asset class, description, etc.



Screenshot-2022-01-14-122732.png

2Posting InformationAsset Capitalization Date field is provided in this worksheet/tab.
3Time-Dependent DataTime dependent data like cost center, WBS, plant, etc. are part of this worksheet/tab.
Screenshot-2022-01-14-122837.png
Screenshot-2022-01-14-122937.png
[TR]
[TD]4[/TD]
[TD]Allocations[/TD]
[TD]This worksheet/tab hold information like evaluation group, sort key, etc.[/TD]

Screenshot-2022-01-14-123017.png


[/TR]
[TR]
[TD]5[/TD]
[TD]Depreciation Areas[/TD]
[TD]
Details like depreciation (dep.) area, dep. Key, useful life, dep. Start date, etc. can be updated here.

In case there are multiple dep. area then separate line needs to be created for each dep. area.

Screenshot-2022-01-14-123125.png

[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Cumulative Values[/TD]
[TD]
From this tab transaction data field is started, fields like current fiscal year (Current fiscal year = active fiscal year in system), Cumulated Acquisition Value, Accumulated Ordinary Depreciation, Currency, etc. Using this details system will post the required transaction.

In case there are multiple dep. area then separate line needs to be created for each dep. area.

Screenshot-2022-01-14-123202-1.png

[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Posted Values[/TD]
[TD]
This tab needs to be populated for transfers during the year, it holds the Posted Ordinary Deprec. for the Year (Depreciation values must be negative), Depr. posted until (including period).

In case there are multiple dep. area then separate line needs to be created for each dep. area.

Screenshot-2022-01-14-123301.png

[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Transactions[/TD]
[TD]
This tab needs to be populated for transfers during the year, it helps to transfer the transactions starting from the beginning of the fiscal year up to the time of the transfer date. E.g., transactions are, additional acquisitions, retirements, etc.



In case there are multiple dep. area then separate line needs to be created for each dep. area.

Screenshot-2022-01-14-123330.png

[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Proportional Values on Transactions[/TD]
[TD]
This tab needs to be populated for transfers during the year, it holds important fields like Prop. Accumulated Ordinary Depreciation, Prop. Cumulative Special Depreciation, etc.

In case there are multiple dep. area then separate line needs to be created for each dep. area.

Screenshot-2022-01-14-123440.png

[/TD]
[/TR]

Below table from SAP help portal provides full details on the available tab: –

Screenshot-2022-01-14-123717.png


Source: SAP Help Portal: Link

Legacy System Migration Workbench – LSMW​


Fixed Asset Data migration can also be performed using LSMW. This traditional tool has 4 import method, but I tend to use more of BAPI and IDOC mainly because of its speed (parallel processing), error handling and standard. For Fixed Asset Data migration, below BAPI can be used: –

  • BAPI_FIXEDASSET_OVRTAKE_CREATE
    • BAPI for creating and optionally transferring values to new legacy assets to be created
    • S/4HANA migration cockpit Object Fixed asset (incl. balances and transactions) is using this BAPI
  • BAPI_FIXEDASSET_OVRTAKE_POST
    • BAPI for transferring values to existing legacy assets, using this BAPI asset transactions/values can be updated

Parallel processing of IDocs in the background (report RBDAPP01) with package size 50 has proven successful. Ensure that your package contents are as homogenous as possible (for example, fixed assets from the same asset class).

Selection of S/4HANA migration cockpit or LSMW​


Below comparison is based on personal experience, kindly note every project is different, and you should evaluate beforehand:

StandardMigration object – Fixed asset (incl. balances and transactions) is available out of the box solution. This is having standard simulation, mapping, validation, and postings.SAP has provided and support standard BAPI for fixed asset data migration. A migration (or conversion) object needs to be created using provided BAPI/IDOC.
Performance
The normal performance benchmark for BAPI_FIXEDASSET_OVRTAKE_CREATE (which is used for Migration object – Fixed asset) is approx. 2 sec per asset. This benchmark is valid for Validation, Simulation and for Execute Import. This means it might take approx. 5 hours for migrating 10,000 assets.



Parallelization of XML file loads is possible using attribute (“Max. Data Transfer Jobs”) in S/4HANA migration cockpit. This will use batch-job processes in the system.


Using parallel processing in LSMW with BAPI/IDOC system can use multiple (i.e., 80%) dialogue processes in parallel for asset data migration.



With personal experience on BAPI (BAPI_FIXEDASSET_OVRTAKE_POST), I have notice approx. 10 records were created/migrated in a second. Considering this speed 10,000 assets will migrate within 15 minutes of time.



Please note actual time depends on the system resources and performance. And time for creation and posting with BAPI (BAPI_FIXEDASSET_OVRTAKE_CREATE) will also differ.
Volume
By standard the default size limit for each uploaded XML file is 100MB, size limit for each uploaded XML file can be set to 160MB by changing the system parameter (icm/HTTP/max_request_size_KB).



Although here is no limit in case you are migrating using “Staging tables”.
LSMW does not have limitation on file size but by default LSMW can only read 2,147,483,647 records.
Custom FieldsMigration object provided can be updated to add new fields which are not in template using the Migration Object Modeler (transaction LTMOM).Standard BAPI has provided extension structure for updating such fields.



Subsequent corrections to the transferred values​


It is advisable to perform mock migration or migration rehearsal before actual migration. It is also recommended that you use a variety of tests to ensure that the transfer of production legacy data can be carried out and reconciled without errors, without requiring subsequent corrections to the transferred values. If incorrect migration is performed and data need to be corrected (and you don’t want to Reset Company Code). Below steps are suggested, however every project is different, and you should evaluate/check the steps beforehand: –

  • Reverse the transfer documents using BAPI (BAPI_ASSET_REVERSAL_POST) with LSMW, reversal will be posted to transfer documents. Legacy Fixed Assets which were already created are retained. If require, you can deactivate the legacy assets using change function
  • Re-post the corrections of the transfer values using transaction code ABLDT (SAP Customizing Implementation Guide –> Financial Accounting –> Asset Accounting –> Asset Data Transfer –> Manual Data Transfer –> Legacy Fixed Asset –> Post Transfer Values) or using BAPI (BAPI_FIXEDASSET_OVRTAKE_POST). It is recommended to use BAPI with LSMW for mass upload because transaction code ABLDT uses an input enabled ALV grid control and does not support batch input.

Link to important information/source​


Below are some useful links for further study: –

DescriptionSourceLink
S/4HANA Migration CockpitSAP HelpSAP Help Portal
List of Migration objects with S/4HANA cockpitSAP Help
SAP Help Portal

Migration Object Fixed asset (incl. balances and transactions)SAP HelpSAP Help Portal
LTMC for Master Data Step by Step ProcessSAP Blogs (by Ruthvik Chowdary)
How to add custom fields to SAP S/4HANA data migration cockpit..SAP Blogs (by Fernando Martin)How to add custom fields to SAP S/4HANA data migration cockpit with data migration modeller. Example with material master. | SAP Blogs

Below are some useful SAP ’s notes for reference: –

  • 2208321 – FAQ for legacy data transfer in SAP_FIN 720 and subsequent releases
  • 2331123 – Prerequisite customizing required for legacy asset takeover in Simple Finance (sFIN)
  • 2631104 – Performance of migration the fixed assets
  • 2719524 – SAP S/4HANA Migration Cockpit: XML template size limits
  • 2878945 – Migration Cockpit: Parallelization of XML file loads
  • 2554160 – SAP S/4HANA Migration Cockpit: Fixed Asset: Less performance during simulation run
  • 2576565 – SAP S/4HANA Migration Cockpit and Migration Object Modeler (LTMOM): Learning materials and knowledge points, Data Migration On-Premises

Conclusion​


Hope after reading this blog, you got information on important configuration, accounting entries, migration options, parameter on selection of migration options, idea on subsequent correction of transfer values and some links to other important information/source.

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.

Okumaya devam et...
 
Üst