Information System 

Purpose

You can use the Information System in the Transaction Manager  to execute the reports defined by SAP or to create your own reports.

When defining reports, you can used the tools SAP Query and SAP Drilldown Reporting, or load data into the Business Information Warehouse for analysis.

Integration

To access the Information System, choose Accounting ® Financial Supply Chain Management ® Treasury and Risk Management ® Transaction Manager ® Information System.

Features

...

●     Logical Databases for the Transaction Manager

Logical databases (LDBs) have been created to provide easier access to data in the Transaction Manager.

These databases provide a structured, integrated view of the system database tables. They provide a pool of table fields for a particular business function. In doing so, they encapsulate access to up to 100 database tables and integrate certain calculation procedures (for example, the NPV calculator).

Logical Database	Use
FTI_TR_POSITIONS Positions	You can use this LDB to evaluate positions in the Transaction Manager for a given key date. This enables you to analyze all the key figures and characteristics that are relevant for accounting for the specified key date.
FTI_TR_PERIODS Period Evaluations	You can use this LDB to evaluate flows in the Transaction Manager for a given period. This enables you to analyze position trends and revenues within the selected period, including positions at the start and end of the period, on a flexible basis.
FTI_TR_PL_CF Revenue Reporting	You can use this LDB to evaluate revenues/flows incurred within a given period. This enables you to analyze all the revenues for the respective due date or period.
FTI_TR_CASH_FLOWS Payment Information	You can use this LDB to evaluate payments in the Transaction Manager for a given period. You can flexibly analyze payment flows from transaction management within the selected period.
FTI_TR_DEALS Transaction Reporting	This LDB evaluates information from transaction management. You can use the logical database for front office-based reporting. These functions enable cross-application reporting over the various financial products. In addition to cash flow-based evaluations, you can also create transaction data reports.

 To improve system performance, all LDBs are accessed by a field list which includes only the fields and their nodes that are required by the calling program for the period.

The graphic above provides an overview of the data that can be accessed in the Transaction Manager and the logical database from which it originates. The logical databases FTI_TR_POSITIONS and FTI_TR_PERIODS provide access to data in position management. You can use LDB FTI_TR_DEALS to evaluate your transaction management data, and analyze payment flows with FTI_TR_CASH_FLOWS. The logical database also contain key figures from market risk management that are required for evaluation purposes.

●     Using SAP Query for the application areas in the Transaction Manager:

○     SAP Query is used to generate lists that are not yet contained in the standard system. It has the advantage that the user can create comprehensive reports without having to carry out manual programming.

SAP Query comprises the components Queries and InfoSet Query for defining reports, the component InfoSets to maintain InfoSets, the User Groups to manage user groups, and the Translation/Query component that can be used to translate texts created in SAP Query.

See also:

For more information about the SAP Query features and its use, see SAP Query.

○     To evaluate data in the Transaction Manager using SAP Query, you should use the logical databases for the Transaction Manager. The logical databases have been designed in a way so that you can use them according to their evaluation purposes.

You can use InfoSets for the Transaction Manager to define reports and various report forms, such as basic lists, statistics, and ranked lists.

Some Standard Queries for the Transaction Manager have also been defined that you can execute or use as a copy template.

○     To use the functions for maintaining queries, InfoSets, and user groups, choose Transaction Manager ® Information System ® Tools ® SAP Query.

●     Link to the Business Information Warehouse (BW):

The Transaction Manager has been linked to the Business Information Warehouse (BW). In doing so, the logical databases in the Transaction Manager are used as the basis for the BW extractors.

●     Link to SAP Drilldown Reporting

The link to the SAP drilldown reporting tool enables you to extract position data, position trend data, and flow data from the operative system with user-defined reports. You can present and analyze this data graphically.

You can use drilldown reporting to custom-design reports and to process them interactively. You can evaluate the report results graphically or transfer them to PC applications. The tool also allows you to link reports and organize them hierarchically in a report structure.

You can also create your own ad-hoc reports. When you define reports in this way, you do not need to define forms.

Output with the SAP List Viewer

You can use the link to the SAP List Viewer to display lists with all the characteristics in the lead column.

For more information, see Drilldown Reporting: Link to the Transaction Manager

All the standard reports for the Transaction Manager are located in the report structure delivered with the system. Choose Information System ® Reports.