Entering content frame

Query General Ledger (New): Balances – Cumulated, Comparison with Previous Year Locate the document in its SAP Library structure

Technical name: 0FIGL_C10_Q0002

Use

This query displays the cumulated account balances for the selected reporting period. The account balances of the year under review are compared against 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 for which the 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 are displayed.

When you call up the query, you must enter the posting period until which the cumulated account balances are to be displayed for the specified posting period and the previous posting periods of the selected fiscal year.

Filters

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0FISCVARNT

Fiscal year variant (SAP exit 0P_FVAEX)

0COMP_CODE

Company code (single value entry, required)

0VTYPE

Value type ( = 10 (actual))

0CURTYPE

Currency type (single value entry, required)

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

Free Characteristics

None.

Variables Used

Variable

Description

0P_FVAEX

Fiscal year variant (SAP exit)

0P_COCD

Company code (single value entry, required)

0P_CURRT

Currency type (single value entry, required)

0I_GLAC

G/L account (interval entry, optional)

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0GL_ACCOUNT

G/L account (interval entry, optional)

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Balance 1 through &0T_FPER3& &0T_FYEAR&

Balance of same period from previous year

Balance 1 through &0T_FPER3& &0T_FYEAR&

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

Report/Report Interface

None.

 

 

 

 

Leaving content frame