You can use this query to enter your planned costs in a fiscal year for one or more projects at period level. The query is based on aggregation level /ERP/SFIN_A21
, and is used in workbook Project Planning on Periods (/ERP/SFIN_A21_WB01
).
Example
You are a project lead and are planning the construction of a new factory building for your company. You want to plan the costs incurred for the materials for this in the coming fiscal year at period level. There is a project definition in the system for this project. To plan the costs, 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 project
Once you have confirmed the selection criteria, the system displays a table with columns for the projects (your project), the WBS elements, 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 for the coming fiscal year in the rows for the corresponding G/L account.
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Client | 0MANDT | |
Characteristic | Controlling Area | /ERP/CO_AREA | |
Characteristic | Company Code | /ERP/COMPCODE | |
Characteristic | Fiscal Year Variant | 0FISCVARNT | |
Characteristic | Posting Period | 0FISCPER3 | |
Characteristic | Project Definition | /ERP/PROJECT | |
Characteristic | WBS Element | /ERP/WBSELMT | |
Characteristic | Chart of Accounts | /ERP/CHRTACCT | |
Characteristic | G/L Account | /ERP/GL_ACCT | |
Characteristic | Currency | 0CURRENCY |
Object Type | Name | Technical Name |
---|---|---|
Characteristic | Currency | 0CURRENCY |
Characteristic | Posting Period | 0FISCPER3 |
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 | Project | /ERP/S_PROJECT01 |
Variable | WBS Element | /ERP/N_WBSELMT02 |
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 | Project Definition | /ERP/PROJECT | |
Characteristic | WBS Element | /ERP/WBSELMT | |
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 | Difference Plan/Actual |