Technical name: 0ALM_C01_Q0002
Use
This sample query is similar to traditional income statements based on G/L accounts as rows in structural format. 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.
Assign the GL accounts to the corresponding structures.
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 options |
|
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) |
|
Investments |
Include the GL accounts for investments in this selection |
|
Commercial loans |
Include the GL accounts for commercial loans in this selection |
|
Interest income |
Investments + Commercial Loans |
|
Time deposits |
Include the GL accounts for time deposits in this selection |
|
Deposit expenses |
This is the subtotal of all time deposits |
|
Borrowings |
Include the GL accounts for borrowings in this selection |
|
Borrowing expenses |
This is the subtotal of all borrowings |
|
Interest expense |
Deposit expenses - borrowing expense |
|
Net interest income |
Interest income - interest expense |
Columns
|
Characteristics/Key figures |
Description of the InfoObject (and selection criteria or calculation formula) |
|
0ALM_C01_CK002 |
Interest amount. This is a calculated key figure that represents the absolute difference between interest income (0BAASINT) and interest expense (0BALSINT). Note: For characteristics that represent assets only, liability interest is always zero, and vice versa. Hence the difference would be same for this data. |
|
0FISCPER |
Fiscal year/period |