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