Projects 2000 Chem Pharm Industry Dr Jochen Winkler

Projects 2000 (Chem. / Pharm. Industry) Dr. Jochen Winkler jw. Consulting http: //www. jwconsulting. net Frankfort, 30. 11. 2000 jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 1

Content q Projects q Developments q Recipe Management q Research & Development q Actual Production Costs Accounting q B 2 B Drugs Order via XML q B 2 R Customer Information System with Browser q B 2 C Customer Order with WAP Mobile Phone jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 2

Content q Projects q Developments q Recipe Management q Research & Development q Actual Production Costs Accounting q B 2 B Drugs Order via XML q B 2 R Customer Information System with Browser q B 2 C Customer Order with WAP Mobile Phone jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 3

Projects 2000 – Chemical / Pharmaceutical Industry (1) Degussa-Hüls AG / SG Sivento, Rheinfelden n Integration in a Single Chemical System n R/3 Integrated LIMS n Produktion Planning, Control und Accounting n Actual Production Costing n Customer Data Base Information System Degussa-Hüls AG / SG Creanova, Marl n QM n jw. LIMS for Technical Synthetic Materials Infracor Gmb. H, Frankfurt n Plant Maintenance (Assistence) Oxeno Gmb. H, Marl n QM, jw. LIMS Deutsche Amphibolin Werke, Oberramstadt n Research & Development jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 4

Projects 2000 – Chemical / Pharmaceutical Industry (2) Degussa Metals Catalysts Cerdec AG n QM, jw. LIMS Goldschmidt AG n PP / PI, jw. Production n QM, jw. LIMS n Plant Maintenance, Project System Aventis Pharma Deutschland Gmb. H, Frankfurt n Drugs Order via Internet Asta Medica Gmb. H, Frankfurt n QM / LIMS, Materials Management n Vendors Evaluation AZU Pharma Gmb. H, Stuttgart n QM, jw. LIMS jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 5

Content q Projects q Developments q Recipe Management q Research & Development q Actual Production Costs Accounting q B 2 B Drugs Order via XML q B 2 R Customer Information System with Browser q B 2 C Customer Order with WAP Mobile Phone jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 6

SAP R/3 and jw. Add-ons Logistics, Standard Accounting, Standard Logistics, add-ons Accounting, add-ons SD SD Custom Waste er. Managmnt SD DB Sales MM Accou nting MM PP-PI Prod. Control. QM PP Prod. -Planning QM Batch. Man. Environ. Protect. QM Quality. Man. QM LIMS PM Act. Prod. Coasting CO Controlling Prod. -Planning Materialsman. PP-PI CO FI AM SAP R/3 Workbench Plant Maintenance Asset Man. PS Projectsystem WF Workflow IS IM Invest Man. PS R&D Support Industry Solutions HR Human Ressources jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 7

Developments 2000 - Chemical / Pharmaceutical Industry (1) jw. Chem. Lab jw. Pharm. Lab jw. Production. Planning jw. Production. Recipe. Management jw. Production. Accounting jw. Research&Development jw. Development. Recipe. Management jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 8

Developments 2000 - Chemical / Pharmaceutical Industry (2) jweb. Drugs. Order jw. Customer. Management. Info. System jweb. Customer. Management. Info. System jwap. Customer. Order jw. Actual. Production. Costs. Accounting jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 9

Content q Projects q Developments q Recipe Management q Research & Development q Actual Production Costs Accounting q B 2 B Drugs Order via XML q B 2 R Customer Information System with Browser q B 2 C Customer Order with WAP Mobile Phone jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 10

Recipe Management m Research and Development Recipe (Substance Level)) m Production Recipe (Substance Level) m R/3 Bill of Material, Routing (Material Level) jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 11

jw. Development. Recipe. Management (1) m Collection of Informations about R&D Recipes and Procedures m Assignment to R&D Projects m Relation to Lab Samples and their Results m Relation to Documents e. g. Test Reports and Diagrams m Access to Information in other R&D Departments jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 12

jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 13

jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 14

jw. Development. Recipe. Management (4) Additional Information to Recipe Tables (Header resp. Positions) m Relation of Documents m m Word, Excel, Graphics, . . . Execution of the Appropriate Application Central Storage of Documents Safety against Changing of Documents m Relation to Lab Samples m Creation of Test Orders m Access to Test Results and Documents m Storage of Prices and Costs m Calculation of Development Costs m Calculation of Recipe Costs jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 15

jw. Development. Recipe. Management (5) Additional Information to Recipe Tables m Relation to Projects in R/3 PS m Where-to-used Lists m Usage of Variants for Different R&D Stages m Status Management e. g. m m „In Development“ „Test Recipe“ „Released“ „Stopped“ m Definition of Search Criteria m Catalogue Choice m Management of Catalogues jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 16

jw. Development. Recipe. Management (6) 1. Reports m Where-to-used Lists in Projects and in Samples m Development History (Intermediate Stages) m Searches e. g. „Which Recipes belong to Waterresistant Varnishes“ 2. Integration of the Entitlement Concept 3. Transition of R&D Recipes into Production jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 17

jw. Production. Recipe. Management (1) m Easy Description of Production Recipes m Manually Created Material Masters only for Substances (Product Groups), Raw Materials, Colours and Packages m (Partly) Automatic Generation of Material Masters of Products (Product-Variant-Colour-Package Combinations) m Low Time-Consuming Recipe Management of Products with Variants in Different Colours and Packages m Distribution of Recipes to Other Plants (via XML) m (Partly) Automatic Generation of Bills of Materials and Routings at Production Planning or Production Time jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 18

