The new wiki link for this data flow is here:

Technical Documentation - Project Costs

Please update the doc there and no longer here.

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 ROLLIER, Charlotte.

Usage information

This application has more than 1 000 users Worldwide.

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 /!\ > image2017-5-31 9:51:17.png$

https://drive.google.com/file/d/1OotTC_XJvvntDIBcS4XyJbL2wrizz4U3iCVpUDCMQrE/view

Reporting documentation drive folder:

https://drive.google.com/drive/folders/1dFpjf9PQrI3NvOlPA-oXPff50PI_fI9v

CASPEND (CO WBS) documentation

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

WBSE - PM orders documentation

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

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

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

Planned Evolution

Former Working Capital and Project Costs flow should be decommissioned in a near future.

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