Asset Data Transfer using EXCEL Sheet
Using T.code AS100, I have uploaded Legacy Data transfer in Asset Accounting.I have uploaded the Assets which were in EXCEL Sheet.
In Assignment of table fields:Fields of File, I got the following information
Rec.type Field description in Excel
10006 OFF.SALES BLDG.
In the Field of asset master data
Main Asset Number,Asset subNumber,Company Code,Identification feature,Asset Class.
For a test, I just assigned ASST_CODE= ASST_VALUE = Main Asset Number.I got the following Message.
Assign identifier, company code, asset class and capitalization date
Message no. ALSMEX002
In order to be able to create an asset, you have to assign at least the following master record fields:
Identification feature ("Header data" tab page)
Company code ("Header data" tab page)
Asset class ("General data" tab page)
Capitalization date ("Posting information" tab page)
Make sure that the corresponding field from the Microsoft Excel table is assigned to each of these fields
Should the fields of EXCEL Sheet should match or be the copy of the fields in SAP Fields of Asset Master Record? Please advise?