Kelly,
"Where" your data comes from depends on your application. What is it that you need to do. Do you need to create a sales order from data which is coming from an old legacy system? Do you have to create a sales order from data which is collected via a java iView. Every application is different.
In the case where one needs to upload sales orders from a legacy system, your data would need to come from that legacy system in the form a flat file, delimited file, or excel sheet. Then using LSMW, you would read this file in, and use it to create your sales orders via standard upload programs, recordings, idocs, or BAPIs.
If you needed to create a sales order from a web application, then you would use a BAPI in your java class. Your web frontend would get the data from the user, and in your program, you would build the interface to the BAPI(this means taking the data from the user and putting it in the import/export/tables parameters of the bapi) and call the BAPI. This would create your sales order in R/3.
You can "upload" data from an excel sheet, what we usually do is same the data as a comma delimited excel file. LSMW will be able to handle the parsing of the records.
Regards,
Rich Heilman
- SAP Managed Tags:
Please try using the following class/method. I'm sure that this will work for you.
types: begin of t_excel,
field1(20) type c,
field2(20) type c,
field3(20) type c,
field4(20) type c,
field5(20) type c,
field6(20) type c,
field7(20) type c,
field8(20) type c,
field9(20) type c,
field10(20) type c,
field11(20) type c,
field12(20) type c,
end of t_excel.
data: i_excel type table of t_excel.
call method cl_gui_frontend_services=>gui_upload
exporting
filename = file
has_field_separator = 'X'
changing
data_tab = i_excel
exceptions
others = 22.
Regards,
Rich Heilman
- SAP Managed Tags:
Strange....this code worked great for me.
Can you post your small program. Maybe I can take a look and see whats up.
Regards,
Rich Heilman
- SAP Managed Tags:
Yes, using my sample code above, I uploaded an excel file with 5 fields and 5 rows into internal table with 5 fields. All data was as it was in the excel sheet.
Of course, now I can't get it to work again. I am seeing the same problem as you. Great!
Regards,
Rich Heilman
Message was edited by: Rich Heilman
- SAP Managed Tags:
Ok, I see why it worked for me. I was downloading data to excel using GUI_DOWNLOAD, then uploading using the GUI_UPLOAD. Must be the way GUI_DOWNLOAD writes the data to excel. Install the sample program. You will see what I mean. Enter a file path and execute, program will write the file, now click the upload radiobutton and execute, progam will read the file back and write it to list display.
types: begin of t_excel,
field1(20) type c,
field2(20) type c,
field3(20) type c,
field4(20) type c,
field5(20) type c,
field6(20) type c,
field7(20) type c,
field8(20) type c,
field9(20) type c,
field10(20) type c,
field11(20) type c,
field12(20) type c,
end of t_excel.
data: i_excel type table of t_excel.
data: x_excel type t_excel.
data: file type string.
parameters: p_file type localfile.
parameters: p_down radiobutton group grp1 default 'X',
p_up radiobutton group grp1.
at selection-screen on value-request for p_file.
call function 'KD_GET_FILENAME_ON_F4'
exporting
static = 'X'
changing
file_name = p_file.
start-of-selection.
if p_down = 'X'.
x_excel-field1 = 'A1'.
x_excel-field2 = 'A2'.
x_excel-field3 = 'A3'.
x_excel-field4 = 'A4'.
x_excel-field5 = 'A5'.
append x_excel to i_excel.
x_excel-field1 = 'B1'.
x_excel-field2 = 'B2'.
x_excel-field3 = 'B3'.
x_excel-field4 = 'B4'.
x_excel-field5 = 'B5'.
append x_excel to i_excel.
x_excel-field1 = 'C1'.
x_excel-field2 = 'C2'.
x_excel-field3 = 'C3'.
x_excel-field4 = 'C4'.
x_excel-field5 = 'C5'.
append x_excel to i_excel.
file = p_file.
call method cl_gui_frontend_services=>gui_download
exporting
filename = file
write_field_separator = 'X'
changing
data_tab = i_excel
exceptions
others = 22.
elseif p_up = 'X'.
file = p_file.
call method cl_gui_frontend_services=>gui_upload
exporting
filename = file
has_field_separator = 'X'
changing
data_tab = i_excel
exceptions
others = 22.
loop at i_excel into x_excel.
write:/ x_excel.
endloop.
endif.
Regards,
Rich Heilman
- SAP Managed Tags:
From external systems, in our case, we generated text files from our Legacy AS/400 system, then upload these text files into SAP using LSMW.
Regards,
Rich Heilman
- SAP Managed Tags:
