1.0 Access Management

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_M09

PS - Project Costs

Role menu for all project costs queries

ZBI_RCS_PS_A02

Project Costs and Structures Analysis - End User role

Application Role:

- End User rights
- gives access to infoproviders of Infoarea "AREA_PSCO"
- BI Analysis Authorization "ZBI_PS" ("*" for authorization objects not relevant for the application)

ZBI_RCS_CO_A21

CBS Project costs Reporting Analysis - End User role

Application Role:

- End User rights
- gives access to infoproviders of Infoarea "AREA_F_CO_CBS_PS"
- Gives access to multiprovider:MPR_PS014
- BI Analysis Authorization "ZBI_CBS_PC"

List of authorization objects mandatory for the application.

Authorization object	Explanation
0COMP_CODE;C_COMPCDE;C_PMORDER__0COMP_CODE	Company, role: ZR_*_CA_P01
0PROFIT_CTR__CPFCTR1_2; 0PROFIT_CTR__C_PFCTR1;CPFCTR1_2;C_AGRITM__CPFCTR1_2; C_ASSET2__C_PFCTR1;C_ASSET__C_PFCTR1;C_MATPLNT__CPFCTR1_2; C_MATPLNT__C_PFCTR1;C_MATPNT2__CPFCTR1_2;C_PFCTR1; C_PMORDER__C_PFCTR1;C_PMORDR__C_PFCTR1;C_PRDEQUI__CPFCTR1_2; C_RECONTR__CPFCTR1_2;C_RESP_CC__CPFCTR1_2;C_SUBACT2__CPFCTR1_2 C_TECMAT__CPFCTR1_2;C_WBS_EL2__CPFCTR1_2;C_WBS_EL2__C_ZSECT;C_WBS_ELE__CPFCTR1_2; C_WBS_ELE__C_ZSECT;C_ZSECT	GBU, role: ZR_*_CA_P05
C_FAMIL;C_WBS_EL2__C_FAMIL;C_WBS_ELE__C_FAMIL	Family, role: ZR_*_CA_P04

2.0 DataFlow

2.1 Overview

CPFIAA04

DSOs / aDSO

DSO_FAA2 - FIAA: Annual Values
DSO_FAA3 - FIAA: Period Values
DSO_FAA1 - FIAA: Transactions

APFIAA04 - FIAA: Period Values - Solvay
APFIAA02 - FIAA: Transactions - Solvay
ABFIAA05 - FIAA: Period Values - Solvay Level 2
ABFIAA06 - FIAA: Transactions - Solvay Level 2

Cubes

WP1:

- CUB_FAA4 - FIAA : Period Value
- CUB_FAA2 - FIAA: Annual Value
- CUB_FAA1 - FIAA: Cumulated Movements
- CUB_FAA3 - FIAA: Transactions

Multi Providers / Composites Providers

WP1:

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

PF1:

CPFIAA04: 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

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2016-7-27 9:5:54.png

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2016-7-27 9:6:29.png

0FI_AA_12 - FI-AA: Posted Depreciation

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2023-9-25_11-25-50.png

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2023-9-25_11-26-12.png

0ASSET_AFAB_ATTR - Depreciation Area Real or Derived

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2016-7-27 8:58:29.png

Reporting documentation drive folder:

https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE

Exemple of dataflow overview :

Template Application name DataFlow

2.2 Technical Rules on Workbench

Rhodia

Transformation: 0FI_AA_11 -> DSO_FAA1

Start routine: extraction from master data C_ASSET in internal table itb_asset in function of fields from package (c_compcde, c_at_main, c_asset, dato).

Field routine: 0PLANT is determined with a look up in itb_asset with source field fields BURKS (company code), ANLN1 (C_AT_MAIN) and ANLN2 (C_ASSET). If correspondance found in intenal table, take the plant if not, plant is empty.

Transformation: DSO_FAA1 -> DSO_FAA2

Start routine: Is ource fields, we have two type of key figures '("TR" and "YR"). In function of the Asset Transaction Type (transtype) we assigned the differents key figures in one target to have in result fields only "TR" key figures.

If transtype = 'CUM' we assigned the "YR" key figures in "TR" key figures, example: <source_fields>-acq_val_tr TO wa_trans-cacq_vl_yr.

If transtype = 'PNL' we keep the assignation "TR" → "TR", example: <source_fields>-acq_val_tr TO wa_trans-acq_val_tr.

Transformation: DSO_FAA1 -> DSO_FAA3

Start routine: take only source data where transtype <> 'PLN'.

Check if for each record a period exists, if not calculate the period.

