Define Your Own Sort Versions in FI-AA Reports

  • by Maria Nikolova, SAP Senior Expert, National Electricity Company
  • February 15, 2008
You can use transaction OAVI to create your own sort versions for standard Asset Accounting reporting, adjusting for business scenarios that aren’t covered by your system’s standard sort versions. Also, see some SAP Notes that are useful for troubleshooting.
Key Concept

The Asset Accounting (FI-AA) module contains a sort version (formerly called a sort variant) that you can use to set your sort values for most asset reports. You use sort versions not only for sorting but for totaling the data records in report lists in FI-AA. Sort versions do not alter the data. They are not selection parameters and do not serve as items to query the asset database. They are simply presentation tools to subtotal asset values by the data elements that are most applicable for that particular report. You can execute a report with different sort versions, and you’ll receive the same number of asset records and the same total values. They’ll just be ordered and totaled differently.

All Asset Accounting (FI-AA) experts need to be familiar with the process for creating their own sort versions for FI-AA reporting. SAP provides 23 standard sort versions to accommodate various business scenarios, but sometimes you need to create new sort versions that are in accord with the reporting needs of your company. The customer namespace for this table is X, Y, and Z. Customer-defined sort versions should begin with these letters.

To maintain sort versions, use the standard SAP menu path Accounting > Financial Accounting > Fixed Assets > Information System > Tools > Sort Variants or transaction OAVI. You can also define them in the IMG by following menu path Financial Accounting > Asset Accounting > Information System > Define Sort Versions for Asset Reports.

Currently, not enough information is widely available about creating sort versions for FI-AA reporting. I’ll show you the process of creating sort versions based on my experience. This article is valid for SAP R/3 and SAP ERP Central Component (ECC) systems.

Maria Nikolova

Maria Nikolova has worked as a senior SAP expert for the National Electricity Company (NEK) in Bulgaria since January 1999. Maria has a master’s degree in telecommunications as an engineer from the Technical University in Sofia, Bulgaria. She has experience with an MIS project implementation of SAP R/3 (headquarters and rollout), the authorization concept and user administration, SAP Customer Competence Center (SAP CCC) , SRM, and the SD, HR, CO, Asset Management (AM), MM, and PM modules. Prior to joining NEK, she worked as a manager of Equipment Engineering Ltd. for four years.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.