Logical Database FTI_TR_PL_CF

Use

You can use the FTI_TR_PL_CF logical database (LDB) to evaluate revenues and maturities within a given period. This enables you to analyze all the revenues for the respective due date or period.

This graphic is explained in the accompanying text.

The FTI_TR_PL_CF logical database is part of LDB FTI_TR_PERIODS that was put together specifically to achieve better performance in profit/loss reporting.

Integration

This LDB is used for InfoSets in the SAP Query application.

Prerequisites

You need to make your profit/loss Customizing settings.

Features

Assign Revenues to the Positions

In position management, you can create positions according to various criteria. In the securities module, for example, you can specify whether positions should be created at the level of securities account, securities account group, portfolio, or lot (single position). The corresponding revenues therefore relate to different calculation bases.

The logical database FTI_TR_PL_CF ensures that the revenues in position management are assigned correctly to the respective positions.

You can use this field to select positions that are defined using the following differentiation terms: valuation area, special valuation class, accounting code, ID number, and portfolio.

Relationship between selection fields Securities Account and Securities Account Group

If securities account was selected as the only differentiation criteria in a valuation area, a selection based on securities account group will not return any positions. If you leave the securities account group field empty, the system gets the relevant positions. In the report display, the Securities Account Group field is not filled.

If securities account group was selected as the only differentiation criteria in a valuation area, a selection based on securities account will not return any positions. If you leave the securities account field empty, the system gets the relevant positions. In the report display, the Securities Account field is not filled.

If both securities account and securities account group are selected as differentiation criteria, selections are based on both the securities account and securities account group , however in this case you cannot carry out a cross-securities account valuation.

You often have a scenario in which one parallel valuation area only uses the securities account group as the differentiating criterion, and a second parallel valuation area only uses the securities account. If you want to evaluate a securities account group (as defined in the securities account master data) for both valuation areas, and restrict the selection for the securities account group accordingly, no positions are selected for the valuation area that is differentiated by securities account, and vice versa. For this reason there is an indicator, Interpretation of Securities Account Group , described below.

If you select positions by securities account group for a valuation area that is only differentiated by securities account, the system selects the securities accounts assigned to this securities account group in the securities account master data.

In the report display, the otherwise empty Securities Account Group field is filled.

Remaining term

The remaining term lets you see the terms of the capital investments that belong to the position. The remaining term is computed as the difference between two dates, as specified on the selection screen.

Remaining term based on key date

The report computes the difference between the end of term of the financial product and the selected key date.

Remaining term based on today

The report computes the difference between the end of term of the financial product and the current date.

Remaining term based on reference date

Here, an additional date field is shown. The report computes the difference between the end of term of the financial product and the specified reference date.

Three characteristics are available in the logical database for the output of the remaining term:

Remaining term in days

Remaining term in months

Remaining term in years

Historical account assignment reference indicator

If you select this indicator, the system may access historical data when evaluations are made in the past, instead of reading the current account assignment reference. For example, if an account assignment reference transfer was posted in the past, the system displays the account assignment references and G/L accounts as per the respective key date.

Summarize results indicator

Summarizing Results using Characteristics

Hide zero records indicator

If this indicator is set, the data records containing key figures selected in the report definition with a key date value of zero are excluded from the report output.

Only positions with flows in period indicator

If the indicator is set, only the positions with flows in the selection period are selected and displayed.