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
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.
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Client | 0MANDT | |
Characteristic | Fiscal Year | 0FISCYEAR | |
Characteristic | Currency | 0CURRENCY | |
Characteristic | G/L Account | /ERP/GL_ACCT | |
Characteristic | Controlling Area | /ERP/CO_AREA | |
Characteristic | Company Code | /ERP/COMPCODE | |
Characteristic | Chart of Accounts | /ERP/CHRTACCT | |
Characteristic | Fiscal Year Variant | 0FISCVARNT |
Object Type | Name | Technical Name |
---|---|---|
Variable | Fiscal Year | /ERP/P_0FISCYEAR01 |
Variable | Category | /ERP/P_CATEGORY |
Variable | Company Code | /ERP/P_COMPCODE01 |
Variable | GL Account Hierarchy | /ERP/H_GL_ACCT01 |
Variable | GL Account / GL Account Group | /ERP/N_GL_ACCT01 |
Variable | Currency | /ERP/P_CURRENCY02 |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | G/L Account | /ERP/GL_ACCT |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Key Figure | Total Actual | /ERP/T_FISCYEAR01 | |
Key Figure | Total Plan | /ERP/T_FISCYEAR01 | |
Formula | Difference Plan Actual |