​How do I change the useful life (or depreciation end date) of a list of assets in SAP?

[Former Member]

How do I change the useful life (or depreciation end date) of a list of assets in SAP?

We are moving buildings and I want to speed up the depreciation on about 2000 assets so they are all fully depreciated on the day we leave the building.

Is there a way that this can be done without going through each asset individually?

[narasimhulu_konnipati]

You could record a simple LSMW / BDC (T-code - AS02) and change the useful life.

[Former Member]

I can change one asset using ASO2, but how can i change all 2000 assets? Is there a way i can copy into SAP from excel the asset numbers and command it to change the useful life of all the assets at once?