topic Re: Handler between SAP and Excel in Application Development and Automation Discussions

Handler between SAP and Excel

Former Member — Tue, 09 Oct 2007 05:01:56 GMT

Hi Experts,

I am trying to pass the values from MS-Excel to SAP through handler or i don't know what i will use i am mentioning the requirement below:

I have opened MM01 transaction in backend and i want to pass the material number from Excel sheet means

First i will keen the material number in excel sheet and then if i will press enter or if i will press any command button whatever then i want that value in material number field in SAP??

How to do that.....

reward points for good answers*. Thanks.

Rajneesh Gupta

Re: Handler between SAP and Excel

Former Member — Tue, 09 Oct 2007 05:09:08 GMT

From what I understood,I would propose the following:

save excel as txt file.

Use gui_upload to get the file data from file to an internal table.

And then use any of the BDC methods like call transaction or session method

Re: Handler between SAP and Excel

Former Member — Tue, 09 Oct 2007 05:15:27 GMT

Rajneesh,

I am not quite sure if your requirement is to pass the material number to MM01 only. let me tell you how you can access the Excel cell values from SAP -

1. You can write a piece of code in ABAP for reading the cell values of Excel, ( by means of OLE calls - u can have a look at the transaction OLE for assistance.

2. If you are interested in calling SAP functions from Excel, then you will have to find out a RFC enabled FM for your task and you will call that FM from Excel, for this u need a guy who understands ABAP as well as VBA.

3. Try using Scripting methods in SAP if you want to do it parallelly. (You can refer to http://www.synactive.com for releated docs.)

Re: Handler between SAP and Excel

Former Member — Tue, 09 Oct 2007 05:23:10 GMT

hi rajnessh,

this might help you :

try using 'ALSM_EXCEL_TO_INTERNAL_TABLE' to get data from excel sheet to SAP, and then you can use BDC to use it for mm01 tcode.

Message was edited by:

ritika malhotra

Re: Handler between SAP and Excel

Former Member — Tue, 09 Oct 2007 06:29:15 GMT

hi,

use the 'ALSM_EXCEL_TO_INTERNAL_TABLE' function module to download data into the internal table....

regards

sree

Re: Handler between SAP and Excel

Former Member — Tue, 09 Oct 2007 06:36:17 GMT

Hi,

Check the following link:

http://sap-img.com/abap/upload-direct-excel.htm

Regards,

Bhaskar