Drilldown Reporting: Link to the Transaction Manager

 

Drilldown reporting is a dialog-oriented information system for finding related business data and analyzing it with a high level of detail.

The drilldown reporting tool enables you to define your own reports on the basis of structures containing characteristics and key figures. You can use the key figures delivered with the system as a basis for defining your own key figures. You can group the characteristic attributes and values in a hierarchy.

Features

You can create reports in the Information System for the following areas:

  • TRM operative/parallel: For a given date

  • TRM operative/parallel: For a given period

Note Note

Both report types replace the previous report types that only evaluated data in the operative valuation area.

Reports based on a report type that is no longer supported must be converted manually to the new report type.

End of the note.

You can use Characteristics and Key Figures to define reports for each report type.

Reporting for a Given Date

These reports provide a view of the transactions and positions for a specific key date (or several key dates).

Reporting for a Given Period

These reports evaluate transactions and other position changes over a given period (or several periods) on the basis of flows, which are the smallest units in the SAP system.

A flow can describe/result in the following:

  • A payment

  • A profit/loss

  • A change in the position

In the Information System, a payment is described by the key figure Payment amount, and a profit/loss by the key figure Profit/loss amount. A flow can affect a position in different ways:

  • On the one hand, the position is indicated by the nominal amount or number of units. The nominal amount is an amount that is independent of accounting activities, the profit and loss statement, or the financial statement. It can be interpreted as an an external position value.

  • The system also contains the accounting values for transactions, contracts and positions, such as the book value and the acquisition value (if write-downs exist).

The flow information is mapped by the following key figures:

  • Payment amount in PyC and LC

  • Profit and loss amount in PLC and LC

  • Change in quantity (nominal, units)

  • Change in (book) position (display currency, position currency, amortizations)

Currency References

Standard currency references for reporting apply across the Transaction Manager.

Cross-TRTM reporting

  • Reporting for a given date

    Here, the long side and the short side each have a different currency reference. This enables you to map currency swaps correctly, for example.

    All other position key figures refer to the position/transaction currency, or to the local currency. If a report contains a mixture of nominal amounts and other position key figures, you need at least two currencies.

  • Reporting for a given period

    The reference currency of flow key figures that describe a change in a position value is identical to the reference currency for the corresponding position key figure.

Non-operative currencies

In addition to the currencies used in the operative Treasury view (such as position currency, transaction currency, contract currency, quotation currency, or payment currency), other currency references have been defined specifically for reporting. These are primarily used to standardize and group the data when currency amounts with different source currency references are mapped in a single key figure.

  • Profit/loss currency

    Since a profit/loss can result from various activities, such as payments (interest, dividends, or charges), value adjustments (valuation), or accruals/deferrals, the term Profit/loss currency was introduced to describe the currency in which the profit or loss occurred:

    Profit/loss currency =

    Payment currency

    for interest, charges, and so on

    Position currency

    for valuation, and so on

More Information