Help needed on Asset accounting::::::::::Urgent help needed

[Former Member]

Hi All,

Plz help me on the below issue.

Client want me to make the Template for LSMW based on AS91. Can

u guide me in this regard. They are outsourcing the lsmw upload.

Thank you.

[sridhar_muthekepalli3 · Accepted solution]

Hi:

Go to T.code AS91. Check out the required fields.open an excel sheet and on the top of the excel sheet write down the required fields or mandatory fields.

Ask the client to give all the current data and fill them in the excel sheet.Ask the user to do this.

Please let me know if you need more information.

Assign points if useful.

Regards

Sridhar M

[Former Member · Accepted solution]

Hi Sridhar,

Thanks for you answer.Can you plz help me in detail.

Thank you.

[Former Member · Accepted solution]

Actually I need to prepare template for Batch Input Session using BALTD Structure for legacy transfer. Attached a sample of that. I already sent you my AS91 Screen Shots. Plz go through the sample below.

Template for Legacy Asset Data Transfer

Structure Name - BALTD

Field Name Field Description Type Length Explaination

MANDT Client (Legacy Data Transfer FI-AA) CHAR 3 Default production client number

BUKRS Company Code CHAR 4 Default value '3000'

ANLKL Asset class CHAR 8 Need to derive from legacy data

OLDN1 Old main asset number CHAR 12 Number of asset in legacy

OLDN2 Old asset subnumber CHAR 4 Sub-number of asset in legacy

TCODE Transaction code selected (Batch input) CHAR 4 Default 'AS91'

RCTYP Record type for legacy data transfer CHAR 1 Default value 'A'

ANLN1 Main Asset Number CHAR 12 System will generate internally

ANLN2 Asset Subnumber CHAR 4 System will generate internally

BWCNT Number of following trans. records CHAR 4 Default value '1'

AKTIV Asset capitalization date DATS 10 Capitalization date of legacy date

AIBN1 Original asset that was transferred CHAR 12 Number of asset in legacy

AIBN2 Original asset that was transferred CHAR 4 Sub-number of asset in legacy

ANLHTXT Asset main number text CHAR 50 Description of asset

TXT50 Asset description CHAR 50 Description of asset

TXA50 Asset description CHAR 50 Description of asset- Continued

SERNR Serial number CHAR 18 Legacy serial number

KOSTL Cost Center CHAR 10 Asset depreciation is posted to this cost center

WERKS Plant CHAR 4 Legacy plant

STORT Asset location CHAR 10 Legacy location

KOSTLV Cost center responsible for asset CHAR 10 This cost center can be used for reporting

AFABE01 Depreciation area (Legacy Data Transfer FI-AA) CHAR 2 Default value '01'

AFABG01 Depreciation calculation start date DATS 10 System will calculate based on Asset Cap. Date

NDJAR01 Planned useful life in years (Legacy Data Transfer FI-AA CHAR 3 System will default from asset class defintion

NDPER01 Planned useful life in periods (Legacy Data Transfer FI- CHAR 3 System will default from asset class defintion

SCHRW01 Asset scrap value (Legacy Data Transfer FI-AA) CHAR 16 ?

SCHRW_PROZ01 Scrap Value as Percentage of APC for Legacy Data Transfe CHAR 15 ?

NDABJ01 Expired useful life in years (Legacy Data Transfer FI-AA CHAR 3 System will calculate based on Asset Cap. Date

NDABP01 Expired useful life in periods (legacy data transfer FI- CHAR 3 System will calculate based on Asset Cap. Date

ANLGR01 Group asset CHAR 12 ?

ANLGR201 Subnumber of group asset CHAR 4 ?

KANSW01 Cumulative APC (Legacy Data Transfer FI-AA) CHAR 16 Gross Book Value of asset as on 12/31/2006

KNAFA01 Cumulative ordinary dep. (Legacy Data Transfer FI-AA) CHAR 16 Accumulated Depreciation of asset as on 12/31/2006

[Former Member]

Hi,

Please visit this site for our solution.

http://www.saptechnical.com/

Click tutorials on the top.In documents categories given on the lest hand side click LSMW. You will find all the relevant screen shots there.

Regards,

Nitin Aggarwal

Please assign points if helpful.