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

How to call ABAP programs from Excel

former_member6356
Advisor
Advisor

‎2006 Dec 30 3:32 AM

0 Likes
1,892

Hello everyone,

Currently I'm investigating the integration of Excel and ABAP program. I find it's easy to call Excel from ABAP program, but does anyone of you know how I can first open and do some actions in an Excel sheet first, and then, for example, when I press the save button, the data will be transferred back to ABAP system? I think when openning the Excel, the logon of the backend system is needed.

I've ever seen this functionality in some BW-reporting tools, but I cannot remember the details.

Thank you very much and best regards,

Leon

Hello everyone,

Currently I'm investigating the integration of Excel and ABAP program. I find it's easy to call Excel from ABAP program, but does anyone of you know how I can first open and do some actions in an Excel sheet first, and then, for example, when I press the save button, the data will be transferred back to ABAP system? I think when openning the Excel, the logon of the backend system is needed.

I've ever seen this functionality in some BW-reporting tools, but I cannot remember the details.

Thank you very much and best regards,

Leon

Reply
6 REPLIES 6
Read only

Former Member

‎2006 Dec 30 3:52 AM

0 Likes
1,443

Hi Leon

Though we can not call ABAP programs directly, we do have the functionality of RFC's in SAP. Hence an RFC can be called which can internally revoke an ABAP program via SUBMIT statement.

In excel we can create a macro or design a form and code to call an RFC from EXCEL, this is definetely possible.

Kind Regards

Eswar

Read only

suresh_datti
Active Contributor

‎2006 Dec 30 4:02 AM

0 Likes
1,443

Pl take a look at this <a href="https://forums.sdn.sap.com/click.jspa?searchID=561454&messageID=1955435">Thread</a>

~Suresh

Read only

abhijitzope
Active Participant

‎2006 Dec 30 4:16 AM

0 Likes
1,443

Hi Leon,

i thing this blog may useful to you.

<a href="/people/sergio.locatelli2/blog/2006/12/14/read-any-sap-tables-from-excel:///people/sergio.locatelli2/blog/2006/12/14/read-any-sap-tables-from-excel

Abhijit

Read only

Former Member

‎2006 Dec 30 4:19 AM

0 Likes
1,443

Another link which may help for some understanding:

Regards

Eswar

Read only

Former Member

‎2006 Dec 30 4:31 AM

0 Likes
1,443

yes in BW we are having this concept of creating wookbooks & queries.

If u have BW server Go to Transaction RRMX - u will get a Microsoft Excel sheet.

Here it allows u to logon to the SAP system.

For details see this link.

<a href="https://forums.sdn.sap.com/click.jspa?searchID=561476&messageID=2553631">https://forums.sdn.sap.com/click.jspa?searchID=561476&messageID=2553631</a>

<a href="https://forums.sdn.sap.com/click.jspa?searchID=561476&messageID=519862">https://forums.sdn.sap.com/click.jspa?searchID=561476&messageID=519862</a>

Read only

former_member6356
Advisor
Advisor

‎2006 Dec 30 5:33 AM

0 Likes
1,443

Thank you guys.

But I have another concern: it seems that your mentioned solutions may need to have SAPGui installed, but in the future if user only access SAP thru IE (using WebDynpro) and there is no SAPGui installed, could these solutions still work out?

Thanks and best regards,

Leon