General presentation
The application loads data about data taxes on sales and purchase from ECC (Solvay and Rhodia RCS) into BW.
It is done daily using delta process via process chain schedule
List of contact
- Olivier LERICHE
- Paula ESTEVES
- Surachet CHANSRI
- Pierre-Eric PONTENNIER: BI SC Finance Domain Leader
- Willy MADOUNGOU: BW Functional
Objectif application
The objective of FITX in BW is to report purchase and sales tax data.
History
This project was developed in 2022 by Willy MADOUNGOU and Pierre-Eric PONTENNIER
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_M41 | User reporting FIAA | Role menu |
Authorization objects
List of authorization objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| ZBI_WBCAP_GBU | Asset Accounting |
| ZBI_RCS_FI_A31 | Asset Accounting Key users |
| ZR_RCS_CA_M41 | Asset Accounting menu |
Dataflow overview
Reporting documentation drive folder:
Exemple of dataflow overview :
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Systems involved
- Rhodia WP1
- Solvay PF1
Subject
This report allows you to trace purchase and sales tax data
Dependencies with other applications
There is an integration with BW Project (PS) linking the DSOCOEPD with ODS_WBS6 (Rhodia) and DSO6COEP with ODS6WBS6 (Solvay).
Data model
Info providers and objects
Infoobjects
Composite provider
- CPFITX01- FITX : Tax Lines Items Delta extraction
- CPFIAR01- FIAR: Line Item with Delta - Rhodia
- CPFIAR02- FIAR: Line Item with Delta - Solvay
ADSO
- DBFIAR01- FIAR: Line Item with Delta - Rhodia Level 2
- DBFIAR02- FIAR: Line Item with Delta - Solvay Level 2
Transformation
- APFITX01- FITX: Tax Lines Items Delta extraction (Rhodia level 1)
- APFITX02- FITX: Tax Lines Items Delta extraction (Solvay level 1)
- ABFITX01- FITX: Tax Lines Items Delta extraction (Rhodia level 2)
- ABFITX02- FITX: Tax Lines Items Delta extraction (Solvay level 2)
Query
- BW_QRY_CPFITX01_0001 - Tax entries
Main extractors
- 0FI_TX_4-FI-GL: Taxes
Process chain
- PC_FITX_01 - Tax Line items
Data flow
Data loading
Process chain
The process chain that loads all movements in FIGL is PC_FITX_01 – Tax line items (see below)
Loading frequency
The data load is done daily in delta mode and full.
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |
Record Keeping
Reporting
Queries End User Documentation
Main queries
Main functionalities
Broadcast
Maintenance
Known bugs
Recurring procedure
Planned Evolution
There is no evolution planned by FITX, maybe the in future the Solvay data will be integrated to the BW FIAA, but the source system control must be implemented for that.