1.0 Overview




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"

Target Users:

GBU and Site Controllers and Plant Management

VERSION

DATE

MODIFIED BY 

DESCRIPTION

0.01

dd.mm.2023

Inês Vilares

Initial draft










Data Product Type 
  • Dashboard
  • Report
  • Advanced analytics
  • AI 
  • Others <specify which one>
Technologies
  • BW
  • Tableau
  • Qliksense
  • Talend
  • Dataiku
  • Others <specify which one>

Data Sources 

Note: list of all applications and various environment

  • SAP PF1 (Production environment)
  • SAP WP1
  • SAP PI1
  • BW (versions)
  • iCare CRM 
  • CORE CRM
  • Budget flat files
  • Others <specify the name of the source> 

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.


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.


3.0 Application Feature Overview


For this application find below all the workbooks available:
ReportsDefinitionPromptsBW Workbook QueryQuery Technical Name
FC - Cost center master data (Sore Query)

Mandatory:

N.A

Optional:

  • CCtr Category;
  • Change date;
  • CO area;
  • Company Code;
  • Cost center;
  • Created by;
  • Creation date;
  • Author. scope of Comp. Code;
  • Source System.
BW_WBK_FC_0003BW_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 

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.


4.2 Process Detail 

4.2.1.  Report/Process Definition 

DomainFinance
ApplicationBW reports under FC - GBU Fixed Costs folder
ProviderMPR_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.

SAP BW High Level View

To see the data from the source systems see below how the information is organized in the BW perspective: 


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.