General presentation

Objective of the application

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

It mainly aims at providing detailed economic survey of projects: Budget, Commitments, Actual costs (PeC), Cash out (CAPEX) and Cash Future (PeC and CAPEX are wording used in BFC to follow-up Investment projects)

$TECHNO - BI TEAM > BW RTR - PS Project Costs (WBP) /!\ Obsolete /!\ > image2016-6-28 14:33:11.png$

The reporting coordinator is Sandrine Micollet.

Usage information

This application has more than 1 000 users Worlwide.

Target users are Controlling teams, but also Project responsibles.

The Critical period is from D-5 to D+5.

History

This application was created in 2013 and it replaces the former RCS Project costs reporting (based on multiprovider MPR_PS004) that should not be used anymore.

Roles & Access

Roles and access

Role Code

Role Description

Explanation

ZR_RCS_CA_M09

PS - Project Costs

Role menu for all project costs queries

ZBI_RCS_PS_A02

Project Costs and Structures Analysis - End User role

Application Role:

End User rights
gives access to infoproviders of Infoarea "AREA_PSCO"
BI Analysis Authorization "ZBI_PS" ("*" for authorization objects not relevant for the application)

Authorization objects

Link to the BW Catalog of role

https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I

Dataflow overview

$TECHNO - BI TEAM > BW RTR - PS Project Costs (WBP) /!\ Obsolete /!\ > image2016-6-23 15:0:43.png$

https://drive.google.com/open?id=1rKhYbUaglLB11ESjep34L9ttFZhrid_jQFc-rDFgpxc

Reporting documentation drive folder:

https://drive.google.com/open?id=0B_p_Afe8sjVlUW1BWFR2ZElITlk

CASPEND (CO WBS) documentation:

https://wiki.solvay.com/x/yro_AQ

WBSE - PM orders costs documentation:

PS Characteristics documentation:

Cash Out documentation:

https://wiki.solvay.com/x/1Lo_AQ

Dependencies with other applications

COLMAR uses an APD based on a MPR_PS014 query.

Reporting

Queries End User Documentation

Query end user documentation should be created in the public "Customer Support Wiki" space under the corresponding BW application page : BW - Application. Technical query query documentation, if necessary should be added as a sub-page of this documentation using the BW Technical Query Documentation template.

Customer Support Wiki (To update):

https://wiki.solvay.com/x/NQI8

RtR presentation:

https://drive.google.com/open?id=1xLR2eV7ZtyYsbGeYOSVL0TCgdp-mcQzdYvbLtZWaL4c

Main queries

BW_QRY_MPR_PS014_0001 - Project costs & Cash out (Core query)

Main functionalities

Complex formulas: most of the key figures definitions contains formula variables in order to calculate the "conso" view and use the "enlarge to PM" option.

Currency conversion: key figures are available in local currency but can be converted according to a target currency entered in a query prompt.

Broadcast

Maintenance

Known bugs

Give the list and explanation on the known, not-solved, bugs.

Recurring procedure

Some recurring procedure concerning

Planned Evolution

Some evolutions are in progress, in the context of CAPEX project:

FI AP Solvay split extended to all documents (currently, it is restricted to "RMRP" reference procedure).
FI AP Solvay Net Of Tax amounts calculation

Useful transactions / programs

Transaction	Description	Corresponding table
FB03	Display Accounting Document	BSEG - Accounting Document Segment BSIK - Accounting: Secondary Index for Vendors BSAK - Accounting: Secondary Index for Vendors (Cleared Items)
CJI3	Project Actual Cost Line Items	COEP - CO Object: Line Items (by Period)
CJI5	Project Commitments Line Items	COOI - Commitments Management: Line Items
CJ20N	Project Builder	PRPS - WBS (Work Breakdown Structure) Element Master Data