topic Re: Save query to file path in Application Development and Automation Discussions

Save query to file path

Former Member — Thu, 27 Nov 2008 08:54:04 GMT

Folks,

I've setup a query and this query is stored to file. I've specified the path but is it possible to have the name of the file being the date?

Regards,

MdZ

Re: Save query to file path

Former Member — Thu, 27 Nov 2008 09:03:28 GMT

Concatenate the file name with sy-datum.

u will get

Regards

Re: Save query to file path

Former Member — Thu, 27 Nov 2008 09:18:25 GMT

Hi mate,

Would you be able to explain a little bit further?

Regards,

MdZ

Re: Save query to file path

Former Member — Thu, 27 Nov 2008 09:28:48 GMT

Give me the file name that u r giveing

or for example say file name is ABCD

DATA: name(20) type c value 'ABCD'.

DATA: filename

CONCATENATE name sy-datum INTO filename.

and pass this filename as ur actual file name

Edited by: Rasheed salman on Nov 27, 2008 10:29 AM

Re: Save query to file path

Former Member — Thu, 27 Nov 2008 09:43:57 GMT

Thanks again, where do I put this statement?

Regards,

MdZ

Re: Save query to file path

Former Member — Thu, 27 Nov 2008 09:52:37 GMT

Hi,

where r u giving ur file name to save the file put the statement there

Regards

Re: Save query to file path

Former Member — Thu, 27 Nov 2008 09:58:12 GMT

Hi,

I did not put any coding in yet, I can put a file name or file path in the selection screen after executing the query. Do I need to put in coding in the infoset?

Regards,

MdZ

Re: Save query to file path

Former Member — Thu, 27 Nov 2008 10:07:49 GMT

u mean tht u r giving file name in the selection screen and the file z saving with that name.

Regards

Re: Save query to file path

Former Member — Thu, 27 Nov 2008 10:53:43 GMT

Yes, but if I am understanding you correctly, this will not allow me to put a variable name in the file.

Regards,

MdZ

Re: Save query to file path

Former Member — Fri, 28 Nov 2008 07:22:51 GMT

Folks,

I've put the report name in a job and scheduled it. After running, it gets stuck in the spool. Anyone any suggestion how to save the result of the query automatically to a certain file path?

Thanks.

Re: Save query to file path

Former Member — Fri, 28 Nov 2008 07:28:02 GMT

u r giving file name in the pramater then give the paramater as default date as sy datum and make it as noneditable.

Regrads

Rasheed