The new wiki link for this data flow is here: < >

echnical Documentation - GTBU Report

Please update the doc there and no longer here.

General presentation

Objective of the application

External suppliers are fulfilling an excel sheets after interventions on sites. The excel files are integrated in SAP systems WP1 400 and PF1 020 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/drive/folders/1Pk5gPNWiEzlCOzYvEr-TJGDayoK7C8_y

Technical documentation : https://drive.google.com/file/d/1pFiOeaK5wAWRTN5rVgb47VMokA2R0XtW/view

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/file/d/1pFiOeaK5wAWRTN5rVgb47VMokA2R0XtW/view

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 (Work Orders Master Data)
2. DSO ODS_PM04 (Work Orders / Operations)

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

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

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

Broadcast

• None

Maintenance

Known bugs

• None

Recurring procedure

• None

Planned Evolution

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