Application Development 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: 

Connection for Excel file

Former Member

‎2014 May 07 2:47 AM

0 Kudos
169

Hi everyone,

I am new to ABAP and i have some questions to ask.

Here is the situation.

My client want SAP data to update automatically from excel file from another computer daily.

1. I know somehow we can get data from excel to internal table and to sap table.

2. I can use SM36 to do the background process, so i can run the update daily.

Here is my real question:

1.  i use FM ALSM_EXCEL_TO_INTERNAL_TABLE to get the data, but the ROW and Column are difficult to adjust. Is there any other ways i can get the        data to internal table and to SAP table?

2. How can i connect sap to another computer to take the excel file? is it possible?

4 REPLIES 4

former_member129652
Active Participant

‎2014 May 07 3:28 AM

0 Kudos
115

Hi,

Put the file on a FTP server.  Run a report in background to retrieve files from FTP server.  However, you'd better use csv file instead of excel file.  The reason is that ALSM_EXCEL_TO_INTERNAL_TABLE only works in foreground.

Former Member
In response to former_member129652

‎2014 May 07 4:20 AM

0 Kudos
115

Thanks.

However, my client has no FTP server. The file is on the end user computer.

One more problem is that i am having trouble with ALSM_EXCEL_TO_INTERNAL_TABLE.

i can get the data to internal table which is "DATA IT TYPE TABLE OF ALSMEX_TABLINE", but how can i transfer data from IT to my ZTABLE since the IT have only 3 fields which are ROW, COL, and VALUE?


How can i transfer data from internal table using ALSM_EXCEL_TO_INTERNAL_TABLE to my ZTABLE?


Former Member
In response to former_member216914

‎2014 May 07 4:20 AM

0 Kudos
115

Thanks.

However, my client has no FTP server. The file is on the end user computer.

One more problem is that i am having trouble with ALSM_EXCEL_TO_INTERNAL_TABLE.

i can get the data to internal table which is "DATA IT TYPE TABLE OF ALSMEX_TABLINE", but how can i transfer data from IT to my ZTABLE since the IT have only 3 fields which are ROW, COL, and VALUE?


How can i transfer data from internal table using ALSM_EXCEL_TO_INTERNAL_TABLEto my ZTABLE?