Process (Range): Costs - Plan/Actual - Situation

Use

This query is a regular report for the process manager. It provides an overview of the planned and actual costs of the current year for all selected objects. Reporting time frames are the previous period, the periods in the current year up to the current date (values are cumulated), and all periods of the current year (actual cost projection).

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): Costs – Plan/Actual – Situation .

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, mandatory)
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 costs &0T_FPER&	Restricted key figure: Actual costs Characteristic: Fiscal Year/Period (Exit variable &0P_PRFP1&, SAP exit variable, previous period of the current fiscal year)
Planned costs &0T_FPER&	Restricted key figure: Plan costs Characteristic: Fiscal Year/Period (Exit variable &0P_PRFP1&, SAP exit variable, previous period of the current fiscal year)
Actual Costs &0T_FPERY& YTD	Restricted key figure: Actual costs Characteristic: Fiscal Year/Period (Variable &0FYTCFP&, SAP exit variable, cumulated up to current fiscal year period)
Planned costs &0T_FPERY& YTD	Restricted key figure: Plan costs Characteristic: Fiscal Year/Period (Variable &0FYTCFP&, SAP exit variable, cumulated up to current fiscal year period)
Planned costs &0T_FPERY&	Restricted key figure: Plan costs Characteristic: Fiscal Year/Period (variable &0I_CUFYE&, SAP exit variable, all periods of the current fiscal year)
Variance	Actual costs &0T_FPER& % planned costs &0T_FPER&
Variance YTD	Actual costs &0T_FPERY& YTD % planned costs &0T_FPERY& YTD
Actual projection	Actual costs &0T_FPERY& YTD x 12 / current period of the fiscal year (formula variable)
Variance (projection)	Actual projection % planned costs &0T_FPERY&