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

CBS is part of the Controlling application (Info Area AREA_F_CO in BW)
The first module of CBS for Functions costs is in the sub area AREA_F_FUNCT0 CBS - Fixed costs Analysis. The second module for Project costs in in the sub area AREA_F_CO_CBS_PS CBS - WBS Cost Analysis

Authorization objects

Link to the BW Catalog of role

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

Dataflow presentation

Overview

Overview for the Function costs module

Overview for the Project costs module

Reporting documentation drive folder:

https://drive.google.com/drive/folders/0BwtAGBKWM-z-OW9JdmhONHlIQ1k

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

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.

Ex: for company code:
6068 is referring to Rhodia UK in Rhodia’s ERP but in Solvay’s ERP it refers to Polyera Corp.

To avoid issues in the data, we decided to create new info objects with the system ID in the key 0LOGSYS.

Here is the list of all objects created

-Company code: C_COMPCDE previous object: 0COMP_CODE)
-Plant: C_PLANT (previous object: 0PLANT)
-Order number C_COORDER (previous object: 0COORDER)
-Order type C_CORDTYP (previous object: 0COORD_TYPE)
-WBS element C_WBS_EL2 (previous object: C_WBS_ELE)
-Project number C_PROJ_2 (previous object: C_PROJECT)
-Partner WBS element C_PARTWBS (previous object: 0PART_WBSEL)
-Partner order C_PARTORD (previous object: 0PART_COORD)
-Person responsible C_PSRESP (previous object: 0PS_RESPNO)
-Person responsible C_CCRESP2 (previous object: C_CCRESP)
-Version C_VERSN2 (previous object: 0VERSION)
-Vendor number C_VENDOR2 (previous object: 0CREDITOR)
-Customer number C_CUSTOMR (previous object: 0DEBITOR)
-Material number C_MATNR2 (previous object: C_MATNR)
-Material plant C_MATPNT2 (previous object: C_MATPLNT)
-WBS element scale C_IM_SIZE (previous object: 0IM_SIZE)
-WBS element investment reason C_INV_REA (previous object: 0INV_REASON)
-WBS element applicant C_PS_APPL (previous object: 0PS_APPLNO)
-WBS element project type C_PS_PRJT (previous object: 0PS_PRJTYPE)

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.

Technical rules

There are also details of routines (in start routine or in the rules) used.

Function cost reporting referential.xlsx

PS PEC reporting referential.xlsx

BW and ERP systems

• WBD (BW Development) is linked to WD1 (RCS development), DI1 (CICC development), DF1 (Solvay development), TST (Acetow Test) 
• WBQ (BW Quality) is linked to WQ1 (RCS quality), QI1 (CICC quality), QF1 (Solvay quality) and SPW (Acetow Sand Box)
• WBP (BW Production) is linked to WP1 (RCS Production), PI1 (CICC Production), PF1 (Solvay Production), RHO (Acetow Production) 

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 loadings

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

RPC_FC2 Fixed Costs 2 chain: 2h

RSV_COOM_CCA_OTHER CO_OM_CCA Delta Extraction for non RCS systems: 3h

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

Recurring procedure

No recurring procedure

Planned Evolution

Remove old data