Entering content frame

Query Cost Estimate: Detailed Report, Fixed and Variable Costs Locate the document in its SAP Library structure

Technical name: 0COPC_C08_Q0003

Based on InfoCube CO-PC: Product Cost Planning All Cost Estimates (0COPC_C08)

Use

You can use this query to analyze the fixed and variable costs as a proportion of the total cost. You can also display the cost component split broken down into fixed and variable costs.

If you want to perform this analysis using only standard cost estimates, SAP recommends using the query Standard Cost Estimate: Detailed Report, Fixed/Variable Costs (0COPC_C09_Q0006).

Note

This query is contained in the workbook Cost Estimate: Detailed Reports for a Cost Estimate.

For background information on the concept of queries, see Structure link 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, 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

Structure link Currency type (fixed value 10, currency of company code)

0VALUATION

Structure link Valuation view (fixed value legal valuation)

0PLANT

Structure link Plant (variable 0P_PLANT; single value entry, required)

0MATERIAL

Structure link Material number (variable 0P_MAT; single value entry, required)

0COSTVAR

Costing variant (variable 0I_CSTVA; single value entry, required)

0COSTDATE

Costing date (variable 0I_CSTDT; single value entry, required)

User-Defined Characteristics

InfoObject

Description

0COSTCOMP_0CCOMPGRP_1

Cost component group 1

0COSTCOMP

Cost component

Columns

Column Name

Description

0COPC_C08_CK001

Amount = Structure link Fixed amount + Structure link Variable amount

0AMOUNTFX

Structure link Fixed amount

0AMOUNTVR

Structure link Variable amount

0LOTSIZE_CM

Lot size

 

 

Leaving content frame