PI Gateway to SAP R 3 Gretchen M Schwenzer

PI Gateway to SAP R/3 Gretchen M. Schwenzer, Ph. D OSI Software, Inc.

Corporate Benefits of Integration l Accurate Planning l Reduced Inventories l Accurate Production cost tracking l Accurate Material Tracking l Focused Maintenance l Accurate record keeping for Quality Certification l Uniform Specification l Confirm Product Availability in near real time l Production Targets 1998 PI System Users’ Conference

Data Needs at the Plant Floor l All data values at Fine time resolution l Historical Data l Trending l Methods to make ad-hoc comparisons l Overview of Plant and Key Performance Indicators l Zoom-in to Problem areas for analysis 1998 PI System Users’ Conference

Data needs at the Enterprise Level l Summarized data l Data by Major Event l Reconciled Data l Final Calculation Data l Isolated measurements l Overview of Business Key Performance Indicators l Zoom-in to key Problem Areas 1998 PI System Users’ Conference

Requirements for Translation of data from the Plant Floor to the Enterprise l l l Performance Calculations Flexibility for external application calculations Manual correction and audit trail Interface to many control environments Syncronize time data requests and replies Mixture of Enterprise process and Plant floor Process Batch tracking Point alias and grouping Equipment Alias and grouping Schematic and trending view into both enterprise and plant data Error Trapping and recording Easily adaptable to changing business 1998 PI System Users’ Conference

SAP PP-PI (PI-PCS) and OSI-PI/Plant Suite l SAP Functionality Ñ Ñ Process Order creation to meet order requirements Track material inventory General Recipe for material Track cost of production l OSI Functionality Ñ Collects and distributes actual data for material consumption and production and utilities Ñ Translates general recipe to batch execution system Ñ Maintains history of recipe that was run and reported values to enterprise Ñ Graphically presents current and historical data for analysis Ñ Combines recipe data with process variables for analysis 1998 PI System Users’ Conference

SAP Equipment (PM-PCS) and OSI PI/Plant Suite l SAP Functionality Ñ No. of hours on stream trigger maintenance Ñ Alarm limits for equipment trigger maintenance Ñ Maintenance scheduling using human resource and stores constraints l OSI Functionality Ñ Consolidates equipment variables for analysis and improvement of plant performance in conjunction with process conditions Ñ Monitors and reports alarms and no. of hrs. on stream to trigger SAP maintenance Ñ Graphical plant view into Plant and SAP data 1998 PI System Users’ Conference

SAP QM (QM-IDI) and OSI PI/Plant Suite l SAP Functionality Ñ Ñ Ñ Quality of goods receipt In-process quality specification Quality of goods shipped and certificate of analysis Specification Library Company quality test requirements l OSI Functionality Ñ Ñ Ñ Capture data at source Specification disbursed to industrial desktop Integrates Quality data with process data for plant analysis Disburse Quality worklist to plant floor Reporting Flexibility Interface to Lab Systems 1998 PI System Users’ Conference

SAP Directions l SAPGUI will be windows control container with 4. 0 l SAP support of DCOM, Microsoft Transaction Server 4. 0 C for distributed BAPI’s l BAPI’s and RFC interface SAP strategic directions 1998 PI System Users’ Conference

Plant Suite Server Integration Using OLE Automation MM PM RFC’S PP-PI SAP Automation Server (Remote Function Calls) SD QM SAP R/3 Applications OLE NT Workstation NT Applications SAP GUI Plant Suite Server Microsoft SQLServer PI Historian Industrial Desktop Applications Process Book PI PI-Batch PID FIX Points of Integration Partners Tools

PI System Gateway to SAP R/3 Messages SP 88 Model Recipe • Instruction Translation • Assign a Procedure • Tag Mapping • Material Mapping Request Handling SAP Action Results PSRLINK Man. Messages (wait until complete) Reply Batch Execution System (optional) 1998 PI System Users’ Conference PI Batch (optional) PI System

PSRLINK SQL SERVER Tables 1998 PI System Users’ Conference

