General presentation

Objective of the application

CBS stands for 'Corporate Business Services'

CBS is a dedicated Reporting tool built on SAP BW module. It allow to analyse Functions fixed costs on cost centers and on project.

Usage information

Around 200 users have access to CBS applications. Those users are worldwide and most of them are function controllers.

History

Project done in 2012. It was the first project in BW mixing data from WP1 and PF1/PI1 systems.

Roles & Access

Roles and access

Access Management

...

Authorization objects

...

...

DataFlow

Overview

MPR_FC001:

MPR_FC002:

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

List of cubes MPR_FC001:

List of provider MPR_FC002:

Objective of the application

CBS stands for 'Corporate Business Services'

CBS is a dedicated Reporting tool built on SAP BW module. It allow to analyse Functions fixed costs on cost centers and on project.

History

Project done in 2012. It was the first project in BW mixing data from WP1 and PF1/PI1 systems.

Technical Rules on Workbench

Master data management

In the beginning of the project, we discovered that some objects may have same values but can be totally different in the ERP systems.

...

We have created a new catalog IOCC_MD_ID in the info objects where we will store the info objects with the System ID in key

Functional and Technical rules

Cost center hierarchies

Click on the Cost Center Hiearchies  page.

Cost element hierarchies

Click on the Cost Element Hiearchies page.

Family of the WBS element

Click on the Family assignment page.

Usage of Responsible cost centers and Cost centers

During the month, costs of WBS elements and CO orders are managed at the WBS or Order level.
Example below (theorical) :

...

At 31.07.2016, query end of the month will display the 300€ costs on cost center STELLAR and query during the month will display it on resp cc IT-BW

Position of the person responsible and user responsible of the cost centers

The position of the person responsible (c_posit) corresponds to a position in the SRM7 organisational structure. It is coming from the person responsible field (verak) of the cost center MD in WP1/PF1 which not always contains a position (some companies doesn't use SRM7 for purchasing), so we check the existence of the position in c_posit MD before to update it in the BW cost center MD (C_COSTCTR).

...

The BIP login of the position in c_posit MD is updated from SRM7, using the Function Module ZWPU_GET_POSITIONS_CC in order to share the same rule with ECC reports (ZWFA119 for WP1 and ZZR_WPUR043 for PF1). FM  ZWPU_GET_POSITIONS_CC checks the validity of the user in SRM7, in consequence, even when the organisational structure shows a user for a position, the user could be undetermined in the FM if not valid. If the FM finds multiple users for a position, which is not normal, the attribute BIP login of the position in BW is set to "ERROR_MULTI".

Technical

...

rules

...

PS PEC reporting referential.xlsx

Since the service pack update cause the H/S flag of data source 0CO_OM_CCA_9 change the concept of +/- sign (Note 65075), which cause the sign in WP1 was opposite. For PF1, we didn't apply the service pack yet (as of Nov 2021) because we afraid that it will impact to many program. 

...

We can specific the company code by table TVARVC and maintain the list via tcode TVARVC in WP1. :

Image Added

BW and ERP systems

• WBD (BW Development) is linked to WD1 (RCS development), DI1 (CICC development), DF1 (Solvay development), TS2 (Acetow Test) 
• WBQ (BW Quality) is linked to WQ1 (RCS quality), QI1 (CICC quality), QF1 (Solvay quality) and TS2 (Acetow Test)
• WBP (BW Production) is linked to WP1 (RCS Production), PI1 (CICC Production), PF1 (Solvay Production), RHO (Acetow Production) 
• PIM system is not used anymore

Reporting

Queries End User Documentation

Link to user guide

https://drive.google.com/file/d/1h4RMrmL5MR0plRCW0aqKelxvNKrVw-7J/view

Main queries

Image Added

Dependencies with other applications

CBS applications is dependant with

• FC2 Fixed Costs (obsolete) now replaced by FC GBU Fixed costs
• PS / CAPEX Project costs (common DSO)
• CO Profitability (comme DSO ODS_OPA06)

Data

...

loading

Info providers and objects loaded

...

In the Excel files attached Function cost reporting referential.xls and PS PEC reporting referential.xls you will find a list of all objects included in:

• Data Sources used for master datas, texts, DSO
• DSO
• Cube
• Multi providers

Loading frequency

CBS is loaded every working day starting at 0:00 am (Paris time) and finishing around * :00 am (Paris time)*

Average performance

RSP_COOM CO_OM_OPA / WBS - delta extraction for RCS data: 2h

...

MPR_FC001

...

MPR_FC002:

Record Keeping

We have data since beginning of 2012 and we never made clean-up.

Main functionnalities

Jump query available

Data Quality Control

Data come from SAP system. To compare data between BW and sources systems, check propagation layers.

Operational Documentation

Procedures

<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>

Scheduling

<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>

Monitoring

<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>

Error Handling

<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>

Known Bugs

<List the existing bugs, its criticity, workarounds and resolution plan.>

Roadmap

<List past & future evolutions for the application (including links to MED/FSD/TSD)>

Record Keeping

We have data since beginning of 2012 and we never made clean-up.

Reporting

Queries End User Documentation

Link to user guide

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

Main queries

BW_QRY_MPR_FC001_0001 CBS - Functions - end of month (Core query)

BW_QRY_MPR_FC001_0002 CBS - Functions by Companies - end of month (Core query)

BW_QRY_MPR_FC001_0003 CBS - Functions - during month (Core query)

BW_QRY_MPR_FC001_0004 CBS - Functionsby Companies - during month (Core query)

BW_QRY_MPR_FC001_0005 CBS - Synthesis of the Functions (Core query)

Main functionnalities

Jump query available

Broadcast

No broadcast

Maintenance

Known bugs

No known bug

Example of tickets

• 3729: 0PROFIT_CTR not updated
• 22045: Ask new report

Recurring procedure

No recurring procedure

Planned Evolution

• Remove old data: Only keep the 5 last years in the cubes in order to make the cube lighter and gain space in BWA.
• Fixed Cost project: A project is in progress to have fixed costs reporting by plant and GBU. This project will be finished end of july.

This project is a mix between CBS and COPA in order to provide fixed cost reporting by plant and GBU. The objective is also to replace actual fixed cost application for Rhodia legacy FC2.

For this project, we have created specific info areas

Image Removed

We have created MPR_FC003 for this purpose. This multi provider has same cubes as CBS application and one cube from COPA application.

For this multi provider we have 2 authorization object: C_RESP_CC__C_RPLANT Responsible Plant and C_RESP_CC__CPFCTR1_2.

We have also 3 new queries