Web: My Orders – Plan/Actual – Current and YTD Detail (SAP Library

Web: My Orders – Plan/Actual – Current and YTD Detail

Technical name: 0COOM_C02_Q1003

Based on InfoCube CO-OM: Costs and Allocations (Delta Extraction)

Use

This query displays the following information for orders, sorted by cost element:

Actual and planned costs of previous period, and the variance
Actual and planned costs of the current year (cumulated up to the previous period), and the variance

You can personalize the controlling area and cost center(s) so that they are selected automatically. Without personalization, you must enter this information when you start the query.

See also: WEB: Personalization.

This query is intended chiefly for use in the Web Cockpit My Orders – Current Situation, although it can also be accessed individually.

IDs for integration with the Web Cockpit:

<BW_URL>&CMD=LDOC&WBID=CFU9OYO7GY3C4VWT9MCQLWI15&PAGEID=actual

IDs for individual access to the query in the Web:

<BW_URL>&CMD=LDOC&WBID=CFU9OYO7GY3C4VWT9MCQLWI15&PAGEID=YTD

In the Web Cockpit, it functions together with the following queries:

My Orders – Plan/Actual – Current and YTD

My Orders – Plan/Actual – Quarterly

My Orders – Plan/Actual – Quarterly – Details

Note

This query is included in the workbook My Orders – Plan/Actual – Current and YTD Detail.

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

Filters

InfoObject	Description of the InfoObject (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_COARP&, my controlling area, single value entry, personalization)
0CURTYPE	Currency type = 10 (company code currency)

User-Defined Characteristics

InfoObject	Description
0COORDER	Order (variable &0S_COOR&, selection options, optional)

Rows

Row Name	Description (or Restrictions or Calculation Formula)
0COSTELMNT	Cost element

Columns

Column Name	Description
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 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 current fiscal year)
Variances &0T_FPER&	Actual costs &0T_FPER& % planned costs &0T_FPER&
Actual Costs &0T_FPERY& YTD	Restricted key figure: Actual costs Characteristic: Fiscal Year/Period (variable &0FYTLFP&, SAP exit variable, cumulated up to last fiscal year period)
Planned Costs &0T_FPERY& YTD	Restricted key figure: Plan costs Characteristic: Fiscal Year/Period (variable &0FYTLFP&, SAP exit variable, cumulated up to last fiscal year period)
Planned Costs &0T_FYEAR&	Restricted key figure: Plan costs Characteristic: Fiscal Year/Period (variable &0FYEAR&, SAP exit variable, current fiscal year)
Variances &0T_ FYEAR& YTD	Actual costs &0T_FPERY YTD& % planned costs &0T_FPERY YTD&