Sap microsoft
Download
1 / 26

office - PowerPoint PPT Presentation


  • 376 Views
  • Updated 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) Microsoft COM

  • 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 Microsoft COM

Insight 2.0 von Arcplan GmbH: www.arcplan.de

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


Com support
COM Support Microsoft COM

  • 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 Microsoft COM

  • 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 Microsoft COM

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


Aktives excel reporting with excel

Gewinn- und Verlustrechnung Microsoft COM

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 Microsoft COM

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


Aktives excel 4
aktives Excel - 4 Microsoft COM

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


Microsoft excel open information warehouse
Microsoft Excel Microsoft COMOpen Information Warehouse

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


Integration word
Integration Word Microsoft COM

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


Sapinq
SAPInq Microsoft COM

  • 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 Microsoft COM

  • 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 Microsoft COM

  • 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