General Ledger: Structured Balances, Quarterly Breakdown

Technical name: 0FIGL_C01_Q0040

Based on InfoCube: 0FIGL_C01

Use

This query displays the balances of your G/L accounts as a quarterly breakdown of 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.

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 relevant quarter. 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 statement 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.

Filters

InfoObject

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

0COMP_CODE

Company code

0CHRT_ACCTS

Chart of accounts

0FISCVARNT

Fiscal year variant

0FISCYEAR

Fiscal year

0CURTYPE

Currency type (company code currency = 10)

0VTYPE

Value type for reporting (actual = 10)

0VERSION

Version (plan version=001)

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

Rows

InfoObject

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

0GL_ACCOUNT

G/L account

Columns

InfoObject

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

Previous year: Balance of 1st quarter

Accumulated balance of 1st quarter of previous year

Previous year: Balance of 2nd quarter

Accumulated balance of 2nd quarter of previous year

Previous year: Balance of 3rd quarter

Accumulated balance of 3rd quarter of previous year

Previous year: Balance of 4th quarter

Accumulated balance of 4th quarter of previous year

Selected fiscal year: Balance of 1st quarter

Accumulated balance of 1st quarter of selected fiscal year (periods 1 – 3)

Selected fiscal year: Balance of 2nd quarter

Accumulated balance of 2nd quarter of selected fiscal year (periods 4 -6)

Selected fiscal year: Balance of 3rd quarter

Accumulated balance of 3rd quarter of selected fiscal year (periods 7 -9)

Selected fiscal year: Balance of 4th quarter

Accumulated balance of 4th quarter of selected fiscal year (periods 10 -12)

Which periods are displayed in the individual quarters is dependent on the fiscal year variant of the selected company code.