Show TOC

 Process (Range): Costs – Target/Actual – Situation

Technical name: 0ABC_C06_Q0004

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

Use

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

  • For the previous period: the target costs, actual costs, and variances

  • For all periods of the current year up to the current date: the cumulative target costs, actual costs and variances

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 – Target/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 a 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)

Target Costs &0T_FPER&

Restricted key figure: Target 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)

Target Costs &0T_FPERY& YTD

Restricted key figure: Target costs

Characteristic: Fiscal Year/Period (Variable &0FYTCFP&, SAP exit variable, cumulated up to current fiscal year period)

Variance

Actual costs &0T_FPER& % target costs &0T_FPER&

Variance YTD

Actual costs &0T_FPERY& YTD % target costs &0T_FPERY& YTD