Access Management 

DataFlow

Overview

Image Added

docid1JapJjHZsepSOPEa5MuONHdBu3qLQ7-tpMQ4t4Wwt4bATechnical documentation for dataflows : https://drive.google.com/open?id=0B-KST39ThPrUeUVDb0FRNVNQckU

Technical Rules on Workbench

Below objects should be loaded previously before load GTBU in the following sequence:

Data is extracted from standard extractors from system WP1 400: 2LIS_17, 0PM_OM_OPA_1 & 2, 0CA_TS_IS_1

Dependencies:

• It shares some extractors (2LIS_17_I3OPER, 0PM_OM_OPA_2) with MECANO.
• Data is consumed by ORACLE by the broadcast of a workbook (BCAST_ORACLE_PM) with PM costs, which is integrated manually by IS PM team.
• Data is loaded in cube CUB_PM for QV dashboard RCS KPI
• Costs data from all three systems (WP1/PF1/RHO) is used in FI cubes

Functional Rules:

• Alternative Labeling is used on Functional Location in the source system. The alternative label is loaded in the master data attributes.

Transformations for CUB_PM001 CUB_PM001 IFS_0PM_OM_OPA_1:

Start routine:

Fields ABCINDIC (ABC indicator) and C_OBJTYPE (Object  Type (equip)) comes from view  /BI0/MEQUIPMENT if a corrspondance is foundwith the equipment, else comes from view /BIC/MC_FUNCLOC.

Infopackages are filtered on CURTYPE = 10 & 0VTYPE between [020;030] and [050;090] with differents periods.

Transformation TRSF: ODS_PMEN -> CUB_PM001:

C_FUNCLOC (functional location) / 0WAPRL (Maitenance plan) / C_WAPOS (maintenance plan item) & 0NOTIFICATN (Notification number) come from master data C_PMORDER.

C_COSTCENTER equal M if field C_MATNR is not empty.

C_EBELN (Purchase order number) → if ref_doc_ct (Reference Document: Type) = 020 then field equal ref_doc_nr (Reference Document Number (External Document Number)).

C_EBELP (Item Number of Purchasing Document) → if ref_doc_ct (Reference Document: Type) = 020 then field equal ref_doc_it (Reference document item).

C_DINPD (Item number purchase document description)→ if  ref_doc_ct = 020 then field equal C_DINPD.

Fields ABCINDIC (ABC indicator) and C_OBJTYPE (Object  Type (equip)) comes from view  /BI0/MEQUIPMENT if a corrspondance is foundwith the equipment, else comes from view /BIC/MC_FUNCLOC.

DTP - ODS_PMEN -> CUB_PM001: filters currency type = 10 and semantic group on CURTYPE / METYPE / VTYPE / FISCVARNT / MATL_GROUP / DB_CR_IND / CREDITOR / VTSTAT / VTDETAIL / VERSION / COSTELMNT / COMP_CODE / CO_AREA / FISCPER / /BIC/C_EKORG / /BIC/C_EKGRP.

Transformation: TRSF : 0PM_OM_OPA_2 -> ODS_PM01 (Rhodia)

Fields 0PART_CCTR (Partner Cost Center), 0PART_ACTTY (Activity Type of Partner Cost Center), 0PART_COORD (Partner Order), 0PART_WBSEL (Partner WBS Element), 0PART_ABCPR (Partner Business Process) are determined with module function CO001_BIW_PARTNER_DECODE with input parameter rspobart (Partner (short)) &  rsparobval (Partner IO val.)

DTP : 0PM_OM_OPA_2 -> ODS_PM01 (Delta): semantic group on KOKRS, BELNR, BUZEI, FISCVAR, FISCPER and CURTYPE.

Transformation RSDS 2LIS_17_I3OPER WP1_400 -> ODSO ODS_PM04:

C_PM_USST (C_PM_USST  User Status.) comes from master data C_PMORDER (field ZZISTAT).

C_SYSTATS (Detailed System Status.) comes from master data C_PMORDER (field ZZESTAT).

Transfer rule CUB_PM004 8ODS_PM04:

Fields ABCINDIC (ABC indicator) and C_OBJTYPE (Object  Type (equip)) comes from view  /BI0/MEQUIPMENT if a corrspondance is foundwith the equipment, else comes from view /BIC/MC_FUNCLOC.

