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

if possible, give some information on average process chain duration, amount of data loaded and total data volume example: daily process chain loaded in 30 min, weekly chain loaded in 1h15, with around 2k to 10k lines in DELTA mode for a total of 10M lines in cube. The purpose is to give a general overview of the volume of data managed y the application

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

Give details if any historisation is done, example: keep only data greater than beginning of Y-3

Reporting

Queries End User Documentation

Main queries

Main functionalities

Give detail on all complex functionalities: list most important and/or complex KPI, query jump, alerts

Broadcast

Maintenance

Known bugs

Give the list and explanation on the known, not-solved, bugs.

Recurring procedure

List recurring procedures

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.