Basic Information

BW Server	WBP
Application	PS
Query Name	BW Project Cost Detail (Core Query)
Query Technical Name	BW_QRY_MPR_PS001_0003
Core/Specific Scope	Core Query - Only RCS (WP1) Perimeter
Provider Name	MPR_PS001
Usage type	Direct use via Analysis
Expected users	Project managers, controllers

Purpose of this query

This query is used to show the details of the Actual Costs (PEC, excluding downpayments) on the WBS elements. The advantage of this query versus the PEC & CASH is that it allows you to select any period and provides more details.

Variables screen

Variable Name	Authorization Object	Description
Fiscal Period	No	See key figures paragraph about meaning of fiscal period depending on the Key figure
Project Type	No	Default value "II - Investment" - Remove this value if you want to see all projects
Currency	No	If no choice, all values will be in local currency. Otherwise converted to selected currency (see Currency Exchange paragraph)
Plant	Yes	Will be automatically filled with the plants you have access to
Family	Yes	Will be automatically filled with the Project Family you have access to
GBU	Yes	Will be automatically filled with the Project Family you have access to. This is the CLIENT GBU of the project.

Filters

Object	Filter Value	Explanation
Sender/Receiver	S, #	Only consider Debit Postings
Key Figure Type	<> 1002	Exclude downpayments
Currency Type	10	Using Local currency only

Characteristics

See PS Characteristics page

Key Figures

The "Fiscal Period" will behave differently depending on the key figure :

For Budget, the period is the WBS Creation date.
For Commitments it will be the requested delivery date.
For Actual Cost it will be the posting period of the GR/CO document.
For Commited, it will reflect the sum of Commitments and Actual costs.

In this query "Actual Cost" is equal to the PEC, excluding downpayments.

See PS Key Figures page.

Currency Conversion

See main PS Page.