General Ledger: Balances – Quarterly Breakdown

Technical name: 0FIGL_C01_Q0030

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 account balances of the year under review are compared with the balances of the previous year.

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 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.

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)

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)

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

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