Skip to Content
0
Former Member
Jul 03, 2009 at 12:13 PM

Help me out working with excel sheet with multiple worksheets, need help

41 Views

Hi Gurus, I got a requirement to uploading the data from Excel sheet with multiple worksheets, i followed the below given process and want to know how to move the data from i_data(contains row, col, and value) into the internal table, I have 4 sheets in my excel file, i am getting the data into i_data for every sheet, but the thing is for each and every sheet i will have roughly 50 to 60 fields, please suggest me in this regards. After moving the data into the internal tables, i have to build BAPI structure which i have to pass to the BAPI BAPI_SALESORDER_CREATEFROMDAT2 PLease suggest me of how to build the internal to pass the data. Code as follows : In the code i have taken only few fields(6) in the structure .