Application Development 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Is it possible to download to excel when a report running in background

Go to solution
Former Member

‎2008 Jan 21 6:47 AM

0 Kudos
216

Dear All,

I tried to execute one ALV report in foreground and background. In foreground the report is giving excel download but in background no excel download is coming. Is there any specific reason for that?

Thanks and regards,

Atanu

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎2008 Jan 21 6:54 AM

0 Kudos
103

Hi,

Downloading data to presentation server is possible only in foreground , not in background. In background you can download data to application server using OPEN DATASET,

TRANSFER

CLOSE DATASET.

6 REPLIES 6

Go to solution
Former Member

‎2008 Jan 21 6:48 AM

0 Kudos
103

Yes Atanu in background you cannot download your data into Excel or in any format

ALL the FM which are used for file processing on presentation server will not work in background.

Go to solution
Former Member

‎2008 Jan 21 6:54 AM

0 Kudos
104

Hi,

Downloading data to presentation server is possible only in foreground , not in background. In background you can download data to application server using OPEN DATASET,

TRANSFER

CLOSE DATASET.

Go to solution
Former Member

‎2008 Jan 21 7:02 AM

0 Kudos
103

Yes you can download Excel sheet when running the program in the Background.

check the status of your program if it got aborted for some reason see what Job Logs also says .

Go to solution
Former Member
In response to Former Member

‎2008 Jan 21 7:07 AM

0 Kudos
103

Hi Rachana,

The program has successfully executed and the output is coming in background. But no report dump to excel has come. I do not think it can be downloaded.

Thanks and regards,

Atanu

Go to solution
Former Member

‎2008 Jan 21 7:03 AM

0 Kudos
103

Atanu dey,

If you wnat to download excel in back ground

You have to download in application server only.

EX:

DATA : v_filepath(80) VALUE '/data/sapdata/inc/error_log/pme_br/',

c_coma VALUE ',' .

OPEN DATASET v_filepath FOR OUTPUT IN TEXT MODE.

IF sy-subrc EQ 0.

LOOP AT i_errors_bat.

CONCATENATE i_errors_bat-plant c_coma

i_errors_bat-zzvendor c_coma

INTO v_string.

TRANSFER v_string TO v_filepath.

ENDLOOP.

CLOSE DATASET v_filepath.

Note : you can download in presentation server also.

but it requires lot of authorizations and have to use

FTP commands.

Reason is Apllication server in back ground has to

recognize the from which system request came.

Better go for OPEN DATA sets.

Don't forget to reward if useful.....