Mass updation of Dep start date in Asset

[Former Member]

Hi All,

Please note that I have created a new depreciation area for client for tax reporting purpose(areas do not post).The client wants to update the depreciation start date in all the assets with this new dep area.This can be done through customizing settings( transfer of dep terms) but then the useful life will also be identical to reference area(01) which client wants to change as per requirement and should not be same as reference area.

The other options are LSMW & BDC upload where i can do a mass upload for depreciation start date for all the assets.However I have not used this feature.

I would really appreciate if someone can help me with the steps.

Regards

Pranay

[former_member205615 · Accepted solution]

Hi Pranay

You can use worklist to do the mass change.

Regards

George

[Former Member · Accepted solution]

Hi George,

Thanks for the update, can you please help me with the steps. I want to update Depreciation start date and usefull life for 200 assets.

Regards

Pranay

[Former Member · Accepted solution]

Hi,

To do the mass changes to the assets create a substitution in Asset Accounting in GGB1.

Asset Accounting - AM Master data mass change.

Create a step under the substitution with the required changes(take Deparea and Asset Classes in Prerequisite)

You would require multiple substitutions. Precisely one substitution for all the asset classes with the same set of Deprecation start date and Useful life.

In OA02 create new entry for the compny code.

In AR01select the assets for which the mass change needs to be done.

select the Create work list icon on appln tool bar. Name the work list. select Change asset w/o dialog (bulk change). Give the substition name that is created.

In AR31 give the worklist details

Select the Release Work List icon on the appln tool Bar.

the changes will be effective for the existing selected assets.

Try first in IDES before you do the actual changes. This will work.

Thanks,

Raja.

[madhusoodanan_ramachandra]

Hi Pranay,

I understand from your requirement that depreciation terms are not common across the assets. In that case, substitution will not be an appropriate one. In substitution, you can only give constant value unless and until you go for user exit to determine dynamic depreciation terms based on other depreciation areas.

So the easier option would be LSMW. Do a LSMW recording to do these changes and upload the changes. That would be an easier option.

Best Regards,

Madhu

[Former Member]

Hi ,

Thanks for the update.I have used LSMW and the issue is resolved.

Regards

Pranay