1.0 Access Management 


List of application role + menu role  and explanation if we have several applications role with specials rules.

Role CodeRole DescriptionExplanation

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 objectExplanation
0COMP_CODE;C_COMPCDE;C_PMORDER__0COMP_CODECompany, 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_FAMILFamily, role: ZR_*_CA_P04

2.0 DataFlow

2.1 Overview

MPR_FAA1


MPR_FAA2


MPR_FAA3


MPR_FAA4


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 (WP1)

  • 0FI_AA_12 - FI-AA: Posted Depreciation (WP1)

  • 0ASSET_AFAB_ATTR - Depreciation Area Real or Derived (WP1)


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

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'.




Transformation: 0FI_AA_12 -> DSO_FAA3


2.2 Dependencies with other applications

We should have the information where the application is sending or receiving information (e.g. APD open hub) 

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 ChainFinal Provider LoadingFrequencyTime startDuration