(warning)     (warning)     (warning)     (warning)

The new wiki link for this data flow is here:

Technical Documentation - Corporate Business Services - Function costs report

Please update the doc there and no longer here.

(warning)    (warning)       (warning)       (warning)

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

Role CodeRole DescriptionExplanation
ZR_RCS_CA_M23 CBS - Functions costsRole menu
ZBI_RCS_CO_A11 CBS Function Costs Reporting Analysis - End User roleEnd user role for Function reporting
ZBI_RCS_CO_A21 CBS Project costs Reporting Analysis - End User roleEnd user role for Project reporting

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/1EVXcn5jngf04IqPXGC2jx_O9ETV0ocss

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.

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) :

 

Costs have been created on this WBS element. The WBS element is linked to STELLAR project and has IT-BW as resp cost center.
Those data will be loaded in BW via 0CO_OM_WBS_6 data source up to CUB_FC006.

Data will be available in the queries using Responsible cost center (query during the month).

At the end of the month, an accountant will transfert all the costs of the WBS elements to the cost center STELLAR. This record will be loaded via 0CO_OM_CCA_9 also up to CUB_FC006.

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 user responsible field is not filled in WP1 Cost center MD and although it is filled in PF1, the field is not updated when they are changes in SRM7. So, the user responsible is determined in BW, and corresponds to the BIP login of the position of the person responsible (attribute c_biposit of c_posit).

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

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

Function cost reporting referential.xlsx

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. 

For WP1, we decided to modify only user exit Z_FORM_0CO_OM_CCA_9 to overwrite the sign from table COEP by following criteria 

   SELECT  SINGLE low
     INTO v_comp
     FROM tvarvc
     WHERE name =  'ZWBW_CO_CCA_9_COMP'
       AND low  = l_s_ICCTRCSTA1-bukrs.

     IF v_comp IS  NOT  INITIAL .
      SELECT  SINGLE BEKNZ
        INTO l_s_ICCTRCSTA1-seknz
        FROM COEP
        WHERE kokrs = l_s_ICCTRCSTA1-kokrs
          AND belnr = l_s_ICCTRCSTA1-belnr
          AND buzei = l_s_ICCTRCSTA1-buzei
          AND objnr LIKE  'KS%'
          AND vrgng =  'KAMV'
          AND parob LIKE  'KS%' .
     ENDIF .

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

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

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/file/d/1HFdG_iDp5w5gHIIfIhSogZefP7KRKxu4/view

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

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 C_RESP_CC__CPFCTR1_2.

We have also 3 new queries