Start of Content Area

Query Production: Analysis – Target/Actual Material Consumption  Locate the document in its SAP Library structure

Technical name: OPC_C01_Q0005

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

Use

This query analyzes the planned and actual material consumption in production. You can see the values and quantities of the material components used, either at the level of the order or the finished product.

Note

This query is contained in the workbook Production: Analysis – Target/Actual Material Consumption.

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

Filters

InfoObject

Description

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)

0PIOBJSV

Partner (fixed value 0MAT material)

0MATERIAL__0PROD_HIER

Product hierarchy (variable &0I_PRODH&)

0CURTYPE

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

0PLANT

Plant (variable &0S_PLANT&)

User-Defined Characteristics

InfoObject

Description

0MATERIAL

Material number of product

0PRODORDER

Order number

0COSTELMNT

Cost element

Rows

Row Name

Description

0PLANT_COMP

Supplying plant (withdrawal plant)

0COMPONENT

BOM component

Columns

Column Name

Description

Target costs

For selected target cost version

Actual costs

Debits of the cost object

Variances

Actual costs – Target costs

Target input quantity

For selected target cost version

Actual input quantity

Quantity of materials and activities

Variances (quantities)

Actual input quantity – Target input quantity

Report/Report Interface

It is not possible to branch from this query to receiver reports.