General Ledger: Structured Balances - Accumulated

Technical name: 0FIGL_C01_Q0010

Based on InfoCube: 0FIGL_C01


This query displays the accumulated account balances for the selected reporting period. The G/L accounts appear in a hierarchical structure. The account balances of the year under review are compared with the balances of the previous year, and the difference between the two is shown both in absolute terms and as a percentage.

When you call up this query, you must make entries in a number of parameters. Note that:

          • The posting period means the "To period", so that the accumulated account balances for the specified posting period and the previous posting periods of the selected fiscal year are displayed.
          • The financial statement version INT is defaulted for your G/L accounts. If you do not use the financial statement version INT in your system, you can enter your own financial statement version. However, you must make certain settings before you can use your own financial statement version in the Business Information Warehouse. For more information, see Notes on Tailoring.

When you display the query, you can also see how the accumulated balance of a G/L account is distributed between the individual posting periods of the fiscal year. You do this by branching to the query General Ledger: Balances – Period Breakdown. You call up this query by placing the cursor on the required balance of the G/L account or financial statement item and choosing SAP Business Explorer ® Goto ® GL: Balances – Period breakdown, or using the right mouse button to choose Goto ® GL: Balances – Period breakdown.

The posting periods displayed in the period breakdown apply to the fiscal year of the report row you selected. In other words, the fiscal year is determined by the row on which you have placed the cursor, not by the entry you make on the selection screen.

Notes on Tailoring

Financial statement version

If you wish to use your own financial statement version in the query, you need to make the following settings and ensure the following prerequisites have been met.

  • The financial statement version you wish to use must be defined in Customizing in your source system. To do this, choose General Ledger Accounting ® Business Transactions ® Closing ® Documenting ® Define Financial Statement Versions in Customizing for Financial Accounting.

You can either use an existing financial statement version in your query (such as the version you use for creating your financial statements), or define a separate structure specifically for the Business Information Warehouse.

Make sure that all G/L accounts appear only once in the version you wish to use. It is not possible to display the balances of G/L accounts in different financial statement items in the Business Information Warehouse.

If a G/L account appears twice in a structure, the transaction figures of that account will be displayed at two points in a structured list of balances in the Business Information Warehouse, and will be included twice in the subtotals. The G/L account is shown in duplicate up until the higher-level node at which all branches meet that contain this account. This can lead to discrepancies between the higher-level total and the sum of the subtotals.

  • You must load the required financial statement version from the source system into your Business Information Warehouse as a hierarchy for the characteristic G/L Account. For more information, see Loading Hierarchies.

Closing entries

This query constitutes, at most, a preliminary stage of the financial statement since, in contrast to the creation of the financial statements using program RFBILA00, the following closing entries cannot be made in the Business Information Warehouse:

  • Comparison of costs and revenues in the retained earnings account, and calculation of the balance, that is, the profit or loss
  • Corresponding posting of the profit or loss to the equity account in the financial statements

You can make these entries in the Excel sheet for your query, which will enable you to create your financial statements completely in the Business Information Warehouse.



Description of the Info Object (and restriction or calculation formula)


Company code


Chart of accounts


Fiscal year variant


Fiscal year


Posting period


Currency type (company code currency = 10)


Value type for reporting (actual = 10)


Version (plan version = 001)

The system derives the fiscal year variant and the chart of accounts from the company code.



Description of the Info Object (and restriction or calculation formula)


G/L account



Description of the Info Object (and restriction or calculation formula)

Balance of selected fiscal year

Balance of the reporting period from the selected fiscal year

Balance of previous year

Balance of same period from previous year


Difference between selected fiscal year and previous year

Difference as percentage

Difference between selected fiscal year and previous year as percentage