
The Logical Database ADA
Use
The logical data base ADA places the asset master records as well as their transactions at the disposal of the application reports. You can look at the database structure using transaction SE36.
Features
Start Segment
The start segment for the logical database ADA is table ANLA0. This table contains certain control information on the report that is being requested. For example, it contains an indicator that specifies whether or not the report shows assets marked for deletion. This control information improves performance. The information is automatically set by the standard asset reports. You should also use the indicators in the table in reports you program yourself.
Standard Reports
The following functions make up the initial screen of the standard reports
Along with the primary keys (company code, asset main number and sub- number), the following secondary keys are also available to provide for quicker access to information:
In addition to these keys, all fields of the general data section of the asset master record can be used as selection criteria for reports.
Reports can be run at year-end or during the fiscal year. Reporting during the year means that all transactions after the report date will be ignored and only the depreciation up to this date will be calculated. Therefore, it is possible to create an asset list with book values for the first quarter, for example. You can also request past years, providing they are still in the system.
It is also possible to request future years. You can only use this function with the report date set at the end of a year. You then can select whether you want to see just the specified year under review or the annual values of all years up to the desired year under review.
The report date "01/01/YYYY" has a special significance. If this date is selected, the database will deliver the same data as at the end of the previous year. In this way, the system takes into account the fact that the values at the end of the old fiscal year and the beginning of the new fiscal year should be identical, and that you must be able to verify this.
You can specifically request up to three depreciation areas. You can also request all depreciation areas for an asset by entering "*" in the first depreciation area field on the initial screen. However, the only standard report that uses this function is the depreciation compare list. In the other reports you can only enter one depreciation area.
(see
The evaluated data can be provided at three different summarization levels:
The method for translation of currency is a further parameter of the logical database. You can define a translation method in FI-AA Customizing (Translation methods). You can enter this method when starting a report. The system then determines the asset values according to the defined currency translation method and in the respective currency.
If you have made use of the customer modification projects, it is possible to
User-Defined Reports
Some functions of the logical database do not appear directly on the initial screen of the standard reports. However, you can use these functions to create your own reports.
If desired, you can request a report that displays only one data record for each asset main number. That means the values of the asset are summarized at the asset main number level. The system then uses the master record information, as well as the depreciation area information, from the first asset sub-number that has values (including 0000).
The application table ANLA has more extensive information and is made available to the report in a special structure (ANLAV).
This information includes:
In addition to the stored values, the transferred value field structure also contains different totals calculated at the time of the creation of the report, such as the net book value at the end of year.
Along with the capability of reporting on capitalized assets, it is possible to create reports for planned capital investments (orders/projects/program positions). These planned investments are then evaluated in the light of the data from their depreciation simulation.

For a detailed description of the logic, and the value fields at your disposal, see the online documentation for the logical database ADA.