Skip to Content
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:
/wp-content/uploads/2014/12/pic1_613719.png
Here we create a substitution rule “ABC” to ensure that all assets in a particular asset class are populated with a particular cost center.
/wp-content/uploads/2014/12/pic2_613720.png
In the substitution rule, we determine the value with which the field (here cost center) in the asset master data is to be populated.
/wp-content/uploads/2014/12/pic3_613742.png
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
/wp-content/uploads/2014/12/pic4_613743.png
  The field with which the cost center is to be updated is defined in the “Substitution” step below:
/wp-content/uploads/2014/12/pic5_613744.png
/wp-content/uploads/2014/12/pic6_613748.png
The substitution rule created above is assigned to the company code using the transaction code OA02:
/wp-content/uploads/2014/12/pic7_613777.png

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

/wp-content/uploads/2014/12/pic8_613778.png

We select the option mass changes to asset master here:

/wp-content/uploads/2014/12/pic9_613779.png

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

/wp-content/uploads/2014/12/pic11_613780.png

Subsequently a work queue gets added.

/wp-content/uploads/2014/12/pic12_613805.png

Workqueue 000000948654 added

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

/wp-content/uploads/2014/12/pic13_613807.png

/wp-content/uploads/2014/12/pic14_613811.png

Check the error log tab for errors if any

/wp-content/uploads/2014/12/pic15_613813.png

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

/wp-content/uploads/2014/12/pic16_613816.png

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.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply