Web: My Orders – Plan/Actual – Quarterly 
Web: My Orders – Plan/Actual – Quarterly
Technical name: 0COOM_C02_Q1017
Based on InfoCube
CO-OM: Costs and Allocations (Delta Extraction)Use
This query compares the planned and actual costs for each order and responsible cost center for the last four quarters. The variances are displayed by quarter.
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:
&CMD=LDOC&WBID=CFU9OYO7GY3C4VWT9MCQLWI15&PAGEID=Q4
In the Web Cockpit, it functions together with the following queries:
My Orders – Plan/Actual – Current and YTD
My Orders – Plan/Actual – Current and YTD Details
My Orders – Plan/Actual – Quarterly – Details
This query is included in the workbook
My Orders – Plan/Actual – Quarterly.For background information on the concept of queries, see Queries in Controlling.
Filters
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0IOBJSV |
Account assignment object type |
|
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 |
|
0COSTCENTER |
Cost center (variable &0S_CCTRP&, my cost center, selection options, personalization) |
Rows
|
Row Name |
Description |
|
0COORDER |
Order |
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). |
|
|
Structure Quarters |
|
|
Current period (variable &0T_FPERF& - &0T_FPERT&, from ... to month) |
Variable &0T_FPERF& - &0T_FPERT&, from ... to month Characteristic: Fiscal Year/Period (SAP exit variable &0I_CUFQU&, current quarter of fiscal year) |
|
Last period &0T_FPERF& - &0T_FPERT& |
Variable &0T_FPERF& - &0T_FPERT&, from ... to month Characteristic: Fiscal Year/Period (SAP exit variable &0I_PRFQU&, previous quarter of fiscal year) |
|
Period before last &0T_FPERF& - &0T_FPERT& |
Variable &0T_FPERF& - &0T_FPERT&, from ... to month Characteristic: Fiscal Year/Period (SAP exit variable &0I_P2FQU&, current quarter of fiscal year – 2) |
|
Two periods before last &0T_FPERF& - &0T_FPERT& |
Variable &0T_FPERF& - &0T_FPERT&, from ... to month Characteristic: Fiscal Year/Period (SAP exit variable &0I_P3FQU&, current quarter of fiscal year – 3) |
|
Actual |
Actual costs |
|
Plan |
Planned costs |
|
Variance |
Actual costs % planned costs |