SAP PI-PCS to PI l Server Ñ Track message request and reply Ñ Translate message request into retrievable info Ñ Represent the recipe in SP 88 format Ñ Open interface to multiple systems Ñ Support batch execution systems l Client Ñ Single view of recipe and process data 1998 PI System Users’ Conference

Turning a Production Request into Action l Continuous process - set start date and time and use duration such as shift, day, etc. l Batch Execution System such as PID’s Openbatch l Setting status of tags in PI via Control System, Visual Basic application or other program.

PP-PI Instructions Supported • • • • AORD_1 AMAT_1 APHASE_1 ACRST_I AOPST_I APHST_I ACONS_1 APROD_1 AREAD 2 APHACT AQMSMR APHAPR_1 Order Information Material Information Phase Information Recipe Status Operation Status Phase Status Material Consumed Material Produced Read Values Multiple Read Values Activity Confirmation Quality Data Puts values in PI

1998 PI System Users’ Conference

1998 PI System Users’ Conference

1998 PI System Users’ Conference

SAP PM-PCS to PI l Server Ñ Determine if value is in Alarm state Ñ Track status of posting in SAP Ñ Map SAP location identifier to PI identifier l Client Ñ Graphic launch into SAP Ñ Present data from PI and SAP in same window 1998 PI System Users’ Conference

1998 PI System Users’ Conference

VBA Scripting in Process. Book

SAP QM-IDI to PI l Server Ñ Inspection Lot and Inspection Point Processing Ñ Transfer Quality specifications to PI for Process Ñ Map QM data to Process Variable l Client Ñ Analyze Quality and Process data together Ñ Support Hand-Held Terminal Collection 1998 PI System Users’ Conference

1998 PI System Users’ Conference

Role of the Data Historian and Process. Book in Integration l Collection of raw data from control environment l Performance Calculations l Environment for external calculations l Alarming l Batch records l Storage of Calculated Data l Single presentation tool for all data 1998 PI System Users’ Conference

PSRLINK Gateway to SAP R/3 Advantages l l l Microsoft infrastructure (MS SQL-Server, VBA, etc. ) Network access from any ODBC compatible Application Process. Book as Front End History of recipe and batch execution Services continuous and batch processes Tag and Material mapping, Alias handling Extensive Error Checking of the SAP recipe Component of Plant Suite Server Native Interfaces to PI System and Open. Batch Interface to other systems through PI and/or customization Trace all data requests from SAP 1998 PI System Users’ Conference

SAP Certification What Does It Mean l Clear scope of functionality supported l RFC’s and BAPI are interfaced with C++ or VB not ABAP l Building 3 rd party interfaces to SAP requires knowledge of areas of SAP which are not generally available l Access to Key people at SAP and early information about releases l Access to SAP development machine l Use SAP standard software and techniques l Committed partnership by SAP and OSI 1998 PI System Users’ Conference

Customers Installed Interest to Evaluations l Pro. Gold l Sterling Diagnostics l l l 1998 PI System Users’ Conference Dow Corning Hoechst Westvaco Georgia Pacific Mossgas Sumitomo Chemical Hercules Codelco Wacker Montel Amplats + others

Future Developments for RLINK and Plant Suite l Transaction Server and DCOM support l Interface to MM l Additional BAPI support l Enhancements to Plant Suite Server 1998 PI System Users’ Conference

SAP Sources to SAP Customers l wwwext. sap. com/usa/saplabs. htm to locate which partners are certified l Compkementary Software Partner Directory 1 -800 -USA-1 SAP l PP contact SAP Waldorf Claudia Coppola 49/6227/746775, main no 49/6227/747474 l www. saplabs. com/bapifest. html Ñ MM-MOB Mobil Data Entry Ñ QM_IDI Quality Management Ñ PP-PDC Channel 2 Plant Data Collection Ñ PI-PCS Process Control System Interface Ñ PP-POI Production Optimization Ñ PM-PCS Plant Maintenance (not listed on web page) 1998 PI System Users’ Conference