Accounting Analyzer

The Accounting Analyzer enables you to evaluate positions and subpositions (B-HA) of the Transaction Manager with regard to the position component values.

The Accounting Analyzer reads the position component values of the positions and subpositions from the Transaction Manager and stores them as key figures in the Result Database (RDB). This enables you, for example, to store the position component values on a daily or weekly basis based on the original market data in the Result Database. You also can calculate your own position key figures (based upon the original position components) which are not available in the position management of the Transaction Manager.

From the Result Database, you can generate reports in the Analyzer Information System (AIS), which displays these key figures.

You can set up portfolio hierarchies with differentiation criteria unequal to company code, security class, and security account, which enables you to aggregate position values on different levels. For example, you can aggregate the values on the product type level.

This graphic is explained in the accompanying text.

The Accounting Analyzer saves the results of all evaluations in the Result Database (RDB).

The Accounting Analyzer calculates all key figures based on the key figure categories, which are predefined in the system. You assign each key figure to an evaluation procedure. You can assign more than one key figure to each evaluation procedure, but each key figure can be assigned once only.

The following key figure categories are available:

AAPOS Position Key Figure
- AAPOSCC Position Key Figure in Calculation Currency
AAGENPOS Generic Position Key Figure
- AAGENPOSCC Generic Position Key Figure in Calculation Currency

You create key figures by choosing a key figure category and entering the attributes of the key figure. You can also use existing key figures as the basis for defining new key figures. You do this by specifying a basic key figure when you define the new key figure. The system then copies the values of the basic key figure and adds them to the new key figure.

Single Record Procedure (SRP)

In the single record procedure, the system takes the position values in position currency or local currency stored in the Transaction Manager and loads them into the result database.

Final Results Procedure

The system translates the position values and flows calculated in the single records procedure into the calculation currency.

Implementation Considerations

You use the Accounting Analyzer for analyzing your positions and subpositions in the Transaction Manager. To do so, you need to create financial objects for each position and subposition.
You can activate the automatic financial object integration for positions and subpositions in Customizing for TRM under Basic Analyzer Settings Automatic Integration of Financial Objects in Transaction Master Data Subledger Positions and Subpositions Activate/Deactivate Financial Object Integration .

Under Basic Analyzer Settings Automatic Integration of Financial Objects in Transaction Master Data Subledger Positions and Subpositions Define Derivation Strategy for Subledger Positions and Subpositions , you define rules for automatically filling the fields of the financial object.

If you do not use automatic integration, you can create the financial objects for the subledger positions and subpositions by using function Maintain Financial Object for Subledger Position and Subpositions (transaction JBDO1). This function can also be used to change an existing FO.
In the Customizing of the TRM under Accounting Analyzer Valuation Settings Define and Set Up Evaluation Types , you have to define one or more evaluation types.
To read the position component values from the Transaction Manager, you have to Define Key Figures and Evaluation Procedures (Transaction AFWKF_AA). You do this in Customizing for TRM under Accounting Analyzer Result Database .
To display and aggregate key figures in the Analyzer Information System (AIS), you have to create Portfolio Hierarchies. You do this in the area menu of the Accounting Analyzer under Evaluation Control Portfolio Hierarchy Create . See also: Editing Portfolio Hierarchies
We recommend that you define a filter to restrict the analysis to particular transactions. Note the additional information about Customizing for the respective activity in the Implementation Guide: Define Filters
To display the results, you need to define a layout . Note the additional information about Customizing for the respective activity in the Implementation Guide: Define Initial Layout

Integration

The Accounting Analyzer is part of the SAP Treasury and Risk Management (TRM).

Features

Accounting Analyzer Tools

Basic settings in Customizing and master data mentioned under Implementation Considerations.
The financial objects have to be created (automatically or manually).

Generate the values for single records key figures for the selected financial objects, and save them on the database. To do this, choose Start of the navigation path Tools Next navigation step Result Database Determine Single Records End of the navigation path .

You need to distinguish between the following runs when generating the single records:

Run	Description
Basic Run/Basic Run with Test Selections from Filter	Key figure values are calculated
Correction Run with Test Selections from Filter	Key figure values are calculated for the following positions/subpositions: Positions/subpositions that were imported into the system after the generation of single records was started Incorrect positions/subpositions that have been changed after the basic run was carried out
Reversal Run	The single records acquire reversed status and can be regenerated in a basic run

Run

Description

Basic Run/Basic Run with Test Selections from Filter

Key figure values are calculated

Correction Run with Test Selections from Filter

Key figure values are calculated for the following positions/subpositions:

Positions/subpositions that were imported into the system after the generation of single records was started

Incorrect positions/subpositions that have been changed after the basic run was carried out

Reversal Run

The single records acquire reversed status and can be regenerated in a basic run

If you choose a save ID, you can use a saved dataset to analyze an individual record. This is useful for some analyses and for testing purposes in particular.

Generate the key figure value for the final results on the basis of the single records that have already been generated. Save the data to the database. To do this, choose Tools Result Database Determine Final Results .

Note
If, after having carried out a basic run for single records, you start a basic run for the final results and then start an adjustment run for the single records, your data may be inconsistent. Therefore, you need to ensure that you delete the final results in a deletion run and restart the basic run for final results after the correction run for the single records has finished.

End of the note.

The key figure values at single record and final results level are stored on the result database.

To delete single records, go to the SAP Easy Access Screen and choose AccountingFinancial Supply Chain Management Treasury and Risk Management Accounting Analyzer Tools Results Database Delete Non-Archived Single Records

You should use this transaction in your test system only. In your productive system, you should reverse single records. Choose Accounting Financial Supply Chain Management Treasury and Risk Management Accounting Analyzer Tools Result Database Determine Single Records .

Single records generated in this way can be archived.
You can use the Analyzer Information System to display them.