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)
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 components, which separates in sub-components. Each is a list of G/L Accounts:
!Attachment Library^WCAppli_html_4a762ba3.gif|height="411" !
Where to find it:
!Attachment Library^WCAppli_html_m55f566b3.gif|height="358" !
+G/L Accounts restitution:
!Attachment Library^WCAppli_html_339e1905.gif|height="35" !
For definition of each field and list of values check the public definition of |GL Account >BW - Business Warehouse.GL Account Master Data]* master data.*
The management of G/L Accounts for Working Capital is done manually by the BW Team.
To filter out Intraco and Interco for Payables and Receivables we use the Status of the Trading Partner of the supplier/customer/partner.
In the report we display customers/vendors which corresponding trading partner has a status different from 1.
Note about deleted partners: If an integrated supplier/customer is deleted in RCS, they will remove the status. If the customer/supplier still has an open balance up until 11 months ago then it will be considered external and displayed as working capital. To prevent this, do not delete partners which have an open balance. |
In BW, we filter out all Intra and Inter company sales/purchases (Intraco, Interco)
Note: he master data team (MAGDA) is responsible for maintaining the partner and customer status value in RCS
To filter out the legal entities (Company) which are obsolete or not fully integrated, we will also use the Status of the Trading Partner but this time of the Company. 
In the report we only display data for legal entities for which the corresponding trading status is equal to 1.
Note about obsolete companies: the day a company is tagged as obsolete it will completely disappear of the reports! Even from the historical data
Note about companies partially integrated (Butachimie): BW updates manually a list with a coefficient for each company. Normal companies will have 100%. Partial companies can have a lower percent. In 2010, Butachimie has 50%.
In BW, we filter out all Obsolete / Non Integrated companies
There is 2 cases:
Ex: 3894 - ZZZZ exBluestar Silica Fra
Ex: 1892 - GIE Chimie Salindres
Note: he master data team (MAGDA) is responsible for maintaining the partner status value in RCS
To remove all investments from the account payables, we use the Cap Goods Indicator (Or Invest.ID in RCS)
This indicator, found on the invoice, will be checked (X) if it is an investment. In the report we only show amounts from documents with indicator different from X.
Example of invoice:
Note The indicator is only used for FIAP (Invoices) data. For provisions, the difference between investment/non investment is done by GL Account. There aren't investments in the Stocks and FIAR.
In BW, we filter out the CAPEX / Capitalized goods
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.
+On MM (Stock data):
+On FIAP/FIGL data:
+On FIAR data:
+Non assigned in Single-Business unit company :
If you have non-assigned values for companies which should be 100% assigned to a single business unit, contact the BW team: it is possible to set a default BU by company.
The BW working capital reports are all based on amounts in Local Currency Those amounts come directly from RCS.
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 RCS).
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: