Entering content frame

Query Web: My Projects – Plan/Actual Q4 Locate the document in its SAP Library structure

Technical name: 0COOM_C02_Q1007

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

Use

This query displays the actual costs, planned costs, and variances for the current quarter and the three previous quarters for all projects of the cost centers.

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: Structure linkWEB: Personalization.

This query is intended chiefly for use in the Web Cockpit Structure linkMy Projects – Plan/Actual, although it can also be accessed individually.

ID for integration with the Web Cockpit:

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

IDs for individual access to the query in the Web:

<BW_URL>&CMD=LDOC&WBID=ETHRL3MA9BKSKN6LV2CMBCMKP&PAGEID=Q4

<BW_URL>&CMD=LDOC&WBID=ETHRL3MA9BKSKN6LV2CMBCMKP&PAGEID=totperiod

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

My Projects – Plan/Actual Graphic – Periods

My Projects – Plan/Actual Q4 – Detail Cost Elements

My Projects – Plan/Actual Q4 – Detail WBS

My Projects – Plan/Actual Current YTD

My Projects – Plan/Actual – Current and YTD – Detail Cost Element

My Projects – Plan/Actual – Current and YTD – Detail WBS

Note

This query is included in the workbook My Projects – Plan/Actual Q4.

Filters

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0IOBJSV

InfoObject (4-place) / acccount assignment object type (variable &0POS&, WBS element)

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

0PROJECT

Structure linkProject definition (order)

Columns

Column Name

Description

Structure Quarters

Variable &0T_FPERF& - &0T_FPERT&

Characteristic: Fiscal Year/Period (SAP exit variable &0I_CUFYE&, current quarter of fiscal year)

Variable &0T_FPERF& - &0T_FPERT&

Characteristic Fiscal Year/Period (SAP exit variable &0I_PRFQU&, previous quarter of fiscal year)

Variable &0T_FPERF& - &0T_FPERT&

Characteristic: Fiscal Year/Period (SAP exit variable &0I_P2FQU&, current quarter of fiscal year - 2)

Variable &0T_FPERF& - &0T_FPERT&

Characteristic Fiscal Year/Period (SAP exit variable &0I_P3FQU&, current quarter of fiscal year – 3)

Actual Costs

Restricted key figure: Actual costs (see Restricted Key Figures in CO-OM: Costs and Allocations (Delta Extraction))

Planned Costs

Restricted key figure: Planned costs (see Restricted Key Figures in CO-OM: Costs and Allocations (Delta Extraction))

Variance

Actual costs % planned costs

 

 

 

 

 

Leaving content frame