The new wiki link for this data flow is here:
Please update the doc there and no longer here.
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.
Around 200 users have access to CBS applications. Those users are worldwide and most of them are function controllers.
Project done in 2012. It was the first project in BW mixing data from WP1 and PF1/PI1 systems.
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 Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_M23 | CBS - Functions costs | Role menu |
| ZBI_RCS_CO_A11 | CBS Function Costs Reporting Analysis - End User role | End user role for Function reporting |
| ZBI_RCS_CO_A21 | CBS Project costs Reporting Analysis - End User role | End user role for Project reporting |
Link to the BW Catalog of role
https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I
Overview for the Function costs module
Overview for the Project costs module
Reporting documentation drive folder:
https://drive.google.com/drive/folders/1EVXcn5jngf04IqPXGC2jx_O9ETV0ocss
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
Click on the Cost Center Hiearchies page.
Click on the Cost Element Hiearchies page.
Click on the Family assignment page.
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
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".
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.
CBS applications is dependant with
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:
CBS is loaded every working day starting at 0:00 am (Paris time) and finishing around * :00 am (Paris time)*
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
We have data since beginning of 2012 and we never made clean-up.
Link to user guide
https://drive.google.com/file/d/1HFdG_iDp5w5gHIIfIhSogZefP7KRKxu4/view
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)
Jump query available
No broadcast
No known bug
Example of tickets
No recurring procedure
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