This page provides all the technical and detailed documentation concerning the "FIWC for Solvay Group" (Finance Working Capital) application in BW, including :
This application replaces the former FIWC application which was created for Rhodia legacy (WP1).
Rhodia ERP WP1
Solvay ERP PF1 (020)
CICC ERP PI1
Acetow ERP RHO
PRS ERP PF1 (050)
BFC (flat files)
It is equal to the sum of:
It excludes:
In BFC:
Every month, persons in each company will get the values from RCS/BW for each account and enter it manually in BFC.
We can split the Working Capital in 3 main component (GL Type), which separates in sub-components (GL Sub types).
+G/L Accounts restitution:
Account types and sub types are managed in WP1 and PF1 systems (PF1 and PI1 share GL accounts so no need to load from PI1 system).
For Acetow system, it's managed manually
Working Capital for GBU queries are working in consolidation view, meaning we exclude Intercompany and other filters in restricted key figures also the intergration rate.
Working Capital for Accounting offers with a variable to working in accounting view, without any filters.
In the queries, we keep only the company with Intercompany flag as X.
For data coming from FIGL, FIAP and MM, the base of the business assignment is the Profit Center. From the profit center we then use the Industral Axis to define the business structure.
For data coming from FIAR, the base is the IECRA. From the IECRA we then use the Market Axis to define the business structure.
Example of the profit center hierarchy that is used to define the Industrial Axis.
We load some master data from PRS system (PF1_050).
With this some source system, we can be sure to have an unique code for companies, customers and vendors.
In RCS and Acetow, the link between ERP and PRS is managed in tables ZZR_T001_MAP (company), KNA1 (customer) and LFA1 (vendor).
For Solvay and CICC, the PRS code is the same than ERP code.
PRS master data are stored in dedicated info objects: C_COMPPRS, C_CUSTPRS and C_VENDPRS.
We also have dedicated info objects from the ERP with the ERP system and code and the PRS attributes: C_COMPCDE, C_CUSTID and C_VENDID.
At the beginning we used C_COMPPRS, C_CUSTPRS and C_VENDPRS in the info providers in order to use their attributes but due to poor data quality we had too oftenly the case of missing link in the ERP between ERP and PRS codes. That's why we decided to replicate PRS attributes in C_COMPCDE, C_CUSTID and C_VENDID info objects.
The BW working capital reports are all based on amounts in Local Currency Those amounts come directly from the source systems.
If user selects a currency in the prompt the query will convert, otherwise it will return the values in local currency.
This conversion is based on the ZRHO rate (coming from WP1).
The current available rate s applied to ALL data (even past data) independently of the date.
For base amount we use the Debit/Credit Amount 0DEB_CRE_LC or FIGL/FIAR/FIAP data and the Stock Value for IM data.
We then apply conversion type ZRH2 for Working Capital - CTK_ZRHWC :
For the BW Working Capital we use 4 sources of data:
Vocabulary:
FIGL: General Ledger
FIAP: Account Payable
FIAR: Account Receivable
Technical dataflow:
Those 2 multiproviders are identical. The only difference is the authorization objects. They should have some providers in source, same key figures and same navigational attributes
In MPR_WC02 the authorisation objectif is only the GBU. This is because the target population is usually zone-wide or world-wide on 1 single business. Idea is to allow them to run the report on their perimeter without having to enter all the companies (in some cases dozens).
Im MPR_WC01 the authorisation access is only by company. This is because the target population (Accounting/site controlling) is usually GBU-wide on a single company. Specially these users need to be able to see the data that is not assigned to any GBU.
+0COMP_CODE – Company code:
+0GL_ACCOUNT – GL Account:
+C_GLBFILT – Global filter: