General Ledger: Balances – Period Breakdown 

Technical name: 0FIGL_C01_Q0050

Based on InfoCube: 0FIGL_C01

Use

This query displays the debit and credit totals and the balances of a G/L account or G/L account interval for the individual posting periods of the specified fiscal year.

This query is not designed to be called up directly from the Business Information Warehouse. Instead, you can branch to it from the queries that display the accumulated or quarterly balances of the separate G/L accounts, and use it to display how an accumulated or summarized account balance or a financial statement item is distributed between the individual posting periods.

This query is therefore not assigned to a role, and does not appear in a workbook. If you activate the Business Information Warehouse from roles and workbooks, ensure that you also activate this query.

Data records in which all key figures (debits, credits, accumulated balance) would be equal to zero are not transferred from the source system to the BW System by the extraction program. In this case, the query does not display any data for the relevant periods.

Filters

InfoObject	Description of the InfoObject (and restriction or calculation formula)
0COMP_CODE	Company code
0FISCVARNT	Fiscal year variant
0FISCYEAR	Fiscal year
0CHRT_ACCTS	Chart of accounts
0GL_ACCOUNT	G/L account
0VTYPE	Value type for reporting
0VERSION	Version
0CURTYPE	Currency type

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

Rows

InfoObject	Description of the InfoObject (and restriction or calculation formula)
0FISCPER3	Posting period

Columns

InfoObject	Description of the InfoObject (and restriction or calculation formula)
Debit total	Total of debit postings in the posting period
Credit total	Total of credit postings in the posting period
Balance	Balance of debits and credits for the posting period
Accumulated balance	Accumulated balance made up of balances from previous periods and posting period