cancel
Showing results for 
Search instead for 
Did you mean: 

Asset Data Transfer using EXCEL Sheet

sridhar_muthekepalli3
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

sridhar_muthekepalli3
Active Contributor
0 Kudos

thanks for the answers

ferry_lianto
Active Contributor
0 Kudos

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.