You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

 

General presentation

This page provides all the technical and detailed documentation concerning the "FIWC for Solvay Group" (Finance Working Capital) application in BW, including :

  • General overview of the dataflow
  • Query, Workbook, Webtemplate and broadcasts documentation
  • Maintenance operations : necessary manual updates of master data.

This application replaces the former FIWC application which was created for Rhodia legacy (WP1).

Systems involved

  • Rhodia ERP WP1

  • Solvay ERP PF1 (020)

  • CICC ERP PI1

  • Acetow ERP RHO

  • PRS ERP PF1 (050)

  • BFC (flat files)

General definitions

Working Capital definition

  • Global definition:*
    The working capital is a financial indicator used to measure the Free Cash Flow of the enterprise.

It is equal to the sum of:

  • Value of the stocks
  • Value of the customer receivables
  • Value of the vendor payables

It excludes:

  • Intercompany
  • Componies not in consolidation area (consolidation view) - for GBU usage only

In BFC:
Every month, persons in each company will get the values from RCS/BW for each account and enter it manually in BFC.

  • Values are entered in local currency. BFC then converts to EUR.
  • If amounts are not affected to a business unit then they will manually affect the amounts using rules.

G/L Accounts

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

Consolidation or Accouting view

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.

Intercompany exclusion

In the queries, we keep only the company with Intercompany flag as X. This flag is determined in PRS source system.
The flag is stated as X for the consolidation methods 10 (IG - Fully consolidated), 30 (IP - Proportionately consolidated) and 55 (ME - Equity method futur IP). The table used is ZZF_T001_MGT.

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.

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.

PRS Source system

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.

Currency conversion

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 :

  • Based on * ate ZRHO* :

  • Uses the rate available for date = * revious Day Exit (Working Cap) -* DATEWC00

  • We use the target currency from variable * urrency (Single Value, Optional)*- CURVAR01

Dataflow in BW

Dataflow

For the BW Working Capital we use 4 sources of data:

Vocabulary:

FIGL: General Ledger

FIAP: Account Payable

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) :

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).

  • MPR_WC01 Global Working Capital (Access by Company code)

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:

  • Contribution percentage (C_CONTRIB): 100 normally. Can be 0 for obsolete companies. Other value if company has a partial contribution (Ex : Butachimie = 50)
  • Default Profit Center (C_DEFPCTR): Default profit center for FIGL/FIAP data when there is no profit center or a dummy profit center (9999).
  • Default Controlling Area (C_DEFAREA) : Controlling area of the default profit center

+0GL_ACCOUNT – GL Account:

  • GL Account Working Capital Type (C_GL_TYPE) : Type of the GL Account (stock, FIAP, FIAR)
  • GL Account Working Capital SubType (C_GL_STYP): Sub type of the GL Account.
  • Magnitude Account (C_MGN_ACC): Code of the magnitude account mapped to this GL account.

+C_GLBFILT – Global filter:

  • Contains the list of rules used to know for all GL Accounts where they must be loaded (FIAP, FIAR or STOCK)
  • No labels