topic Re: query result in application server as a .CSV file in Application Development and Automation Discussions

query result in application server as a .CSV file

Former Member — Thu, 29 Jul 2010 08:40:10 GMT

Can any one tel me how can i place the query result in application server as a .CSV file.

when am executing WRITEQUERY program it asking query name and displaying result in excel sheet, i don't what is next step to keep file in app server.

read writequery prog,it is genrated in excel sheet, now i need to send that data to application server path in csv format

actually i am not able to get the internal table in writequry where the query data is stored.

please provide me the sample code i can understand. plz.

plz do favour for me, take this high priority and asap.

Thanks a lot

Former Member — Thu, 29 Jul 2010 08:46:02 GMT

Hi Sara,

Check this link, this a very good link that should help you out.

[ABAP Query|http://jelajahsap.files.wordpress.com/2008/01/abap-query.pdf]

Former Member — Thu, 29 Jul 2010 12:18:45 GMT

HI,

Actually i don't want how to create abap querey,

My requirment is, WRITEQUERY program wherenever we r excuting it vil display qurery data in excel format,

now i don't want any excel format display, I need that data, should go to application server in .CSV format.

Actually i am not understanding writequere program, in that which internal table i have to pass application server.

PLz give me reply anyone

Help me out .

Former Member — Thu, 29 Jul 2010 12:34:18 GMT

Hi,

Write a program which will pick the excel file from your location and upload it to application server at desired location.

Run the two programs in a bath job as 2 different steps.First the WRITEQUERY and then the new program. You will get what is desired.

Thx