| Status | ||||||
|---|---|---|---|---|---|---|
|
| Warning |
|---|
The application was replaced by BW RTR - FI Working Capital for Solvay Group (WBP) /!\ Obsolete /!\ |
| Table of Contents |
|---|
General presentation
This page provides all the technical and detailed documentation concerning the "FIWC" (Finance Working Capital) application in BW, including :
...
| Info |
|---|
This page is only for technical or non-end-user information. |
General definitions
Working Capital definition
- Global definition:*
The working capital is a financial indicator used to measure the Free Cash Flow of the enterprise.
...
- Values are entered in local currency. Magnitude then converts to EUR.
- If amounts are not affected to a business unit then they will manually affect the amounts using rules.
FIGL functional explanations
In finance, every document is posted to a General Ledger Account (G/L Account). This GL account depends on the kind of document (stocks will have a set of accounts, AP another set, AR another etc…)
...
+The working Capital value corresponds to the value of all the open documents in a list of G/L Accounts.
G/L Accounts
We can split the Working Capital in 3 main components, which separates in sub-components. Each is a list of G/L Accounts:
...
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.
Filters in the Working Capital
Interco/Intraco
To filter out Intraco and Interco for Payables and Receivables we use the Status of the Trading Partner of the supplier/customer/partner.
...
In BW, we filter out all Intra and Inter company sales/purchases (Intraco, Interco)
Functional explanations
- For the working capital we are working at the Rhodia group limits. This means that we must not take into account sales or purchases between Rhodia companies.
- Each Rhodia company has a corresponding customer number and trading partner code in RCS and has a status.
- We only look at items for customers / vendors that correspond to non-Rhodia companies or non-integrated Rhodia companies.
Technical explanations
- To filter we use the “Status of the trading partner” of the customer or partner :
- Status is* = Partner is an integrated Rhodia company
- Status is* /3 = Partner is a non-integrated Rhodia company
No status = Partner is an external supplier/customer
Note: he master data team (MAGDA) is responsible for maintaining the partner and customer status value in RCS
Consolidated non obsolete companies
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 BW, we filter out all Obsolete / Non Integrated companies
Functional explanations
- We only want to display the values for non-obsolete companies and only for integrated companies.
...
Ex: 1892 - GIE Chimie Salindres
Technical explanations
- To filter we use the “Status of the trading partner” :
- Status is* = Partner is an integrated Rhodia company
- Status is* /3 = Partner is a non-integrated Rhodia company
No status = Partner is an external supplier/customer or obsolete company - Normally we do not have this flag on the company code (0comp_code) but only on the Partner code (0company). What we have done is add a routine that will get the status from 0Company and add it to 0comp_code
...
Note: he master data team (MAGDA) is responsible for maintaining the partner status value in RCS
Investments
To remove all investments from the account payables, we use the Cap Goods Indicator (Or Invest.ID in RCS)
...
In BW, we filter out the CAPEX / Capitalized goods
Functional explanations
- Some purchases (for example projects) are considered as investments are and capitalized.
- The working capital indicator does NOT take into account the capitalized amounts. This amount is in fact reported with the CAPEX indicator (PS)
Technical explanations:
- To filter out all the capitalized purchases we can use the “Indicator : Cap Goods” of the item
- / NO = Item is not capitalized
X / YES = Item is capitalized and must be removed from working capital amount
Business Assignments
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.
...
Example of the profit center hierarchy that is used to define the Industrial Axis.
Analyzing Not assigned
+On MM (Stock data):
- If there is a profit center
- Profit center may be linked to no Business Unit in the hierarchy* Verify the hierarchy
- Profit center is linked to a Non Assigned business unit in the hierarchy* Verify the hierarchy
- There is no profit center
- The material/plant master data has no profit center assigned to it* Update the master data
...
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.
Currency conversion
The BW working capital reports are all based on amounts in Local Currency Those amounts come directly from RCS.
...
- We use the target currency from variable * urrency (Single Value, Optional)*- CURVAR01
Queries documentation
Dataflow in BW
Dataflow
For the BW Working Capital we use 4 sources of data:
...
FIAR: Account Receivable
Technical dataflow:
MPR_WC01 and MPR_WC02
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
Authorization objects
- MPR_WC02 Global Working Capital (Access by GBU) :
...
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.
Maintenance : Manual management of Info objects master data
+0COMP_CODE – Company code:
...