General Presentation

The PS Application provides reports that shows the financial indicators at project level (WBS Element).

The Financial Indicators include :

• CASH Out (Capex and OTC
• Actual Costs (PEC - Capital Spend)
• Commitments
• Budget
• Planned costs
• Future costs

Access

Access to the "PS - Project Costs" Application has to be requested (See Getting an account).

Access is managed at 2 levels, which you will need to precise when requesting the access : 

• Global Business Unit (GBU) - Note that this is the CLIENT GBU (Not the one responsible for the project, but the one receiving the benefits of the projet).
• Family of the WBS

Perimeter

PS - Project Costs  is a set of BW queries on Rhodia legacy (WP1), Solvay legacy (PF1) and Acetow (RHO) area.

Data update

The data is updated daily around ~4 am Paris Time.

Queries

All the queries for the PS Application can be found in the role "PS - Project Costs" (ZR_RCS_CA_M09) :

• BW_QRY_MPR_PS014_0001 - Project costs & Cash out (Core query)

Here are the links to the detailed query documentations :

• BW - Cumulated PEC & CASH (Core Query)|

Currency conversion

All the PS queries use the same type of currency conversion : 

• Rate used : CAR3 (See Exchange rates page for details)
• Time : Fiscal Period

This means that each document will be converted with the rate available for the posting date of that document.

IE : Documents posted in January will be converted with the January rate, even if you run the report in february.

Depending on the key figure, the "Period" will be different :

• Budget : the date will be the start of the project (WBS Creation date)
• Commitments : Rate available at the theoretical reception date if the date is in the past, or current rate if date in the future.
• Plan : Rate available at the month of the plan data.
• PEC : Rate available at the reception date.
• Cash – Payments : Rate available at the invoice reception date.
• Cash – Down payment : Rate available at the down payment posting date.
• Cash – Non-Purchase requests (Stocks, Hours) : Rate available at the cost reception date

CASH OUT - About Invoices split by WBS element

In some cases, a Purchase Order (PO) can be assigned to several costing elements (Cost Centers, WBS elements, Orders). 

This happens in two ways :

• Different items in the PO are assigned to different costing elements (Ex : Item 1 on WBS A, Item 2 on Cost Center B)
• There is a settlement rule to share the cost of the item (Ex : 40% on WBS A, 60% on Cost center B).

In this case, the GR will be correctly split and the cost assigned to each element but as there will be only one invoice, SAP will not split the value of the invoice (Payable - FIAP) into each assigned element. 

The result is that by default, the full amount of the invoice will be assigned on the first element found by SAP and the CASH will not reflect the reality.

In order to avoid this, the BW system will split the invoice by WBS/CostCenter/Order in the BW reports.

Case 1 - 1 PO with multiple items assigned to several elements - But 1 single invoice

In this case BW will split proportional the amount of the invoice by element. In this example, the CASH will reflect only 115$ on WBS1 even though the full value of the invoice (1160$) is assigned on WBS1 in SAP.

Case 2 - 1 PO with 1 item, 1 settlement rule with 2 objects, 1 invoice

BW will split the amount of the invoice based on the settlement rule.

PS Frequenty Asked Questions

What does "PEC" stand for ?

"PEC" is the acronym for the french name "Prise En Charge", which translates into "Bearing of the costs". Meaning the Actual Costs of all goods/services received.

The "PEC" was used for Rhodia Legacy. It is replaced by the wording "Capital Spend".

What does "CAPEX" stand for?

CAPEX stands for Capital Expenditure. It is equal to the CASH (Out) when filtering on investments only.

What does "CASH" stand for ?

CASH is short for "Cash Out", meaning the amount that has been paid (or received for invoicing WBS). It includes both "CAPEX" (Investment Cash Out" and "OTC" (One Time Costs - Non-investment cash out).