Standard Cost Estimate: Time Series for Material, Price per Unit
Technical name: 0COPC_C09_Q0004
Based on InfoCube
CO-PC: Product Cost Planning – Released Cost Estimates (0COPC_C09)Use
This query displays an overview of the released cost estimates for a material in a plant across multiple periods. In contrast to the queries
Standard Cost Estimate: Time Series for Material, Cost Component Split (0COPC_C09_Q0007) and Standard Cost Estimate: Time Series for Material, Price per Base Quantity (0COPC_C09_Q0009), this query converts the values of the cost estimate from the costing lot size to a base quantity. To display the cost component split, you must expand cost component group 1 and/or the cost components.
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 in the query. For example, the cost estimates for the valuation views legal valuation and group valuation 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) |
0CCOMPTYPE |
Type of cost component split (fixed value main cost component split) |
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
Technical Name |
Description |
0COSTCOMP_0CCOMPGRP_1 |
Cost component group 1 |
0COSTCOMP |
Cost component |
Columns
Technical Name |
Description (Restriction or Calculation Formula) |
0FISCPER |
Fiscal year/period (variable 0P_FPER; interval entry, required) |
|
Price per unit = (
Fixed amount +
Variable amount) /
Lot sizeThe value of the cost estimate (based on the costing lot size) is converted to a base unit of measure. |
Report/Report Interface
Query |
Description |
0COPC_C09_Q0002 |
Standard Cost Estimate: Detailed Report, Level/Lower Level Costs |
0COPC_C09_Q0003 |
Standard Cost Estimate: Detailed Report, Cost Component Split |
0COPC_C09_Q0006 |
Standard Cost Estimate: Detailed Report, Fixed/Variable Costs |