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

ROLLIER, Charlotte (SBS Information Services) : Reporting Coordinator
Guillaume Thevenet (SBS Information Services) : BW Coordinator

Objective of the application

The objective of FIAA in BW is to report the asset valorization and depreciation.

Usage information

Around 25 users, worldwide with daily update

Statistics by infoproviders

InfoProvider Used		Zone	DEC 2015	JAN 2016	FEB 2016	MAR 2016	APR 2016	MAY 2016	JUN 2016	JUL 2016
MPRO/MPR_FAA2	FIAA: DSO Period Values and Transactions	AP	14	11	11	19	36	12	13	12
		EU	3	1						4
		#	35	35	35	35	35	35	35	35
MPRO/MPR_FAA4	FIAA: Period Values and Transactions	AP	1			1			1
		EU	9	5	4	13	22	15	14	19
		LA								3
		NA						0
		#					1
Overall Result			62	52	50	68	94	62	63	73

Statistics by queries

InfoProvider	Query		DEC 2015	JAN 2016	FEB 2016	MAR 2016	APR 2016	MAY 2016	JUN 2016	JUL 2016
MPR_FAA2	BW_QRY_MPR_FAA2_1001	FIAA Balance Sheet by Flow (WB & BD)	21	18	18	26	43	19	20	18
	BW_QRY_MPR_FAA2_1002	FIAA Acquisition by CGU and Sites (WorkB)	1							1
	BW_QRY_MPR_FAA2_1003	FIAA Fixed Assets Closing Bal. by CGU (BroadC)	28	28	28	28	28	28	28	28
	BW_QRY_MPR_FAA2_1004	FIAA Detailed Evaluation Accounting Grid (Core)	2	1						4
MPR_FAA4	BW_QRY_MPR_FAA4_1001	FIAA FC L3005 Bal. Sheet by Flow (Core) - OBSOLETE				1
	BW_QRY_MPR_FAA4_1002	FIAA FC L6710 Acqui. by CGU and Sites (Core)	2						2
	BW_QRY_MPR_FAA4_1004	FIAA Detailed Evaluation Accounting Grid - Posted (WorkB)	8	5	4	13	22	15	13	22
	BW_QRY_MPR_FAA4_1005	FIAA AuC not yet brought into service (Core)					0	0
	BW_QRY_MPR_FAA4_1007	FIAA Five-yearly Inventory Report (Core)					1		0
	BW_QRY_MPR_FAA4_1014	FIAA Report Insurance Values (Core)
Result			62	52	50	68	94	62	63	73

History

This project was developed in 2011 by Leonardo Andrade with BW technical support of Nestor Araujo.

Rules

Roles and access

Role Code	Role Description	Explanation
ZR_RCS_CA_M33	User Reporting FIAA	role menu

Authorization objects

List of authorization objects mandatory for the application.

Authorization object	Explanation
ZBI_FIAA	Asset Accounting
ZBI_FIAA_K	Asset Accounting key users
ZR_RCS_CA_M33	Asset Accounting menu

PS: the roles Z_FIAA and Z_FIAA_K are obsolete

See also file maintained by Authorization team :

BW Catalog of Roles: Authorization catalog
BW Authorization: BW Authorizations

Dataflow overview

Reporting documentation drive folder:

Exemple of dataflow overview :

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Systems involved

Rhodia ERP WP1
Solvay ERP PF1 (just the DSO COEP - line item settlement with status)

Subject

All changes done with assets in ERP are sent to BW, like: acquisitions, depreciations, revaluations, retirements, transfers, general changes.

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

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

Process chain

PC_FIAA - FI - Asset Accounting

Data Flow

Data loading

Process Chain

The process chain that loads all delta movements in FIAA is PC_FIAA - FI - Asset Accounting (see below).

Loading frequency

The data load is done daily in delta 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

BW Asset Queries

Main queries

Main functionalities

See details about key figures in this link: BW 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.

Broadcast settings

Maintenance

Known bugs

There is no ticket opened for FIAA for more than 2 years.

Recurring procedure

There is no list of recurring procedures

Planned Evolution

There is no evolution planned by FIAA, maybe the in future the Solvay data will be integrated to the BW FIAA, but the source system control must be implemented for that.