The GBU Fixed Costs applciation is part of Finance domain and we use mainly the SAP data from CO (Controlling) module to get the dat for the fixed costs and GBU level. The application GBU Fixed Costs is used to follow Solvay’s fixed costs mainly:
|
For this Application the access is provided based on the BW menu "FC - GBU Fixed Costs" and it's done via Service one. Fill the form In SAP system select the "WBP - BW Business Warehouse" In WBP - BW Business Warehouse : Select the Business Role select the "FC - GBU Fixed Costs" |
Target Users: GBU and Site Controllers and Plant Management |
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | dd.mm.2023 | Inês Vilares | Initial draft |
|
For the GBU fixed costs we use the SAP information from the controlling part to analyze the fixed costs at GBU level.
For this it's important to understand the structure behind and how the business see the costs and be able to analyze the information to perform their activities during and end of month.
missing image
Curently we have the WBS, cost centers and orders objects with values coming from the purchase orders and accounting entries. Each object is linked to a cost center which we call it "Responsible Cost Center" and this cost center is linked to a GBU.
We have the primary postings and during the closing process we have the settlements cycles (which will allocate the costs to a final cost center) and the final cost centers has the correspondent cost elment for COPA line items to be present in the P&L report (in here we have also the respective value field). also with the this information for the responsible cost center and GBU associated this allow in PF1 the analysis in PCA (Profit Center Accounting).
Reporting fixed costs challenges : reconciliation SAP/BFC:

in the controlling side we have primary posting in the CO objects for the fixed costs and during the closing we have the settlement cycles to transfer/allocate the costs to a final CO object and to be in the respective lines in P&L.
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| FC - Cost center master data (Sore Query) | Mandatory: N.A Optional:
| BW_WBK_FC_0003 | BW_QRY_C_COSTCTR_0001 | |
| FC - End month - P&L reconciliation COPA (Core Query) | BW_WBK_FC_0001 | |||
| FC - End month - P&L select - Monthly P&L Impact (Core Query) | BW_WBK_FC_0007 | |||
| FC - End month - P&L select - P&L Impact (Core Query) | BW_WBK_FC_0006 |
This section will approach the concepts/definitions that will be used in all the reports and required to understand the data from the reports.
Could be specific fields, closing activities, additional information to work and understand the reports.
| Domain | Finance |
|---|---|
| Application | BW reports under FC - GBU Fixed Costs folder |
| Provider | MPR_FC003 |
The GBU Fixed Costs it's based in an existent model since many years ago exist a controlling model to be more accurate for the GBU needs. We take the model already developed and it was enhanced to follow the fixed costs specially in the cost center at GBU level. We have the PF1 and WP1 systems and we are using the main CO objects cost centers, WBS and orders and with this information extracted we the data is splitted in two BW tools one side the GBU fixed costs and the other solution is CBS for the functions (This scope is explained in the "Corporate Business Services application"). For both applications we use the same data base and the same cubes but the multiproviders are different also because of the authorization part. |
To see the data from the source systems see below how the information is organized in the BW perspective:

5.5 Reliability
5.6 Scalability
5.7 Compatibility
5.8 Availability
5.9 Refresh of the Data
The loads for the GBU Fixed Costs application is the following:
Closing Time:

Outside of Closing: it's one time on a daily basis.