Show TOC

 Process (Detail): Costs – Plan/Actual – Situation

Technical name: 0ABC_C06_Q0015

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

Use

This query is a regular report for the process manager. It displays the following information on all selected objects:

  • Planned costs, actual costs, and variance for the current period

  • The cumulative planned costs, actual costs and variance for all periods of the current year up to the current date

  • Projected actual costs, planned costs, and variance for the current year

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

  • Business process or range of business processes

  • Cost element hierarchy

  • Or both of the above

Note Note

This query is contained in the workbook Process (Detail): 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)

0ABCPROCESS

Business process number variable &0S_ABC&, business process (selection options, optional)

0CURTYPE

Currency type = 10 (company code currency)

Rows

Row Name

Description (or Restrictions or Calculation Formula)

0COSTELMNT

Cost element

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 (variable &0P_FPER&, current fiscal year/period)

Planned Costs &0T_FPER&

Restricted key figure: Plan costs

Characteristic: fiscal year/period (variable &0P_FPER&, current fiscal year/period)

Variance &0T_FPER&

Actual costs &0T_FPER& % planned costs &0T_FPER&

Actual Costs &0T_FPERY& YTD

Restricted key figure: Actual costs

Characteristic: fiscal year/period (SAP exit variable &0P_FYTCFP&, cumulated up to current fiscal year period)

Planned costs &0T_FPERY& YTD

Restricted key figure: Plan costs

Characteristic: fiscal year/period (SAP exit variable &0P_FYTCFP&, cumulated up to current fiscal year period)

Variance &0T_FPERY& YTD

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

Projection &OT_FPERY&

Actual costs &0T_FPERY& YTD x 12 / current period of the fiscal year (formula variable)

Planned Costs &0T_FPERY&

Restricted key figure: Plan costs

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

Variance &0T_FPERY&

Projection &0T_FPERY& % plan costs &0T_FPERY&