on 05-03-2006 8:02 AM
Dear Friends:
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
ASST_CODE ASST_VALUE
ASST_CODE GRP_NAME
ASST_CODE Column1
10006 OFF.SALES BLDG.
10006 71,049.00
10006 Buildings-Admin
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
Diagnosis
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)
Procedure
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?
Regards
msreddy
thanks for the answers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sridhar,
You need to populate the field name in excel spreadsheet as follows.
- COMP_CODE
- ASSETCLASS
- CAP_DATE
- IDENTIFICATION.
Also please check this link for more information.
http://help.sap.com//saphelp_erp2004/helpdata/EN/70/93a417ecf411d296400000e82debf7/frameset.htm
Hope this will help.
Regards,
Ferry Lianto
Please reward point if helpful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.