Show TOC

Balance Sheet Planning on Years Locate this document in the navigation structure

Query Query: /ERP/SFIN_AA0_IRQ0001

 

You can use this query to plan your balance sheet in a fiscal year. The query is based on aggregation level /ERP/SFIN_AA0 and is used in workbook Balance Sheet Planning on Years (/ERP/SFIN_AA0_WB01)

Example Example

You are the manager of the financial department and want to plan the payables to credit institutes for the coming year. To do this, you start the query and specify in the selection screen for the following selection criteria the values for which you want to plan balances:

  • The coming fiscal year

  • The category

  • The company code

  • The currency

  • The account group to which the plan the payables to credit institutes belong

Once you have confirmed the selection criteria, a table is displayed with columns for the general ledger accounts, the actual values of the previous fiscal year, the planned values of the coming year, and the differences. The fields in the plan column are ready for input. You can enter there your planned payables in the rows for the corresponding G/L account. The actual values of the general ledger account include the balance carryforward.

End of the example.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Client

0MANDT

Characteristic Characteristic

Fiscal Year

0FISCYEAR

Characteristic Characteristic

Currency

0CURRENCY

Characteristic Characteristic

G/L Account

/ERP/GL_ACCT

Characteristic Characteristic

Controlling Area

/ERP/CO_AREA

Characteristic Characteristic

Company Code

/ERP/COMPCODE

Characteristic Characteristic

Chart of Accounts

/ERP/CHRTACCT

Characteristic Characteristic

Fiscal Year Variant

0FISCVARNT

Variables

Object Type

Name

Technical Name

Variable Variable

Fiscal Year

/ERP/P_0FISCYEAR01

Variable Variable

Category

/ERP/P_CATEGORY

Variable Variable

Company Code

/ERP/P_COMPCODE01

Variable Variable

GL Account Hierarchy

/ERP/H_GL_ACCT01

Variable Variable

GL Account / GL Account Group

/ERP/N_GL_ACCT01

Variable Variable

Currency

/ERP/P_CURRENCY02

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

G/L Account

/ERP/GL_ACCT

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Total Actual

/ERP/T_FISCYEAR01

Key Figure Key Figure

Total Plan

/ERP/T_FISCYEAR01

Formula Formula

Difference Plan Actual