1.0 Access Management 

2.0 DataFlow

2.1 Overview

MPR_FAA1

MPR_FAA2

MPR_FAA3

MPR_FAA4

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

• 0FI_AA_12 - FI-AA: Posted Depreciation

• 0ASSET_AFAB_ATTR - Depreciation Area Real or Derived

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.

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)

For instance, variant L3005_J3_ZFR3

Schedule

There is no schedule for FIAA workbooks.

The setting below is empty.

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