Data Downloads to Excel Made Simple with SAP's Desktop Office Integration (DOI) — A Programmer's Guide

  • by Philip Bremner, Contract Programmer, Visual SAP
  • May 15, 2001
Downloading data from SAP is usually done by displaying the data in the SAP Data Browser and using SAP's list-saving functionality to transfer the displayed data to a file on the client computer. Unfortunately, the Data Browser display is limited to 255 characters, often forcing users to be very selective about which and/or how many columns of data they choose for display. You can circumvent these restrictions for your users by combining the Data Browser with SAP's Desktop Office Integration (DOI) data transfer functionality to provide dynamic data selection and downloading capabilities to Microsoft Excel. This article shows you how to provide users with the functionality to select all the data they need through the RS_TABLE_LIST_CREATE function call, dynamically create an internal table definition and load the table with user-selected data, transport the data from the server to an Excel instance on the client computer via the DOI table collection, and create the Microsoft Visual Basic code required to support data downloads.

Philip Bremner

Philip Bremner is a contract programmer at Visual SAP, where he specializes in SAP DOI, BDS, ALV Grid Control, and Control Framework programming. He has 10 years of programming experience in ABAP, Visual C++, and Visual Basic, and is a Microsoft Certified Professional holding nine Microsoft certifications. Philip currently has a B.S. in industrial engineering from the State University of New York, Buffalo, and a B.S. in computer science from California State University, Bakersfield.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.