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

how can i store csv file into application server

former_member223446
Active Participant

‎2007 Dec 18 9:21 AM

0 Likes
565

hi dudes

i have csvfiel(excel file) at my desktop.i have to store it into application server.Fm is sap_convert_to_csv_format.

data of excel file is like this

send the code.it is urgent.

kiran

Edited by: kiran jagana on Dec 18, 2007 11:33 AM

hi dudes

i have csvfiel(excel file) at my desktop.i have to store it into application server.Fm is sap_convert_to_csv_format.

data of excel file is like this

send the code.it is urgent.

kiran

Edited by: kiran jagana on Dec 18, 2007 11:33 AM

Reply
2 REPLIES 2
Read only

Former Member

‎2007 Dec 18 10:13 AM

0 Likes
516

Hi,

you can use method GUI_UPLOAD from class CL_GUI_FRONTEND_SERVICES to achieve that.

Regards

Mark-André

Read only

meikandan_krishnan2
Participant

‎2007 Dec 18 10:51 AM

0 Likes
516

hi ,

The function module sap_convert_to_csv_format, converts the internal table to CSV file and download to the local server.

CSV file is nothing but a "Comma Delimited" file.

Test : Save a excel file as CSV and the open with notepad .

U can see the file with comma separated.

So create an internal table with line type as Char1000 or anything related to that . Then loop the original internal table and concatenate all the records separated by "comma".

Eg: Concatenate itab-f1

itab-f2

into wa-line separated by ','.

then tranfer the data to the application server.

Save the file with ".CSV" extension.

Please reward if it helps.

Regards

Meikandan