1 / 26

SAP & Microsoft

SAP & Microsoft. Office Integration. SAP's Integration with Microsoft Office Products. Travel Expenses: Microsoft Access construction parts: Microsoft Excel Consolidation: Microsoft Access/Excel Human Resources: Microsoft Word Customizing: Microsoft Word

jaden
Download Presentation

SAP & Microsoft

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SAP & Microsoft Office Integration www.microsoft.com/germany/partner/sap/us

  2. SAP's Integration with Microsoft Office Products • Travel Expenses: Microsoft Access • construction parts: Microsoft Excel • Consolidation: Microsoft Access/Excel • Human Resources: Microsoft Word • Customizing: Microsoft Word • Scheduling: Microsoft Visual Basic • XXL Listviewer: Microsoft Excel • R/3 Help: Microsoft Help Compiler • Startup of Excel/Word out of the R/3 Application www.microsoft.com/germany/partner/sap/us

  3. SAP Automation SAP Automation Presentation Server SAP Automation Application Server ODBC Database Server Desktop Standard Applications Customer-specific Applications R/3 Integration Architecture www.microsoft.com/germany/partner/sap/us

  4. COM COM SAP Assistant BOR Component COM GUI CodeGen Transaction Component COM GUI Component RFC Class Library COM RFC Component RFC Library GUI Library R/3 Architecture - Current www.microsoft.com/germany/partner/sap/us

  5. SAP Automation for intelligent user interface programming User Solution SAP Automation for OCX (ActiveX) programming • Excel • Internet Browser • Telephonyapplication • Kiosk solution(touch screen) • ... R/3 Application Server SAP Automation for RFC programming SAP Automation: Integration of Alternative User Interfaces www.microsoft.com/germany/partner/sap/us

  6. R/3 Application Purchase Order BAPI Broker R/3 Application, SAP Business Workflow Purchase Requisition BAPI CORBA Server CORBA Client (under development) CORBA communication BAPI Material Business Object Repository Visual Basic, Excel, MS Project, ... BO OCX R/3 Database COM / DCOM Internet Explorer, Netscape, ... R/3 InternetApplication HTML BAPIs and Business Objects www.microsoft.com/germany/partner/sap/us

  7. SAP Automation to integrate desktop applications based on Microsoft COM R/3 Application Server OLE Autom. (e.g. VB) Logon OCX Table OCX Remote Function Call (LIBRFC) Applications (e.g. Excel) OLE Custom Controls View OCX C++ Functions OCX R/3 Funktion Library R/3 can act as OLE-client and as OLE-server SAP Automation for OCX/ActiveX www.microsoft.com/germany/partner/sap/us

  8. ActiveX (OLE) • Today: Integration via RFC • Future: Replacement of RFCs with ActiveX Controls (R/3 4.0 Q3/Q4 1997) • R/3 will directly support ActiveX Interfaces: • ABAPs directly call ActiveX Server Objects • R/3 directly export ActiveX Objects • SAP’s Strategy: further exploit NT Standard Functionality www.microsoft.com/germany/partner/sap/us

  9. ActiveX: Insight for SAP R/3 Insight 2.0 von Arcplan GmbH: www.arcplan.de www.microsoft.com/germany/partner/sap/us

  10. COM Support • COM supported Components • RFC Component • GUI Component • Transaction Component • BOR Component • SAP Assistant • Delivers Language neutral access • Delivers object-oriented programming www.microsoft.com/germany/partner/sap/us

  11. Session Manager User Interface • Navigating in R/3 Systems is more straightforward • User-specific requirements • List of the most frequently used transactions • Different settings for the screen layout (column width, font, etc.) • Transactions start up immediately • Double-click • Drag and drop • It is possible to work in more than one R/3 System Frontend: Windows 95 oder Windows NT 3.51 www.microsoft.com/germany/partner/sap/us

  12. Session Manager 2 www.microsoft.com/germany/partner/sap/us

  13. Gewinn- und Verlustrechnung 1 2 3 A Erlöse B 50 C Excel Spain 4% USA 50% Switzerland 21% France 10% Germany 15% active connection automatic update R/3 FI-LC changes R/3 Aktives Excel: Reporting with Excel www.microsoft.com/germany/partner/sap/us

  14. aktives Excel - 1 www.microsoft.com/germany/partner/sap/us

  15. aktives Excel - 4 www.microsoft.com/germany/partner/sap/us

  16. Microsoft ExcelOpen Information Warehouse www.microsoft.com/germany/partner/sap/us

  17. Integration Word www.microsoft.com/germany/partner/sap/us

  18. SAPInq • End User PO, Invoice, Delivery Inquiry • Receptionist Inquiry for Goods Delivery • Reduce inquiries to AP Helpdesk • Moving to Web with MSMarket • No training • Easy install www.microsoft.com/germany/partner/sap/us

  19. www.microsoft.com/germany/partner/sap/us

  20. www.microsoft.com/germany/partner/sap/us

  21. www.microsoft.com/germany/partner/sap/us

  22. www.microsoft.com/germany/partner/sap/us

  23. Journal Entry Upload • Excel Based JE Front End • Replaced Functionality used in Legacy Systems • On-line Validation • Rolled Out WW • 125,000 line items per month www.microsoft.com/germany/partner/sap/us

  24. www.microsoft.com/germany/partner/sap/us

  25. www.microsoft.com/germany/partner/sap/us

  26. SAP Developer Program • ISVs are encouraged to develop R/3 complementary products and add-ons based on Microsoft technology • First SAP Developers’ Conference took place in Orlando, May 15-17. Big success • Next SAP/Microsoft conference for partners or customers who do a large amount of development complementary to R/3, or adding functions, is planned for end of 1996 www.microsoft.com/germany/partner/sap/us

More Related