Yield Report
Technical name: 0ALM_C01_Q0003
Use
This sample query is similar to a yield report based on balance sheet groups as rows.
The columns are represented by annualized interest rates for all the periods defined in gap analysis. A period is represented as a month with fiscal year variant K4.
Filter
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
Type of filter |
0BA_SAVEID |
ID of a saved gap analysis result |
Mandatory selection parameter |
0COMP_CODE |
Company code |
Optional select parameter |
0BA_INCO_FG |
Interest/capital commitment indicator |
Mandatory selection parameter |
0BA_GAPEVAL |
Report identifier |
Always ‘6’ which represents an interest-based evaluation from ALM gap analysis |
0FISCVARNT |
Fiscal year variant |
Always ‘K4’ which represents the calendar year and 4 special periods. Each period is a calendar month. |
Rows
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
0BA_VLC_GRP |
Balance sheet group |
Columns
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
0AM_C01_CK003 |
Annualized interest rate calculated from interest and volume. This key figure is calculated using the following formula: Interest rate = NDIV0 ( 12 * 'Interest amount' * 100 / 'Volume' ) Where, Interest amount = ABS ( 'Interest income' - 'Interest expense' ) Volume = ABS ( 'Asset-side volume' - 'Liab.-side volume' ) |
0FISCPER |
Fiscal year/period |