You can use this query to enter your planned costs in a fiscal year for one or more cost centers at period level. The query is based on aggregation level /ERP/SFIN_A01
, and is used in workbook Cost Center Planning on Periods (/ERP/SFIN_A01_WB01
).
Example
You are cost center manager and want to plan your costs for cost element “Telecommunications” for 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
Your cost center
Once you have confirmed the selection criteria, the system displays a table with columns for the cost centers (your cost center), 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 respective plan columns are ready for input You can enter there your planned costs in the row for G/L account Telecommunications
.
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Company Code | /ERP/COMPCODE | |
Characteristic | Client | 0MANDT | |
Characteristic | Currency | 0CURRENCY | |
Characteristic | G/L Account | /ERP/GL_ACCT | |
Characteristic | Cost Center | /ERP/COSTCNTR | |
Characteristic | Controlling Area | /ERP/CO_AREA | |
Characteristic | Fiscal Year Variant | 0FISCVARNT | |
Characteristic | Posting Period | 0FISCPER3 | |
Characteristic | Chart of Accounts | /ERP/CHRTACCT |
Object Type | Name | Technical Name |
---|---|---|
Characteristic | Posting Period | 0FISCPER3 |
Characteristic | Currency | 0CURRENCY |
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 | Cost Center | /ERP/S_COSTCNTR01 |
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 | Cost Center | /ERP/COSTCNTR | |
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& | |
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 Plan Actual |