Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

VBA code to interface excel with SAP (transfer data from SAP to excel)

Former Member

‎2009 Aug 18 4:56 PM

0 Likes
649

Hi ABAPers,

I currently have knowledge of using the function u2018RFC_CALL_TRANSACTIONu2019 in Excel VBA to upload data into SAP screens from an excel sheet.

What I am looking for is how to read the same data from SAP screens. Please note that u2018RFC_READ_TABLEu2019 would not work in all cases as we have some data which are stored in structures and not tables.

Please note I am looking for solutions in Excel VBA only as I have little or no exposure to ABAP.

Hope someone can help me with the correct function module to use to read the data from SAP transactions (VA23/VA43 etc).

Even better if you can share sample code. thanks.

Regards,

Krishna Kumar

Edited by: Krishna Kumar on Aug 18, 2009 5:57 PM

Hi ABAPers,

I currently have knowledge of using the function u2018RFC_CALL_TRANSACTIONu2019 in Excel VBA to upload data into SAP screens from an excel sheet.

What I am looking for is how to read the same data from SAP screens. Please note that u2018RFC_READ_TABLEu2019 would not work in all cases as we have some data which are stored in structures and not tables.

Please note I am looking for solutions in Excel VBA only as I have little or no exposure to ABAP.

Hope someone can help me with the correct function module to use to read the data from SAP transactions (VA23/VA43 etc).

Even better if you can share sample code. thanks.

Regards,

Krishna Kumar

Edited by: Krishna Kumar on Aug 18, 2009 5:57 PM

Reply
1 REPLY 1
Read only

former_member876464
Explorer

‎2009 Aug 27 1:23 PM

0 Likes
434

Hi,

you try to use BAPISDORDER_GETDETAILEDLIST.

Regards.

Paolo Ardemagni