Skip to Content

Question: Can I see a content of a table directly in excel? Answer: Yes, with a simple code of VB for application.

Here an article to define some simple macro and related function module in the back-end system SAP. Read any SAP Table from Excel

Question: Is there a method to use Excel directly like an SE16 transaction? Answer: Yes, but you need to define more complex functions macros to manage selection of the data and to render the data in the appropriate format.

The real scope of this contribute is not to replicate the SE16 in excel but to take confident with the VB in excel and how is simple to call SAP function. An example of result with table T005 (country):

image

Note that in the article there is the possibility to log-on directly to different systems and so to compare the result directly in excel.

image

….. PS in the article I missed the declaration of structure ZCHAR1250. Here the definition:

image

 

UPDATE (13/09/2007):

The function TABLE_ENTRIES_GET_VIA_RFC is a good example to retrive data with this macros without implement ABAP (function or structure).

Take care that the function is not builded to retrive data. The function module is only intended for internal use in the ALE area see note 881127.

To read simply and short table you can use this function. But for more complex query, you can define a custom function that encapsulate that.

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

    1. Mehmet Avsar
      Could you upload your excel file in any place. When I try making your excel comments it doesn’t run. It give object-defined error at sapconnection.
      (0) 
    1. Sergio Locatelli Post author
      You’re right. It miss in the article.
      I’ll update as soon as possible.
      In any case the definition of the structure is of only one field with data element CHAR1250.

      Regards

      (0) 

Leave a Reply