Usage of Worklist Functionality in Asset Accounting-Part II

[Former Member]

The first part of this document is explained under the Usage of Worklist Functionality in Asset Accounting-Part I  (. This document is a continuation to that document. The intent of this document is to explain the usage of worklist functionality in asset accounting for carrying out mass changes to the asset master.

The example used in this document is a basic scenario to explain the usage of Worklist functionality and the steps to be followed to carry out mass changes to asset master.

Mass changes to assets master could involve changes to any of the fields to Asset Master Data like terms of depreciation, changes in cost center, populating the master data with a field that was earlier not populated.

The use of worklist functionality to carry out the same involves

1. Creation of substitution rule
2. Creation of worklist
3. Release of the worklist.

Thus we see that there is an additional step for creation of substitution rule for carrying out mass changes to the asset master.

The steps to carry out the same are described below.

The first step to make mass changes to an asset is to create a substitution rule to determine the new value that has to be populated in the asset master data. The substitution rule is created in transaction code GGB1:

Here we create a substitution rule “ABC” to ensure that all assets in a particular asset class are populated with a particular cost center.

In the substitution rule, we determine the value with which the field (here cost center) in the asset master data is to be populated.

The prerequisite for the substitution rule is defined here. Only when the conditions for the company code and cost center as defined below are met, will the substitution rule apply

  The field with which the cost center is to be updated is defined in the “Substitution” step below:

The substitution rule created above is assigned to the company code using the transaction code OA02:

The asset class for which changes in cost center has to be made is added to the worklist using the transaction code AR01

We select the option mass changes to asset master here:

Thereafter we select the substitution that was created for mass change and assigned to the company code in transaction OA02

Subsequently a work queue gets added.

Workqueue 000000948654 added

Then we release the work queue in transaction AR31 as indicated below:

Check the error log tab for errors if any

The asset master data will now show the new value for the cost center:

Thus we see that worklist functionality can be used to carry mass changes to the asset master. This can be used for various fields on a case to case basis depending upon the scenario.