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

Dynamic internal for uplaoding diff excel sheets data

Former Member

‎2009 Dec 02 1:56 PM

0 Likes
465

Hi all,

I am uploading different excel data into SAP. I want to use one internal table for 3 excel sheets data . I know how to upload the data using the fucntion module ALSM_EXCEL_TO_INTERNAL_TABLE.

I will upload only 1 excel sheet every time.

regards,

Ajay

2 REPLIES 2
Read only

Former Member

‎2009 Dec 02 2:07 PM

0 Likes
425

Hi Ajay,

It would be better if you could merge them into an excel sheet with multiple worksheets & then upload them using OO ABAP concept.

Refer below link :-

[http://wiki.sdn.sap.com/wiki/display/Snippets/ReadmultiplesheetsofanExcelfileintoSAPthroughABAP]

Regards

Abhii

Read only

Former Member
In response to Former Member

‎2009 Dec 02 2:28 PM

0 Likes
425

Hi Abhi,

I will upload only one excel data at a time . I have 3 different types excel data.

For example :

1 st excel sheet having 2 fields,

2 nd excel sheet having 4 fields,

3 rd excel sheet having 6 fields.

Instead of using every time the same function module, How can write that Subroutine to use diffent structures.

regarsds,

Ajayreddy

Edited by: Ajay reddy on Dec 2, 2009 3:51 PM