General Functions of Standard Reports
The Asset Accounting Information System offers report selection in the form of a report tree. This report selection tree is a freely definable hierarchical structure. You specify the structure of the report tree in FI-AA Customizing under Information System (seeReport Selection).
In the list reports in the standard report selection for Asset Accounting, there are a series of general functions which are discussed below.
All of the reports in the standard report selection tree are pre-defined with report variants. Therefore, when you call them up, the initial selection screen appears in a simplified form. You can make different initial selections (such as, by asset number, asset class, cost center, location, and so on).
If you want to see the full initial selection screen, choose the All selections function in the selection screen, One of the important pre-defined options in the standard reports is "Display group totals only." If you also want to display individual assets, you can change this option in the full selection screen, which you reach by choosing All selections. The report variants all begin with "SAP..." You can copy these variants, if needed. Or you can manually create new variants, and enter them in the report tree.
The function Dynamic selections in the selection screen of the report enables you to narrow the selection of the report even further than the standard selections. You can use all the fields in the general part of the asset master record to limit the report. To do this, you select from the fields displayed (master data fields) in the resulting pop-up window, and choose them with the function Selections. In the screen that then appears, you can further limit the values for the report.
The sorting/totaling of the data records that are issued is variable and is determined on the initial screen of the report by specifying the sort version (seeSort Versions).
Currency Translation Methods
The method for currency translation is another parameter of the logical data base. You can define the translation method in Asset Customizing (Information System) and enter it when starting a report. The system then determines the asset values according to the defined currency translation method and in the respective currency.
The report date has a special significance in the selection criteria for the report. It establishes the fiscal year for the evaluation. In the documentation this fiscal year (for which the report is being run) is referred to as the "current fiscal year."
You have to enter the report date in the form of a calendar date. For shortened fiscal years, the system automatically determines the fiscal year concerned based on the fiscal year version in the respective company code. The following scenarios are possible:
For reports for the past, the system uses the report date to determine whether it uses the online database or an archive file.
Evaluations Including Special Periods
Special periods can be taken into account in reports which include posting transactions (asset history sheet, transaction data report). You need to specify the last day of the fiscal year as the report date.
By selecting parameters for the way the report lists assets, you determine whether the report
Summary reports are especially useful for very large datasets. Using summary reports, you can access summarized totals information, without having to create extremely long lists.
By double clicking on a totals line, you can get a detailed list of all the assets that make up the total. Using the function Different report in the list display of a standard report, you can call up other reports (totals and individual lists). For more information, seeReport Interfaces to Other R/3 Components.
You can use the Choose function in most lists. The system then provides additional information which differs depending on the object that you select. The objects that can be selected are:
The system jumps to the display of the asset master record.
The system jumps to the display of the document.
The system jumps to the display of the order or project.
The system jumps to long text for the error, if assets with errors appear in the log.
The system jumps to the display of the replacement rules in the simulation version that was used.
By entering a number 'nnnnn' in this selection field, a ranking list — one per company code —is issued containing the top nnnnn fixed assets. It is sorted in descending order by the value field which you marked under "sorting according to value field".
Sorting by Value Field
When starting the report, you can also specify that additional sorting take place according to value field on the lowest sort levels of the list. You can choose all or some of the value fields issued in the respective report.
Sorting is carried out in descending order from the actual amount of the value field. This request only makes sense for a report on individual assets (that is, not a summary report). If you requested a ranking list, you must mark a value field here. The ranking list is then created with reference to this value field.
Reports that encompass all the assets in the system are very demanding on system performance. For this reason, you have to start reports of this kind as background processing (in the report selection screen: Program® Execute in background). You can select a maximum of 1000 assets online.
Additional Entries for Batch Run
By specifying an additional heading, you can modify the list header. The list header then contains the specified additional heading.
By selecting this parameter, you can specify separate output destinations for each company code according to table TLSEP.
By selecting this parameter, you can modify the list header. The list header then contains, among other things, information relevant for microfilming.
You can combine these parameters in any way you want.
You can also download reports to Microsoft Excelã. You create a file for this purpose in the online display of FI-AA reports under Edit. The following conditions have to be met in order to use this procedure:
The system guarantees the consistency between the R/3 database and the archive. Therefore, you can access the archive from the R/3 system. The system uses the report date to determine whether it should access the online database or the archive.
However, the functions for Dynamic selections and Worklist (seeMass Changes) are not available when you use archive reports.