Start of Content Area

Query Orders: Plan/Actual/Variance

Technical Name: 0OPA_C01_Q0001

If you want to modify this query, note the special features of the 0OPA_CO1 Costs and Allocations (Orders) InfoCube.

Use

This query provides an overview of the incurred costs and consumption quantities in an order group during the reporting timeframe. It enables you to make a plan or actual analysis of these costs taking cost elements, debits/credits and the corresponding allocation partners into account.

Note

This query is contained in the workbook Order Report.

 

Filters

InfoObject

Description

0CO_AREA

Controlling area (variable 0P_COAR)

0CURTYPE

Currency type (fixed value 20, controlling area currency)

0FISCVARNT

Fiscal year variant (SAP exit variable 0P_FVAEX)

 

User-Defined Characteristics

InfoObject

Description

0COORDER

Order (variable 0S_COOR)

0FISCPER

Fiscal year/period (variable 0I_FPER)

0PIOJSV

Partner (short name)

0PIOVALUE

Partner object

 

Rows

InfoObject

Description

0DB_CR_IND

Sender/receiver (Fixed values S, H, A, L)

0COSTELEMNT

Cost element

 

Columns

InfoObject

Description

Costs: Plan

Plan costs in the reporting timeframe (controlling area currency)

Costs: Actual

Actual costs in the reporting timeframe (controlling area currency)

Costs: Variance

Difference between plan and actual costs within the reporting timeframe

Costs: Variance (%)

Percentage variance from plan in the reporting timeframe

Quantities: Plan

Plan quantities in the reporting timeframe

Quantities: Actual

Actual quantities in the reporting timeframe

Quantities: Variance

Difference between plan and actual quantities in the reporting timeframe

Quantities: Variance (%)

Percentage variance from plan in the reporting timeframe