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

The objective of FIAA in BW is ro report the asset valorization and depreciation,

Tool Leader + IT leader of the application: Name of project or main leader for the application + reporting coodinator

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

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-26 16:8:34.png

Dataflow overview

Reporting documentation drive folder:

Exemple of dataflow overview :

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Dependencies with other applications

There is an integration with BW Project (PS) linking the DSOCOEPD with ODS_WBS6 (Rhodia) and DSO6COEP with ODS6WBS6 (Solvay).

Info providers and objects loaded

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

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 9:5:54.png

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 9:6:29.png

0FI_AA_12 - FI-AA: Posted Depreciation

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 9:7:20.png

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 9:7:42.png

0ASSET_AFAB_ATTR - Depreciation Area Real or Derived

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 8:58:29.png

Process chain

PC_FIAA - FI - Asset Accounting

Data Flow

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 9:10:37.png

Data loadings

Process Chain

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

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > PC_FIAA.JPG

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

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-26 16:20:10.png

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

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-26 16:51:30.png

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:

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 10:30:46.png

For instance, variant L3005_J3_ZFR3

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 10:36:14.png

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 10:36:57.png

Schedule

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 10:34:36.png

There is no schedule for FIAA workbooks.

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 11:0:6.png

The setting below is empty.

TECHNO - BI TEAM > BW RTR - FIAA - Asset Accounting > image2016-7-27 11:1:33.png

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.

Additional links

See below a list of interest documents with additional infomation about Asset Accounting.

Asset Accounting

Asset management

RCS fixed assets - new CORE design_EN

RCS Asset Global Presentation

Creating a completed fixed asset

RCS FI-AA Fixed Assets

FAA Closing period

Useful transactions to be used for checking data

Transaction	Description	Corresponding table	Comments
AS03	Asset Display	ANLA, ANLB	in ERP
AW01N	Asset Explorer	ANLA, ANLB	in ERP
CJ03	Display Project WBS Element	PROJ, PRPS	in ERP
RSCUR	Currency conversion	TCURR	in BW