Start of Content Area

Query Traditional Income Statement  Locate the document in its SAP Library structure

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

 

 

End of Content Area