SQL*LIMS® is a laboratory information management system (LIMS) that provides laboratory automation—sample tracking, quality assurance, stability testing, environmental monitoring, instrument connectivity, and more—for pharmaceutical, petrochemical, forensic, food and beverage organizations.
LabVantage.com
Sitemap
Customer Care

Features

SQL*LIMS QM connector for use with SAP - QM

Extends SAP QM into a full featured LIMS

SAP.Certified.jpgThe SAP Quality Management (QM) module is responsible for maintaining, coordinating and communicating product quality information throughout the enterprise while SQL*LIMS is responsible for the collection, manipulation, managing and communicating of quality data. The two systems when used together can be very powerful.

This certification also meets the SAP requirements for connecting SQL*LIMS to the mySAP.com platform, making SQL*LIMS one of the few selected LIMS vendors to receive a mySAP.com interface certificate.

QM maintains inspection plans with product information, test definitions and quality specification limits. With the help of other SAP modules, QM initiates quality inspections and transfers all of this information dynamically to SQL*LIMS. SQL*LIMS will then process these quality inspections through laboratory specific workflows and record quality data in greater detail and under more stringent control than QM is capable of. When released by the laboratory, summarized results and statuses are uploaded from SQL*LIMS to QM.

The SQL*LIMS SAP Connector has implemented the complete library of SAP’s QM-IDI (inspection data interface) including inspection points for continuous monitoring. The SQL*LIMS SAP Connector is certified by SAP for all SAP R/3 versions including ERP Central Component (ECC) versions 5.0 and 6.0. This provides one of the most comprehensive LIMS interfaces to SAP on the market today.

Details matter between SQL*LIMS Lot Manager and SAP QM

The SQL*LIMS Lot Manager maintains extensive detail concerning the inspection lots, multi-level testing specifications, and sample workflow providing a powerful complementary interface.

QM creates inspection lots based on inspection plans and defines the expected operations (samples) and inspection characteristics (results). The definition and creation of in-process and sub-lot characteristics (expected results) is lacking. SQL*LIMS SAP Connector together with SQL*LIMS Lot Manager extends the functionality of SAP by providing additional result information at the sub-lot and stage level, providing the ability to view and correct in-process excursions, make better informed manufacturing decisions, and release partial lots.

To allow greater flexibility and independence to meet business needs, SQL*LIMS SAP Connector provides a unique mapping tool that allows the translation between the fixed format of QM and the flexible, lab specific terminology of SQL*LIMS.

SQL*LIMS Features Complimentary to SAP

SQL*LIMS Lot Manager provides a powerful complement to SAP by offering features to automate sample work flow, provide lot details, and provide efficient reporting tools. Unique features of the SQL*LIMS SAP Connector are:
· Track individual stages of the manufacturing process.
· Provide ability to create and track sublots
· Define and enforce skip lot testing
· Partially release lots
· Quickly view and correct manufacturing excursions
· Track additional information per lot, stage, sample, or test
· Enter both intermediate and final results
· Check multiple product specifications in the laboratory
· View manufacturing trends in real-time
· Barcode label and receive samples
· Perform automatic re-sampling and re-assays
· Assign work to specific personnel, instruments, workstations, or groups
· Provide instrument interfacing to ensure data integrity and eliminate transcription errors
· Optimize sample workflow by assigning worklists to analysts and instruments
· Automatic result calculations
· Automate result review and reporting
· Physical tracking of a sample lets the user find the location of a sample, place the sample in a new location, or record the disposal of the sample
· Numerous standard lab reports such as sample costs, sample locations, back-log reports, summary reports and trending
· Reports can be automatically "triggered" by changes in sample or result status
· Create unique new reports and user defined ad hoc reports
· Automate worksheets at the lab bench
· Maintain full audit trail and electronic signatures for a complete sample history
· GMP/GLP/GALP/IS0-9001 compliance ensures the enforcement of standard operating procedures

Open Enterprise Interface to other SAP Modules

SQL*LIMS has the ability of interfacing to any of the SAP modules such as Materials Management (MM) and Production Planning (PP). The SQL*LIMS ERP Connector provides a standard data structure for electronic data interchange (EDI) between SQL*LIMS and SAP. This message based interface supports all SAP modules as well as non-SAP systems. This standard SQL*LIMS tool can make use of SAP IDoc transactions via SAP NetWeaver to communicate openly with SAP enterprise business applications.

For more information Contact us


» Back to features


Print this Page
Sign up for e-news
Contact Us
Refer a Colleague
SQL*LIMS
User Community

Privacy Policy | Terms of Use
©2009 LabVantage Solutions, Inc. All rights reserved