sap microsoft
Download
Skip this Video
Download Presentation
SAP & Microsoft

Loading in 2 Seconds...

play fullscreen
1 / 26

office - PowerPoint PPT Presentation


  • 376 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'office' - jaden


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
sap microsoft

SAP & Microsoft

Office Integration

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

sap s integration with microsoft office products
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

integration architecture

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

architecture current

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

sap automation integration of alternative user interfaces

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

bapis and business objects

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

sap automation for ocx activex

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

activex ole
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

activex insight for sap r 3
ActiveX: Insight for SAP R/3

Insight 2.0 von Arcplan GmbH: www.arcplan.de

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

com support
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

session manager user interface
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

session manager 2
Session Manager 2

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

aktives excel reporting with excel

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

aktives excel 1
aktives Excel - 1

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

aktives excel 4
aktives Excel - 4

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

microsoft excel open information warehouse
Microsoft ExcelOpen Information Warehouse

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

integration word
Integration Word

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

sapinq
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

journal entry upload
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

sap developer program
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

ad