General Ledger: Balances – Accumulated, Comparison with Previous Year

Technical name: 0FIGL_C01_Q0020

Based on InfoCube: 0FIGL_C01

Use

This query displays the accumulated account balances for the selected reporting period. 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.

You can restrict the number of accounts whose balances are to be displayed. To do so, enter an account interval on the selection screen. If you do not enter a G/L account interval, the balances of all G/L accounts will be displayed.

When calling up the query, you must enter the posting period. For this query, 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.

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.

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

0FISCPER3

Posting period

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)

Balance of previous year

Balance of same period from previous year

Balance of selected fiscal year

Balance of the reporting period from the selected fiscal year

Difference

Difference between selected fiscal year and previous year

Difference as percentage

Difference between selected fiscal year and previous year as percentage