topic Re: Need help on spooling for program run in background in Application Development and Automation Discussions

Need help on spooling for program run in background

Former Member — Thu, 13 Oct 2016 07:37:08 GMT

Hi Team, I have a Z-Report which takes 77 mins to run in background and hence I need to capture the complete output for the same in Excel. When I am trying to retrieve the output from the spool, I get only 17 columns whereas there are 32 columns in all. Need help to get the complete output in Excel sheet.

Re: Need help on spooling for program run in background

Former Member — Thu, 13 Oct 2016 09:06:21 GMT

Hi,

When you say excel. Do mean csv or xls?

How is the data being written to spool.

I have done something similar in the past, and wrote the data to the spool in a csv format.

You could write the data to a bespoke table and then download from there.

Thanks

Martin

Re: Need help on spooling for program run in background

joachimrees1 — Thu, 13 Oct 2016 09:08:44 GMT

Hi Aditya,

how about setting the "line-size" argument of the REPORT statement to the maximum (which is 1023 according to F1-help on REPORT)?

best

Joachim

Re: Need help on spooling for program run in background

former_member226519 — Thu, 13 Oct 2016 09:09:45 GMT

did you try LINE-SIZE 1023 statement?

Re: Need help on spooling for program run in background

kaus19d — Thu, 13 Oct 2016 09:17:11 GMT

Better before printing, can check in the Print-Preview, if its taking all the rows & columns in SAP

Thanks,

Kaushik

Re: Need help on spooling for program run in background

Sandra_Rossi — Thu, 13 Oct 2016 11:30:46 GMT

If you can see all columns in dialog, I guess your report is an ALV Grid (Control Framework). In background, the output switches automatically to the ABAP List mode. You may do as Volker and Joachim suggested (LINE-SIZE 1023), or you may also define the Print Parameters if you start manually the background job, and select a very wide "List Format" (you may even create one;

SAP Library: Creating List Formats).

Re: Need help on spooling for program run in background

RaymondGiuseppi — Thu, 13 Oct 2016 12:37:01 GMT

Either use a wide width (e.g. LINE-SIZE 1023) and adjust columns width to minimize width, or export the extracted internal table to some INDX-like database table (EXPORT TO DATABASE) then provide user a transaction which import back this data and display it.

Regards,

Raymond

Re: Need help on spooling for program run in background

Jelena_Perfiljeva — Thu, 13 Oct 2016 17:08:49 GMT

If it's a custom report then why not just have it create an Excel file instead of going through spool?

There are tons of SCN posts already about the output getting truncated in background, just use Google. It can still find the old SCN posts in the archive.