Start of Content Area

Query Standard Cost Estimate: Time Series for Material, Price per Base Quantity  Locate the document in its SAP Library structure

Technical name: 0COPC_C09_Q0009

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 Unit (0COPC_C09_Q0004), this query converts the values of the cost estimates from the costing lot size to a base quantity. The base quantity must be entered when the query is started. To display the cost component split, you must expand cost component group 1 and/or the cost components.

Note

This query is contained in the workbook Standard Cost Estimate: Time Series for Material, Price per Base Quantity.

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 base quantity = Base quantity for price * ( Fixed amount + Variable amount) / Lot size

The value of the cost estimate (as based on the costing lot size) is converted to a base quantity that must be entered when the query is started.

Although the unit of the displayed costs may be indicated as dollars per piece, for example, the costs are based on the selected base quantity for the price (such as dollars per 10 pieces), and not on one unit.

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