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
Showing results for 
Search instead for 
Did you mean: 
Read only

How to save data in Excel file in Background processing

Former Member
0 Likes
1,242

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
605

Hi,

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

or

loop at itab1.

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

append itab.

endloop.

''-->delemeter

or

use that logic for splitting:

Regards,

Ramesh.

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

3 REPLIES 3
Read only

Former Member
0 Likes
606

Hi,

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

or

loop at itab1.

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

append itab.

endloop.

''-->delemeter

or

use that logic for splitting:

Regards,

Ramesh.

Read only

Former Member
0 Likes
605

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-f8c...

Hope it helps.

Regards, Dieter

Read only

Former Member
0 Likes
605

Hello,

Chekc this thread:

Hope this solve ur problem.

If useful reward.

Vasanth