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.

This query is contained in the workbook
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 |