Reporting

• CATALOG - Industrial & Planning Reporting (in the tab Maintenance)

1. Master Data C_PMORDR (Work Orders Master Data)
2. DSO ODS_PM04 (Work Orders / Operations)

For transformations between propagation and business layer C_COMPDE comes from master data C_PMORDR if a correspondance is found, else c_compcde is empty. C_WORKCTR and C_PLANT come from C_PM_OP2.

There are also seletives deletion in the start routines.

Each transformations (except for DSO_PM11) have similar structures rules (with some specificities, for more detail check directly in routines):

During the first package loading, an internal table is filled with data in source package.

Then during the next packages, we check if the new record added already exist in internal table but with different keys. If it's the case, the line is added in ITB_ SCAFFOLDING. If not the line is added but with key figures at 0 (or null) and some key fields (C_GTBUSH & C_INONUM & C_INOREF) empties or the lines is not loaded.

Key figures have differents rules in function of a specific field.

Reporting

• List of BEx Reports & Workbooks : CATALOG - Industrial & Planning Reporting (in the tab Maintenance, Category = GTBU)

Main queries

Image Added

Main functionnalities

The files generate data for BW in the export tab. Indicators are registered in the files with a key. After confirmation of the file, a night job (on WP1: PM_T00400_EU; on PF1: ZZI_020_TA_GTBU_EXTRAC_BW) for program ZWPMT00400 add data in tables ZWPMT007 and ZWPMT019 for the extraction. We can check the files uploaded by suppliers in the SAP transaction. In BW, the key relate to the KF.

The application is based on three datasources based on SAP tables:

• DTS_ZBW_ZWPMT007
• DTS_ZBW_ZWPMT019
• DTS_PMESLL

Main dimensions for the data:

• C_GTBUUID Unique log file identifier for GTBU
• C_PMORDR PM Work Order

• C_EQUNR Equipment number

• C_LBLNI Entry sheet number

• C_SEDAT Service entry sheet creation date

• C_SCITKEY Equipment item key

Several topics are covered by BEx reports :

• Work Orders with Maintenance Plan
• Work Orders with Equipment
• Notifications by Status and Causes
• Planned and Actual duration on Operations
• Work Orders and Operations by Status and Priority
• Monthly Costs
• Functional Location and Equipment Attributes
• Consumption of Materials on Work Orders
• Work Orders Costs by Vendor
• MTBF (Mean Time Between Failure)
• Backlog on Operations

Broadcast

• BCAST_ORACLE_PM (Weekly) : Extraction of actual costs year to date for current year send to PM IS Team for Chalampé plant, and the data is loaded manually in ORACLE Hyperion by PM Team.
• RCS_KPI_PM_ALL (Monthly) : Extraction of KPI PM. It has been unscheduled on SEP 2015 after a usage survey from IS Reporting Team and is not running anymore.

Dependencies with other applications

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

Data Loading

Info Providers and objects loaded 

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

Data loadings

Info providers and objects loaded

Infoproviers and Master data are grouped in the Application Area AREA_PM.

Process Chains included in the Global RSP_DAILY Process Chain:

• ZPC_MD_ATTR_RCS (For shared master data attributes and texts)
• RCS_PM_KPI (Load Cubes for RCS KPI application used by QV dashboard)
• RSP_PM
• RSP_PM_ACETOW (Load PM Costs data from RHO system for FI cubes)
• RSP_PM_SOLVAY (Load PM Costs data & Commitments and orders distribution rules from PF1 system for FI cubes)
• PC_PM_01

Others Process Chains:

• PC_PM_ORDER_WEEKLY
• PM_BACKLOG

Loading frequency

• Daily loadings Monday to Friday
• Weekly loadings for PC_PM_ORDER_WEEKLY & PM_BACKLOG

Average performance

The main process chain RSP_PM run in about one and a half hours.

PM Extractors (2LIS_17) are set up in delta with a delta queue. Costs on PM orders are loaded in full mode.

Historization

Data Quality Control

Operational Documentation

Procedures

<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>

Scheduling

<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>

Monitoring

<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>

Error Handling

<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>

Known Bugs

<List the existing bugs, its criticity, workarounds and resolution plan.>

Roadmap

• Ticket #17365: A new data has been added in the definition sheet for Scaffolding. The users want to add it in BW reports.