Cost Estimate: Overview, All Cost Estimates for a Material
Technical name: 0COPC_C08_Q0001
Based on InfoCube
CO-PC: Product Cost Planning – All Cost Estimates (0COPC_C08)Use
This query displays all existing cost estimates for a material in a plant. The cost estimates are displayed sorted by costing variant. The total costs and the fixed and variable costs are displayed for each cost component group. You can restrict the number of cost estimates displayed by specifying a time frame.
In addition, you can drill down in the cost component groups to the cost components and display the overall costs of the lower levels and the overall costs of the last production level.
You can use this query to perform all analyses if you display the necessary information in each case. You can perform simple individual analyses for a single cost estimate with the following queries:
Cost Estimate: Detailed Report, Cost Component Split (0COPC_C08_Q0002) Cost Estimate: Detailed Report, Fixed and Variable Costs (0COPC_C08_Q0003) Cost Estimate: Detailed Report, Level/Lower Level Costs (0COPC_C08_Q0004)
This query is contained in the workbook
For background information on the concept of queries, see
Queries in Controlling.
Filters
This query restricts characteristics for which each value could have a cost estimate or cost component split for each material, costing date, and costing variant. Without these restrictions, the cost estimates or cost component splits would be added together and displayed as a single cost estimate. For example, costing versions 1 and 2 would be added.
Some characteristics were restricted to just one typical value. For the others, you must choose the value when you start the query. If you want to restrict characteristics to values other than the preselected values, copy this query and modify the copy accordingly. This can be particularly useful when you want to define a query that contains one of the following pieces of information:
InfoObject |
Description (Restriction) |
0COSTVERS |
Costing version (fixed value 1) |
0WITHQTYSTR |
With quantity structure (fixed value Yes) |
0CCOMPTYPE |
Type of cost component split (fixed value main cost component split) |
0CCOMPVIEW |
Cost component view (variable 0P_CVIEW; single value entry, required) |
0CURTYPE |
Currency type (fixed value 10, currency of company code) |
0VALUATION |
Valuation view (fixed value legal valuation) |
0PLANT |
Plant (variable 0P_PLANT; single value entry, required) |
0MATERIAL |
Material number (variable 0P_MAT; single value entry, required) |
User-Defined Characteristics
InfoObject |
Description |
0CLEVEL_IND |
Indicator level/lower level |
0COSTCOMP |
Cost component |
Rows
InfoObject |
Description (Restriction) |
0COSTVAR |
Costing variant |
0COSTDATE |
Costing date (variable 0I_CSTDT; interval entry, optional) |
Columns
Technical Name |
Description |
0COSTCOMP_0CCOMPGRP_1 |
Cost component group 1 |
0COPC_C08_CK001 |
Amount =
Fixed amount +
Variable amount |
0AMOUNTFX |
Fixed amount |
0AMOUNTVR |
Variable amount |
0LOTSIZE_CM |
Lot size |
Report/Report Interface
Query |
Description |
0COPC_C08_Q0002 |
Cost Estimate: Detailed Report, Cost Component Split |
0COPC_C08_Q0003 |
Cost Estimate: Detailed Report, Fixed and Variable Costs |
0COPC_C08_Q0004 |
Cost Estimate: Detailed Report, Level/Lower Level Costs |