topic Re: Queries: Problem creating file in background in Application Development and Automation Discussions

Queries: Problem creating file in background

former_member379910 — Fri, 26 Oct 2007 08:21:40 GMT

Hi,

i am trying to create txt files in background with sap queries, but it doesn't work.

In dialog mode it works but not in background. Path is my standard application server path /home/data/..

Any ideas?

Thanks!

Re: Queries: Problem creating file in background

Former Member — Fri, 26 Oct 2007 08:28:01 GMT

If you paste your code we may try to find.

Regards,

Atish

Re: Queries: Problem creating file in background

former_member379910 — Fri, 26 Oct 2007 08:30:57 GMT

It's the standard SAP Query (SQ01) with option "File Store".

Thanks for the fast reply.

Re: Queries: Problem creating file in background

Former Member — Fri, 26 Oct 2007 12:07:55 GMT

actually what's your question ....

the output report have u taken ???

do u want that output format in any formats???

Re: Queries: Problem creating file in background

Former Member — Fri, 26 Oct 2007 12:12:26 GMT

Hi,

In the report output. u have an option called EXPORT at the tool bar by using that u can specify the back ground...

Re: Queries: Problem creating file in background

former_member379910 — Fri, 26 Oct 2007 12:29:36 GMT

I have a query (SQ01) and want to save the results into a file.

When i run this query in background it doesn't create a file on the application server (/home/data/...). Any ideas?

Re: Queries: Problem creating file in background

Former Member — Fri, 26 Oct 2007 13:49:50 GMT

I have the same problem.

On another thread, it said it's not possible to do in background.

The File Store Option is only for execution in dialog mode.

Can somebody confirm or inform it ?

One solution is to activate an user exit!

Implement the user-exit to download the results of standard queries (SQ01) to application servers, while being run in a background.

First create a project, then use the enhancement assignment to include SQUE0001 SAP Query: Private data file. Further implement the user exit EXIT_RSAQEXCE_001 in the component section. Include ZXQUEU01 can have your code.

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/what-does-it-take-to-run-a-sap-query-in-the-background-mode-1258275

Thanks,

David de Limelette

Message was edited by:

David de Limelette

Re: Queries: Problem creating file in background

Former Member — Fri, 26 Oct 2007 14:20:38 GMT

You can create files in background jobs easily on the application server, but not the presentation server (PC).

Rob

Re: Queries: Problem creating file in background

Former Member — Fri, 26 Oct 2007 14:28:53 GMT

Rob,

Indeed we can create files in background on the application server, but not from Queries !

David

Re: Queries: Problem creating file in background

Former Member — Fri, 26 Oct 2007 14:31:25 GMT

OK - I meant in general, but that's good to know about queeries.

Rob