Show TOC

 Process (Range): Plan Costs – Current Year/Previous Year

Technical name: 0ABC_C06_Q0012

Based on InfoCube: CO-OM-ABC: Costs and Allocations

Use

This query is a regular report for the process manager. It provides an overview of the planned and actual costs for the selected objects:

  • Planned costs, actual costs, and variances for the previous year

  • Planned costs and change in plan for the current year

You must enter the controlling area when you call up the query. You can limit the displayed data further using the following:

  • The process

  • The cost element

  • Or both of the above

If you want to limit the processes, first select a hierarchy. You can then further limit the data by specifying a range of processes or a single process.

If you want to limit the cost elements, first select a hierarchy. You can then further limit the data by specifying a cost element group or a single cost element.

Note Note

This query is contained in the workbook Process (Range): Analysis – Planning .

End of the note.

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

Filters

InfoObject

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

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, single value entry, required)

0CURTYPE

Currency type = 10 (company code currency)

User-Defined Characteristics

InfoObject

Description

0COSTELMNT

Cost element (variable &0N_COEL& (&0H_COEL&), cost element group (cost element hierarchy)

Rows

Row Name

Description (or Restrictions or Calculation Formula)

0ABCPROCESS

Business process number , variable &0N_ABC& (0H_ABC), business process area (business process hierarchy)

Columns

Column Name

Description (or Restrictions or Calculation Formula)

If an SAP exit variable is used, the time periods for which the quantities are calculated are determined automatically (see also Queries in Controlling under SAP Exit Time Variables ).

Actual &0T_FPERY&

Restricted key figure: Actual costs

Characteristic: Fiscal Year/Period (SAP-exit variable &0P_PRFP1&, all periods of the previous fiscal year)

Plan &0T_FPERY& (previous fiscal year)

Restricted key figure: Plan costs

Characteristic: Fiscal Year/Period (SAP exit variable &0I_PRFYE&, all periods of the previous fiscal year)

Plan &0T_FPERY& (current fiscal year)

Restricted key figure: Plan costs

Characteristic: Fiscal Year/Period (SAP- exit variable &0I_CUFYE&, all periods of the current fiscal year)

Actual Cost Variance

Actual costs &0T_FPERY& % planned costs &0T_FPERY&

Change in Plan

Plan costs &0T_FPERY& % plan costs &0T_FPERY&