Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Asset Data Transfer using EXCEL Sheet

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

Not what you were looking for? View more on this topic or Ask a question