The Design And Implementation Of Drug Tracing System Based On SAP NetWeaver

Tracing system is a system that can trace the whole process of production, transformation and sales of the product. It can warn when there is a problem and it can improve the supervising ability. It also can improve the dealing rate of the drug accident. So it means a lot to build an efficient drug tracing system. SOA is highly integrated, standard, loosely coupled, reusable and extendable. IBM, Oracle and SAP all have put forward their SOA products to support business application. SOA has helped the companies reduce the cost and improve the profits. Combining the SOA and the government tracing system is a new try. This paper is based on SAP NetWeaver and makes use of its strong functions to build the drug tracing system.This paper used ASAP quick implement methodology. This paper did the project according to the process of preparation, business blueprint, realization, latest preparation, online and technical support. It built three platforms to integrate people, information and process to make the data extendable and reusable. The three platforms contained portal platform, basis application platform and data warehouse platform. The portal platform is in charge of user management, authority management and identification management. The basic application platform is in charge of the main data management, salesman management, message management and other businesslike management. The data warehouse platform is in charge of the report analysis and report warning. There are three ways to upload the data with web, client or web service. It traces the receipts and invoices by binding the tracing codes with the bill numbers. It uses BI to implement the report analysis and report warning. It helps different departments to communicate by message distribution and message response.The first chapter researches the functions of tracing system, the significance of the drug and food tracing system and the development of the current tracing system. In our country, there are many food tracing systems which trace the food from the farmland to the table. With the accident of poisoned powered milk, there are more cares of the food security than before. It is similar between drug and food in many cases, so a strong drug tracing system is also a big safeguard for our people.The second chapter researches the related technology of this paper. Currently, web service is based on the standard of XML. WSDL is in charge of describing the web services. SOAP is in charge of transforming the web services. UDDI is in charge of describing, discovering and integrating the web services. The developing of web service is just like the C/S developing. It includes registering/calling, message transmission and reference type mapping. SAP NetWeaver includes integrated application part and developing part. Application server is the basis of the whole architecture. Portal is in charge of integrating the people. BI is in charge of report analysis and report warning. MDM is in charge of main data management. Web Dynpro is in charge of interface designing and ABAP is the main developing language in SAP.The third chapter describes the situation of the project survey. Currently there is no system for the drug wholesale companies to upload the data to the drug administration department. The level of IT application of the drug companies is different. There are professional people in charge of data uploading in most companies. Most companies would like to use web and client to upload the data. With the development of IT application, more companies will choose web service to upload the data.The fourth chapter researches how to design and implement the system, especially the client system. Web service is the most important interface in this system. The client of the system is based on web services. The functions include data uploading, data adjustment, data correspondence, data checking and message management. The two ways of data uploading are excel file uploading and manual uploading. Data checking includes data type checking, data range checking, drug data correspondence checking, customer data checking, warehouse input and output type checking and necessary items checking. It shows the error message when checking is failed. Message management model reads message from the server and replies to it if it is necessary. The client system is made of three levels which include interface level, business level and data level. It builds local database to store the drug correspondence data, customer data, warehouse input and output type correspondence data and edition data. It updates the data with web service interface. It will reduce the frequent access of the server and the burden of the server when data is checked.The fifth chapter describes the test and implement of the project. It uses the interface test to check the interface and the period test to check the functions about the time. It uses different right and wrong cases to check every function. It uses multi-transaction and multi-user pressure test to check the capability of the hardware and the software. Then deploy the hardware and network and train the end users and make the user manual.The sixth chapter summarizes the paper and looks forward the work what should do in the future. This paper has realized the functions of data uploading, data management, data analysis, data warning and data evaluation. It will implement the tracing of the drug manufacturer and the evaluation of the companies.