Now you can transfer legacy data directly from a Microsoft® Excel file into your R/3 System.
First you load the data from your legacy system to a Microsoft® Excel sheet. Along with the legacy asset number, you are required to transfer: company code, asset class and capitalization date (and cost center, if it is defined as a requred field in the asset class); all other entries (such as depreciation key) are optional.
In the R/3 System, you assign the fields of the Excel sheet to fields in the R/3 System (for example, CoCd to company code). You can also create assignment variants in order to avoid having to re-enter the assignments.
Then start the transfer program in Customizing by choosing Asset Data Transfer -> Data Transfer Using Microsoft® Excel. The system reads the values from the Excel sheet and transfers them to the fields of the R/3 System using the assignments you made.
You can request a list in a special Excel sheet, showing incorrect data that could not be used to create assets in R/3.
For more information, see the Implementation Guide (IMG) of Asset Accounting, Asset Data Transfer -> Data Transfer Using Microsoft® Excel.