You can use this query to enter your planned costs in a fiscal year for one or more market segments (material group/customer group). The query is based on aggregation level /ERP/SFIN_A50
, and is used in workbook Market Segment Planning on Years (/ERP/SFIN_A50_WB01
).
Example
You are a product manager and want to plan the packaging costs incurred in the coming fiscal year for your material group. 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 material group
Once you have confirmed the selection criteria, the system displays a table with columns for the material groups (your material group), the customer groups, 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. The fields in the plan column are ready for input You can enter there your planned costs in the rows for the corresponding G/L account.
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Client | 0MANDT | |
Characteristic | Fiscal Year | 0FISCYEAR | |
Characteristic | Currency | 0CURRENCY | |
Characteristic | Customer Group | /ERP/CUST_GRP | |
Characteristic | Material Group | /ERP/MATL_GRP | |
Characteristic | Controlling Area | /ERP/CO_AREA | |
Characteristic | Company Code | /ERP/COMPCODE | |
Characteristic | Chart of Accounts | /ERP/CHRTACCT | |
Characteristic | G/L Account | /ERP/GL_ACCT | |
Characteristic | Fiscal Year Variant | 0FISCVARNT |
Object Type | Name | Technical Name |
---|---|---|
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 | Material or Product Group | /ERP/M_MATL_GRP01 |
Variable | Customer Group | /ERP/M_CUST_GRP01 |
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 | Material Group | /ERP/MATL_GRP | |
Characteristic | Customer Group | /ERP/CUST_GRP | |
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 | Plan Actual Difference |