You can use this query to enter your planned costs and revenues in a fiscal year for one or more functional areas at period level. The query is based on aggregation level /ERP/SFIN_A81
, and is used in workbook Functional Area Planning on Periods (/ERP/SFIN_A81_WB01
).
Example
You are manager of the controlling department and, once you have checked cost center planning, want to round off the plan financial statement according to the cost of sales method, by planning additional costs in the travel expenses area in the coming fiscal year at period level. 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 costs:
The coming fiscal year
The category
The company code
The currency
The relevant functional area
Once you have confirmed the selection criteria, the system displays a table with columns for the functional areas (the specified functional area), the general ledger accounts (cost elements), the actual values of the previous fiscal year, the planned values of the coming fiscal year, and a difference column. There is a column in the query for periods 1 - 12 for the year selected for both actual and planned values. The fields in the plan columns are ready for input You can enter there your planned costs in the row for G/L account Travel Expenses
.
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Company Code | /ERP/COMPCODE | |
Characteristic | Fiscal Year Variant | 0FISCVARNT | |
Characteristic | Currency | 0CURRENCY | |
Characteristic | Posting Period | 0FISCPER3 | |
Characteristic | Client | 0MANDT | |
Characteristic | Functional Area | /ERP/FUNCAREA | |
Characteristic | Controlling Area | /ERP/CO_AREA | |
Characteristic | Chart of Accounts | /ERP/CHRTACCT | |
Characteristic | G/L Account | /ERP/GL_ACCT |
Object Type | Name | Technical Name |
---|---|---|
Characteristic | Currency | 0CURRENCY |
Characteristic | Company Code | /ERP/COMPCODE |
Characteristic | Category | /ERP/CATEGORY |
Object Type | Name | Technical Name |
---|---|---|
Variable | Fiscal Year | /ERP/P_0FISCYEAR01 |
Variable | Category | /ERP/P_CATEGORY |
Variable | Company Code | /ERP/P_COMPCODE01 |
Variable | Functional Area | /ERP/S_FUNCAREA01 |
Variable | GL Account Hierarchy | /ERP/H_GL_ACCT01 |
Variable | GL Account / GL Account Group | /ERP/N_GL_ACCT01 |
Variable | Currency | /ERP/P_0CURRENCY01 |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Functional Area | /ERP/FUNCAREA | |
Characteristic | G/L Account | /ERP/GL_ACCT |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Key Figure | Total Actual | &/ERP/T_FISCYEAR01& | |
Key Figure | Period 1 | ||
Key Figure | Period 2 | ||
Key Figure | Period 3 | ||
Key Figure | Period 4 | ||
Key Figure | Period 5 | ||
Key Figure | Period 6 | ||
Key Figure | Period 7 | ||
Key Figure | Period 8 | ||
Key Figure | Period 9 | ||
Key Figure | Period 10 | ||
Key Figure | Period 11 | ||
Key Figure | Period 12 | ||
Key Figure | Total Plan | &/ERP/T_FISCYEAR01& | |
Key Figure | Period 1 | ||
Key Figure | Period 2 | ||
Key Figure | Period 3 | ||
Key Figure | Period 4 | ||
Key Figure | Period 5 | ||
Key Figure | Period 6 | ||
Key Figure | Period 7 | ||
Key Figure | Period 8 | ||
Key Figure | Period 9 | ||
Key Figure | Period 10 | ||
Key Figure | Period 11 | ||
Key Figure | Period 12 | ||
Formula | Difference Actual Plan |