In SAP S/4HANA Cloud asset accountants use the Asset History Sheet to show value changes to the fixed asset balances in a fiscal year for a depreciation area.
Some time ago SAP provided the option to add a WBS Element instead of a Cost Center to Fixed Assets as an Account Assignment Object. This WBS Element can be maintained time-dependent in the app 'Manage Fixed Assets'.
So far, the Asset History Sheet does not support these WBS Elements. The detailed requirement is described in the Customer Influence Portal Request-ID 273655.
This blog post explains how key users can use the apps Custom CDS Views and Custom Analytical Queries to build a new Asset History Sheet, that supports the WBS Element of the time-dependent data.
Create the ‘Fixed Asset Assignment WBS CDS’
Create the ‘Asset History Sheet CDS’
Create the ‘Asset History Sheet Query’
1. Create the 'Fixed Asset Assignment WBS CDS'
Use the app Custom CDS Views and create a new Custom CDS View. The type must be 'Standard CDS View'.
Filters: The filters are defined as user input values so that the user can filter flexibly.
The following default values could be prefiltered:
Key figure group = ‚AHS‘
Fiscal Year = ‚2022‘
Ledger Fiscal Period = ‚12‘
Key date = relative:TODAY (current date)
Valuation Area = ‚1‘
cat./val. type = ‚10‘
Company Code = ‚1001‘
Ledger = ‚0L‘
With these three steps a new Asset History Sheet was built, that supports the WBS Element of the time-dependent data. This architecture can also be used for other asset related reports such as ‘Asset Balances’:
In case you have any questions, please use the SAP S/4HANA Cloud Q&A area. You are also welcomed to provide your feedback in the comment section below. For similar content you can follow my profile or the blog feed SAP S/4HANA Cloud.