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 a service 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 - I&P) : IT Project Leader. Responsible of the SAP processes & BW reporting.
Christophe GERBAULET (Technical Services Buyer) : Application Owner. Responsible of the Purchasing for Plant Maintenance on french sites.
Sylvain CANAL (GEC) : Responsible for the definition of the excel files.
Pierre JANIN (SBS Information Services - IST) : Responsible for the evolutions on the excel files in Visual Basic.

Usage information

Around 200 users, only on France sites. Around 30 suppliers for the files upload, the other are approbators from maintenance teams on site.

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:

Master Data C_PMORDR
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

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

Broadcast