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:
- STOT-R330 – Administrative & Commercial expenses
- R25460 – Non proportional costs of sales
- R27900 – Mis production.
- R25510 – Logistics costs.
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
https://solvay-dwp.onbmc.com/dwp/app/#/itemprofile/622
In SAP system select the "WBP - BW Business Warehouse"
In WBP - BW Business Warehouse : Select the Business Role select the "FC - GBU Fixed Costs"
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | dd.mm.2023 | Inês Vilares | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
2.0 Business Process
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.
Model behind for PF1 and WP1:
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 element for COPA line items to be present in the P&L report for PF1 and WP1 and in here we have also the respective value field. Additionally for PF1 with this information for the responsible cost center and GBU associated in the final cost center this will allow to the users to perform 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.
3.0 Application Feature Overview
For this application find below all the workbooks available:
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| FC - Cost center master data (Core 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 |
4.0 Functional Specification
4.1 General Data/Calculations
| GBU | |
|---|---|
| Cost Center | Responsible Cost center is : - the cost center linked to the Order and WBS of the line item (CO-OM, PS) - the cost center of the line item for CO-CCA |
| Responsible Cost Center | |
| Cost element | It's a categorization used to track and classify expenses incurred by an organization. It represents a specific type of cost, such as wages, materials, rent, or utilities, and serves as a fundamental building block for cost accounting and reporting. Cost elements are essential for allocating and analyzing costs within the SAP CO module. It's the P&L account used to post the amounts in SAP CO document. |
| Plant | |
| Cost Center Hierarchy |
4.2 Process Detail
4.2.1. Report/Process Definition
| Domain | Finance |
|---|---|
| Application | BW reports under FC - GBU Fixed Costs folder |
| Provider | MPR_FC003 |
SAP BW High Level View
To see the data from the source systems see below how the information is organized in the BW perspective:
Hierarchy
All cost centers for this scope are stored in a unique hierarchy ZCBS.
- The cost centers for the fixed costs are identified by an unique sub-folder in ZCBS hierarchy : ENTRP (some others filters are done). See more details for the structure for cost centers hierarchy ZCBS.
- The cost elements for the fixed costs are identified by specific folder (ZRCS-FC) and sub folder. See more details for the the structure of cost elements group ZRCS-FC.
Restrictions
To determine GBU Fixed Costs perimeters, there is restrictions on:
- Cost center
- Cost element
- Miscellaneous filters
Restriction on cost center
For GBU Fixed Cost we only analyse ENTRP (1 Organisation attribute = ENTRP of the Responsible Cost center )
By default we must excluded some “2 Function” attributes values in the reports. The users can delete these default filters.
Cost center hierarchy ZCBS : restrictions
Restriction on cost element:
In the cost element BW object the cost element hierarchy was denormalized (levels of the hierarchy are translated as attributes of cost element).
By default we must excluded some “Fixed cost group “ attributes values in the reports. The users can delete these default filters.
Cost element hierarchy ZRCS-FC : restrictions:
Miscellaneous filters:
Order Type : we exluded (investment) :
- ZPM4
- ZPM6
Project Type we exluded (investment) :
- II
- FD
Value type
- 10- Real
- 20-plan
Currency type
- 10 company code currency
Special Case: mixed cost center
Because some cost centers are not 100% fixed (or variable), we identify them by an attribute mixed cost center = X
For this cost center we must check if the cost element is variable or not using XCS-ALL hierarchy (to exclude them)
We need a characteristic to identificate these cost element (with an X as attribute )
How to identificate “Mixed Cost center “?
All cost center ENTRP with level 4 node finishing by Y in ZCBS Hierarchy
How to identificate “variable cost” element?
use XCS-ALL hierarchy
The variable cost elements are all cost element attached to a node starting with "XCS-V" ou "XCS-S" (or attached to sub node under XCS-VCAL et XCS- SELL).
Plant vs Responsible Plant
- Plant is the physical plant
- Responsible plant is financially responsible of the cost center
- Responsible plant is an authorization object
- In SAP (WP1/PF1) responsible plant is in the field department of the profit center of the cost center
Workbook Details
See below more details for each workbook available for analysis:
- FC - Cost center master data (Core Query)
- FC - End month - P&L reconciliation COPA (Core Query)
- FC - End month - P&L select - Monthly P&L Impact (Core Query)
- FC - End month - P&L select - P&L Impact (Core Query)
FC - Cost center master data (Core Query)
FC - End month - P&L reconciliation COPA (Core Query)
FC - End month - P&L select - Monthly P&L Impact (Core Query)
FC - End month - P&L select - P&L Impact (Core Query)
5.0 Non-functional Descriptions
5.1 Usability
5.2 Regulatory Compliance
5.3 Security
5.4 Performance
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.