SAP and MS Office Integration Architecture

Integration between SAP and Microsoft products hinges upon the use of OLE, a common and standard technology for transferring and sharing information among applications. With OLE, you can take data out of your SAP system and place it into another system, all the while maintaining the format and integrity of the data. For example, you can view data residing in any number of SAP database tables as a series of columns and rows in Microsoft Excel—an easy way to view and manipulate data otherwise trapped in the SAP database.

The SAP Assistant is the OLE interface used for calling SAP functions and transactions from other non-SAP applications. The SAP Assistant exposes both ActiveX controls and OLE object ...

Get Sams Teach Yourself SAP™ in 24 Hours, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.