General presentation
The application loads data about asset accounting from ECC (just Rhodia RCS) into BW.
It is done daily using delta process via process chain schedule.
List of contacts
- Sandrine Micollet (SBS Information Services) : Reporting Coordinator
- Guillaume Thevenet (SBS Information Services) : BW Coordinator
Objective of the application
Tool Leader + IT leader of the application:
Usage information
History
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_M33 | User Reporting FIAA | role menu |
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| ZBI_FIAA | Accounting Asset |
| ZBI_FIAA_K | Accounting Asset key users |
| Z_FIAA | Accounting Asset (obsolete) |
| Z_FIAA_K | Accounting Asset key users (obsolete) |
Dataflow overview
Reporting documentation drive folder:
https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE
Exemple of dataflow overview :
Template Application name DataFlow
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Dependencies with other applications
Data loadings
Info providers and objects loaded
Process chain
- PC_FIAA - FI - Asset Accounting
DSOs
- DSOCOEPD - CO Object: Line Item Settlement With Status
- DSO6COEP - CO Object: Line Item Settlement With Status - Solvay
- DSO_FAA2 - FIAA: Annual Values
- DSO_FAA3 - FIAA: Period Values
- DSO_FAA1 - FIAA: Transactions
Cubes
- CUB_FAA4 - FIAA : Period Value
- CUB_FAA2 - FIAA: Annual Value
- CUB_FAA1 - FIAA: Cumulated Movements
- CUB_FAA3 - FIAA: Transactions
Multi Providers
- MPR_FAA3 - Annual Values and Transactions
- MPR_FAA1 - FIAA: DSO Annual Values and Transactions
- MPR_FAA2 - FIAA: DSO Period Values and Transactions
- MPR_FAA4 - FIAA: Period Values and Transactions
Main Master Data
- 0ASSET - Asset Sub-number
- C_ASSET - Asset Sub-number
- C_ASSET2 - Asset Sub-number
- C_AT_AFAB - Depreciation Area Real or Derived
- C_AT_AFA2 - Depreciation Area Real or Derived (not compound)
Main Extractors
- 0FI_AA_11 - FI-AA: Transactions
- 0FI_AA_12 - FI-AA: Posted Depreciation
- 0ASSET_AFAB_ATTR - Depreciation Area Real or Derived
Data Flow
Process Chain
The process chain that loads all delta movements in FIAA is PC_FIAA - FI - Asset Accounting (see below).
Loading frequency
The loading is done in daily mode.
Average performance
Daily process chain loaded in 50 minutes average with around 60K records inserted from delta mode process
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | 50 to 80 minutes |
| ~ Average nb of rows loaded per load | 100K to 1200K records (all providers) |
| ~ Total nb of rows loaded (if full) | DSO_FAA1 (58.000K) since 2011 DSO_FAA2 (19.000K) since 2011 DSO_FAA3 (19.000K) since 2011 |
| ~ Average Runtime for 10k lines | 30 minutes |
For details about application load monitoring, click in following link: Application Monitoring
Record Keeping
The data is kept since 2011.
Reporting
Queries End User Documentation
Main queries
Main functionalities
See details about key figures in this link: Asset Queries - key figure definition
Broadcast
There is a process chain BD_AAC - Asset Accounting Broadcast that is responsible to to run the list of broadcasts below:
For instance, variant L3005_J3_ZFR3
Schedule
There is no schedule for FIAA workbooks.
The setting below is empty.
Maintenance
Known bugs
There is no ticket opened for FIAA for more than 4 years.
Recurring procedure
There is no list of recurring procedures
Evolution
Additional links