The Fixed Accounting Asset application it's in Finance domain using the information from SAP Fi-AA (Asset Accounting) module. The main objective of this application is to present data in a format consistent with that in the SAP system. This includes comprehensive details regarding asset master data and values related to acquisitions, depreciations, decreases, and increases of APC, among other pieces of information. This functionality lead the users to conduct various analyses, such as identifying the top 5 acquisitions of the year or quarter. The application has been designed to provide to users who may not have direct access to the SAP system. By providing access through workbooks in BW (Business Warehouse), it enables them to conveniently retrieve and explore this essential information. |
For this Application the access is provided based on the BW menu "FIAA - Fixed Accounting Asset" and it's done via Service one. Fill the form In SAP system select the "WBP - BW Business Warehouse" In WBP - BW Business Warehouse : Select the Business Role select the "FIAA - Fixed Accounting Asset" |
Target Users: Controllers and CAM's |
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 20.09.2023 | Inês Vilares | Initial draft |
|
To understand better the data for the reports it's important to have a general knowledge for the SAP Fi-AA (Asset Accounting) module.
SAP FI-AA, or SAP Financial Accounting - Asset Accounting, is a module within the SAP ERP (Enterprise Resource Planning) system that is primarily focused on managing a company's fixed assets. Fixed assets include tangible assets such as buildings, machinery, vehicles, and intangible assets like patents and copyrights. The main purpose of SAP FI-AA is to enable organizations to track, manage, and account for their fixed assets throughout their lifecycle, from acquisition to disposal.
Key features and functions of SAP FI-AA include:
SAP FI-AA is essential for businesses to maintain compliance with accounting standards, accurately report financial information, make informed decisions about asset management, and optimize asset utilization.
In the system we can see the following information which is relevant for these reports:
For this application find below all the workbooks available:
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| FIAA - WP1/PF1 Detailed Eval. Accounting Grid - Posted dep. | This report as a detail view for the Asset master data. It's possible to see by asset number the values for acquisitions, depreeciation, book value, investment, increse and decrease APC, among other fields for the asset master data based on the depreciation areas, We can see this data for WP1 and PF1 companies. Additionally, we have two sheets:
| Mandatory:
Optional:
| BW_WBK_FIAA_0006 | BW_QRY_CPFIAA04_0001 |
| BW REPORT INSURANCE FORM (Core Workbook) | BW_WBK_FIAA_0004 | |||
| FIAA - Detailed Evaluation Accounting Grid (Core Workbook) | BW_WBK_FIAA_0001 | |||
| FIAA - FC L3005 Balance Sheet by Flow (Core Workbook) | BW_WBK_FIAA_0003 | |||
| FIAA - FC L6720 Assets and Investment Securities/CGU (Core Workbook) | BW_WBK_FIAA_0002 | |||
| FIAA - FC L6710 Investment per CGU and Sites (Core Workbook) | BW_WBK_FIAA_0005 |
For these reports, it’s important to understand some concepts which will allow the user to work with the reports and analyze the data.
| Consolidation View (check) | The query takes the integration rate of the company and the partner from a table managed by GAR.
In this way, the user has 4 options:
|
|---|---|
| Main Asset Number | This is the number which, together with the asset sub-number, identifies a fixed asset in Asset Accounting. Definition for Fixed Asset in Asset Accounting (FI-AA): An object, a right, or another item owned by the enterprise that is intended for long-term use, and can be identified individually in the balance sheet. The development of the values of an asset can be viewed for the asset as a whole, or can be viewed for the asset's component parts (sub-numbers). Example Fixed asset "printing press" with asset components "rollers" and "replacement spindle". |
| Asset Subnumber | This is the number which, together with the main asset number, uniquely identifies a fixed asset in Asset Accounting. Using the asset sub-number, you can:
In contrast to the main asset number, the asset sub-number must be numerical. |
| Asset Class | Asset Accounting (FI-AA): The main criterion for classifying fixed assets according to legal and management requirements. For each asset class, control parameters and default values can be defined for depreciation calculation and other master data. Each asset master record must be assigned to one asset class. Special asset classes are, for example:
|
| Depreciation Areas | Asset Accounting (FI-AA): An area showing the valuation of a fixed asset for a particular purpose (for example, individual financial statements, balance sheets for tax purposes, or management accounting values). Along with "real" depreciation areas, you can define derived depreciation areas. The values for these derived areas are calculated from those of two or more real areas. |
| Depreciation Key | The depreciation key (valuation key) controls the valuation of the asset in the particular depreciation areas. The depreciation key consists of the following:
|
| APC | This stands for "Acquisition and Production costs". Acquisition means any asset which you may acquire/ purchase externally. It includes invoice price and other related exp. Associated with it like customs, octroi, freight which you add and arrive at total cost of acquisition for capitalization of the asset. |
| Depreciation | Is the periodic and permanent decrease in the value of the fixed asset over its economic life period because of its usage and associated wear and tear. The Depreciation component makes it possible to manage the following types of depreciation in the system: Automatically calculated depreciation types (can also be planned manually):
Depreciation types that are normally planned manually:
Depreciation keys control the automatic calculation of depreciation in the system. These depreciation keys can be modified. In this way, you can define your own methods for calculating asset values. |
| Domain | Finance |
|---|---|
| Application | BW reports under FIAA - Fixed Accounting Asset folder |
| Provider | CPFIAA04 |
This section represents the process with detail information for the application. Can include specific or special cases, complex logics , calculations, flows, among others.
Frequency, data, and time of the data refresh in the data product.