topic Re: How to save data in Excel file in Background processing in Application Development and Automation Discussions

How to save data in Excel file in Background processing

Former Member — Tue, 06 Mar 2007 07:09:58 GMT

Hi,

I have one report program which produces a report of sales orders. I want that transaction to run every night in background(without manual interface) and output list should get saved in Excel file on my PC.

Regards,

Darshana

Re: How to save data in Excel file in Background processing

Former Member — Tue, 06 Mar 2007 14:17:45 GMT

Hi,

you can move the file to your prez server using transaction ..CG3Y.

loop at itab1.

SPLIT itab1 AT '' INTO itab-field1 itab-field2 itab-field3 .

append itab.

endloop.

''-->delemeter

use that logic for splitting:

Regards,

Ramesh.

Re: How to save data in Excel file in Background processing

Former Member — Tue, 06 Mar 2007 14:26:48 GMT

Hi Darshana,

normaly it doesn't work in background,

But there is one solution shown by Srilatha Thirukkovalluri.

Here the link:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/9831750a-0801-0010-1d9e-f8c64efb2bd2

Hope it helps.

Regards, Dieter

Re: How to save data in Excel file in Background processing

Former Member — Tue, 06 Mar 2007 14:31:39 GMT

Hello,

Chekc this thread:

Hope this solve ur problem.

If useful reward.

Vasanth