Start of Content Area

Query Production: Analysis – Variances  Locate the document in its SAP Library structure

Technical name: 0PC_C01_Q0007

If you want to modify this query, note the special features of InfoCube 0PC_C01 Cost Object Controlling.

Use

This query displays the production variances on different aggregation levels. The target costs, actual costs, and actual credits of the orders are compared with each other and displayed along with the variances calculated in period-end closing. The variances are divided into two groups depending on whether they occurred on the input side or on the output side. For a detailed explanation of the variances, refer to the query Production: Analysis – Variance Categories.

Note

This query is contained in the workbook Production: Analysis – Variances.

For background information on the concept of queries, see Queries in Controlling.

Filters

InfoObject

Description of the Info Object (and restriction or calculation formula)

0FISCPER

Fiscal year/period (variable &0I_FPER&)

0FISCVARNT

Fiscal year variant (SAP exit variable &OP_FVAEX&: the system derives the fiscal year variant from the controlling area)

0CO_AREA

Controlling area (variable &OP_COAR&, controlling area)

0CURTYPE

Currency type (fixed value 70, currency of controlling area)

User-Defined Characteristics

InfoObject

Description

0PRODORDER

Order

0PLANT

Plant, (variable &0S_PLANT&)

0MATERIAL

Material number (variable &0P_MAT&)

Rows

Row Name

Description of the Info Object (and restriction or calculation formula)

0MATERIAL_0PROD_HIER

Product hierarchy

Columns

Column Name

Description of the Info Object (and restriction or calculation formula)

Target costs

Depends on selected target cost version

Actual costs

Actual costs

Actual credit from delivery

Actual credit from delivery

Total variances

Total variance as a percentage

Total variances

Total variances, absolute

Total input variances

Sum of all variances on the input side

Total output variances

Sum of all variances on the output side

 

Report/Report Interface

Query

Description

0PC_C01_Q0003

Production: Analysis – Variance Categories

0PC_01_Q0021

Production: Detail – Order – Variance Categories

You can branch to the report Production: Analysis – Variance Categories (0PC_C01_Q0003) from any query drilldown level. You can branch to the query Production: Detail – Order – Variance Categories (0PC_01_Q0021) from the drilldown level order.