jw. Production. Recipe. Management (2) m Test Plans / Specifications and Batches belong to Substances m Advantages: - Only a few Manually Created Material Masters of Products (in Different Variants, Colours and Packages) - Practice-Oriented Low-Cost Input of Production Recipes or Automatic Transition from R&D - (Partly) Automatic Generation of Material Masters, Bills of Materials and Routings - Integrated jw. Chem. Lab - Integrated jw. Production und jw. Production. Planning jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 19

Content q Projects q Developments q Recipe Management q Research & Development q Actual Production Costs Accounting q B 2 B Drugs Order via XML q B 2 R Customer Information System with Browser q B 2 C Customer Order with WAP Mobile Phone jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 20

jw. Research&Development (1) m Project Procedures m Project Description m Project Planning and Bugeting m Project Costs m Project Organisation m Project Time Table m Project Ressources m Project Control m Project Documentation and Enquiry m Project Conclusion and Accounting m Project Reports jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 21

jw. Research&Development (2) m Basis Modul PS (Project System) in SAP R/3 m Enlargement of the Standard by jw. Research&Development m Additional Structures and Functions m Separate Screens m Integration of jw. LIMS and jw. Dispensing. Management m Integration in all SAP R/3 Modules m No Modifications, Safety at Release Changes jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 22

jw. Research&Development (3) jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 23

jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 24

jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 25

Planning and Budgeting of Project Costing R&D-Budget 2001 R&D Man. (SAP R/3 -IM) Working Group A (SAP R/3 -IM) Working group B (SAP R/3 -IM) Working Group C (SAP R/3 -IM) R&D-Project (SAP R/3 -PS) R&D-Project WG Man. Proj. Man.

Document Folder R&D-Project-Folder Types of Documents Form Table Graphics Check Lists, Descriptions, Reports Calculations Statistics Graphics Chemical Formula Pictures (MS Word) (MS Excel) (e. g. CAM Windows) Ch. Baier / jw-consulting

Project Classification and Enquiry Feature Man. Source Area Product. Group Usage Merkmale Class Man. Class Projects Source Area Produktgruppe Verwendung Form. . . . . Project R&D-4711 Source : Area : Product Group Usage : Form : Customer Order : Eigenschaften Classification Object Search 1. Assignment Object R&D-4711 Class Projects 1. Search of the Entry Class 2. Evaluation of Features 2. Search of Objects via Entry Class Area Prod. Gr. Usage

jw. Research&Development (9) PS-Standard Reports Project Information System q Add. Reports by means of Add. Structures m Recipe Dates m Test Reports m Comparison with Competitional Products jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 29

Content q Projects q Developments q Recipe Management q Research & Development q Actual Production Costs Accounting q B 2 B Drugs Order via XML q B 2 R Customer Information System with Browser q B 2 C Customer Order with WAP Mobile Phone jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 30

Content q Projects q Developments q Recipe Management q Research & Development q Actual Production Costs Accounting q B 2 B Drugs Order via XML q B 2 R Customer Information System with Browser q B 2 C Customer Order with WAP Mobile Phone jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 31

jweb. Pharm. Order Affirmation Katharinenhospital Stuttgart Delivery Note Aventis Pharma Invoice Internet jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 32

Internet Einbindungen jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 33

Content q Projects q Developments q Recipe Management q Research & Development q Actual Production Costs Accounting q B 2 B Drugs Order via XML q B 2 R Customer Information System with Browser q B 2 C Customer Order with WAP Mobile Phone jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 34

jweb. Customer. Info. System (1) q Customer Dates n Administrative Dates / Adresses, . . . , Customer Profiles n Contracts n Turnover, Hit Lists, . . . Credit Limit, . . n Projects q Product Information n Product Catalogue n Price Lists n Add. Conditions (e. g. Bulk Discount, Bonus, . . . ) q Stock Information n Availability, Delivery Dates q Sales Representative Dates n Name, Adress, n Turnover, Hit Lists jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 35

jweb. Customer. Order (2) q Customer Orders n Sales Organisation, Agent n Matchcodes, Hit Lists, Sets, Up- / Cross-Selling n Order Forms, former Orders, Barcode n Prices, Conditions, Freigth, . . . n Delivery Dates n Order- / Delivery Status q Order Cancellation q Return jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 36

jweb. Customer. Order (3) q Architecture n Frontend = Browser n Middleware = Webserver n Backend = SAP R/3 q Master Dates n Master = R/3, Slave = Webserver n Daily (Customer-, Product-, Price-, Agent-, Location Information) n Immediatly (Availability, Credit Information) q Order Dates n R/3 fetches the dates from the Web Server q Data Security n Firewall, Autorisation, Coding, . . . jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 37

Honorare / Spesen q jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 38

Content q Projects q Developments q Recipe Management q Research & Development q Actual Production Costs Accounting q B 2 B Drugs Order via XML q B 2 R Customer Information System with Browser q B 2 C Customer Order with WAP Mobile Phone jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 39

jwap. Customer. Order q WML Browser – Webserver – R/3 q Screens n Product – Amount – Date n Localisation jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 40

B 2 C Kundenaufträge über WAP-Handy q jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 41

Projects 2000 (Chem. / Pharm. Industry) Dr. Jochen Winkler jw. Consulting http: //www. jwconsulting. net Frankfort, 30. 11. 2000 jw Dr. J. Winkler http: //www. jwconsulting. net 30. 11. 2000 Projects & Developments 2000 Page 42