General presentation

Objective of the application

External suppliers are fulfilling an excel sheets after interventions on sites. The excel files are integrated in SAP through a webdynpro application. Then the files are validated by the internal requester and financial controllers in SAP to create an entry sheet. Then the data is integrated in BW to produce KPI for each type of intervention.

There are six types of intervention:

• Scaffo (Scaffolding)
• Piping
• Insula (Insulation)
• Inel (Electric Instruments)
• Lift
• Clean (Cleansing)

Main documentation: https://drive.google.com/open?id=0B-KST39ThPrUaUFJU2w0bE1tOGM

Technical documentation : https://drive.google.com/open?id=0B-KST39ThPrUeUVDb0FRNVNQckU

List of contacts:

• Raphaël BERT (SBS Information Services) : IT Project Leader

Usage information

Around XX users on BO analysis, only on France sites.

Roles & Access

Roles and access

• Authorization role : ZR_RCS_PM_A02: Maintenance Orders Applications - End User role
• Role menu : ZR_RCS_CA_M08: PM - Plant Maintenance

Authorization objects

• Company Code

Dataflow presentation

Overview

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

Functional and Technical rules on Workbench + Reporting

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

1. Master Data C_PMORDR
2. DSO ODS_PM04

Data loadings

Info providers and objects loaded

• Process Chain GTBU 
• Process Chain GTBU_SOLVAY

Loading frequency

Daily loadings

Average performance

• Daily Process Chain GTBU loaded in 1h, with around 50k lines for delta and 50k lines for full at propagation level.
• Daily Process Chain GTBU_SOLVAY loaded in 1h30, with around 1k lines for delta and 50k lines for full at propagation level.

Historization

None

Reporting

Queries Documentation or user guide

<to be done on customer wiki :  SBS IS - Customer Support Knowledge Base>

If not covered by queries documentation

Main queries

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 for program ZWPMT0040 add data in table ZWPMT019 for the extraction. 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_LBLNI Entry sheet number

• C_EQUNR Equipment number

• C_SEDAT Service entry sheet creation date

• C_SCITKEY Equipment item key

Broadcast

None

Maintenance

Known bugs

<list recurring bugs and demand from users>

Recurring procedure

< list recurring procedure >

Planned Evolution

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