Same principle as Transformation: DSO_FAA1 -> DSO_FAA2, we regroup different key figures in same key figures "TR" but here not in function of TRANSTYPE but FISCPER.

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2023-9-25_15-15-33.png

Transformation: 0FI_AA_12 -> DSO_FAA3

Start routine; Check if for each record a period exists, if not calculate the period.

extraction from master data C_ASSET in internal table itb_asset in function of fields from package (c_compcde, c_at_main, c_asset, dato).

Field routine: 0PLANT is determined with a look up in itb_asset with source field fields BURKS (company code), ANLN1 (C_AT_MAIN) and ANLN2 (C_ASSET). If correspondance found in intenal table, take the plant if not, plant is empty.

Transformation: DSO_FAA1 -> CUB_FAA1

Start routine; extraction from master data C_ASSET & C_AT_AFAB in internal table itb_asset & itb_afab in function of fields from package (c_compcde, c_at_main, c_asset, (dato & datefrom for C_ASSET)).

Field routines:

0ASSET_CLAS: field "asset_clas" determined with a look up in itb_asset with source field fields COMP_CODE, C_AT_MAIN and C_ASSET.

0CHRT_ACCTS: field " chrt_accts" determined with a look up in itb_afab with source field fields COMP_CODE, C_AT_MAIN, C_ASSET and C_AT_AFAB.

0BALSHA_APC: field " balsha_apc" determined with a look up in itb_afab with source field fields COMP_CODE, C_AT_MAIN, C_ASSET and C_AT_AFAB.

0CO_AREA: field "co_area" determined with a look up in itb_asset with source field fields COMP_CODE, C_AT_MAIN and C_ASSET.

C_COSTCTR: field "c_costctr" determined with a look up in itb_asset with source field fields COMP_CODE, C_AT_MAIN and C_ASSET.

Key figures:

0INV_SUP_TR = INV_SUP_TR + VA_INVS_TR

0ORD_DEP_TR = ORD_DEP_TR + VAW_ODP_TR

0RES_TRF_TR = RES_TRF_TR + VAW_AVR_TR

REVAL_TR + VA_RAPC_TR = REVAL_TR + VA_RAPC_TR

0REV_ODP_TR = REV_ODP_TR + VA_RODP_TR

0SPC_DEP_TR = SPC_DEP_TR + VAW_SDP_TR

0UPL_DEP_TR = UPL_DEP_TR + VAW_UDP_TR

Transformation: DSO_FAA2 -> CUB_FAA2

Start routine; extraction from master data C_ASSET & C_AT_AFAB in internal table itb_asset & itb_afab in function of fields from package (c_compcde, c_at_main, c_asset, (dato & datefrom for C_ASSET)).

Field routines:

0CHRT_ACCTS: field " chrt_accts" determined with a look up in itb_afab with source field fields COMP_CODE, C_AT_MAIN, C_ASSET and C_AT_AFAB.

0BALSHA_APC: field " balsha_apc" determined with a look up in itb_afab with source field fields COMP_CODE, C_AT_MAIN, C_ASSET and C_AT_AFAB.

0CO_AREA: field "co_area" determined with a look up in itb_asset with source field fields COMP_CODE, C_AT_MAIN and C_ASSET.

C_COSTCTR: field "c_costctr" determined with a look up in itb_asset with source field fields COMP_CODE, C_AT_MAIN and C_ASSET.

Solvay

RSDS 0FI_AA_12 PF1_020 -> ADSO APFIAA04

Start routine: extraction from master data C_ASSET in internal table itb_asset in function of fields from package (c_compcde, c_at_main, c_asset, dato).

2.2 Dependencies with other applications

FI-AA for CAPEX application is based in part on same propagation providers.

Broadcast:

There is a process chain BD_AAC - Asset Accounting Broadcast that is responsible to to run the list of broadcasts below → process chain not scheduled since 2013 (at 09/25/2023)

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2016-7-27 10:30:46.png

For instance, variant L3005_J3_ZFR3

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2016-7-27 10:36:14.png

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2016-7-27 10:36:57.png

Schedule

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2016-7-27 10:34:36.png

There is no schedule for FIAA workbooks.

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2016-7-27 11:0:6.png

The setting below is empty.

Data, Analytics & AI Platform > Technical Documentation - Fixed Accounting Assets > image2016-7-27 11:1:33.png

3.0 Data Loading

3.1 Info Providers and objects loaded

Detail of process chain, list + link between or special event done for the loading

Main Process Chain	Final Provider Loading	Frequency	Time start	Duration