Start of Content Area

Query Process (Detail): Costs – Plan/Actual – Situation  Locate the document in its SAP Library structure

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:

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

Note

This query is contained in the workbook Process (Detail): Costs – Plan/Actual – Situation.

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&