Skip to Content
-1

Need help on spooling for program run in background

Oct 13, 2016 at 07:37 AM

108

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Sandra Rossi Oct 13, 2016 at 11:30 AM
2

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 13, 2016 at 09:09 AM
1

did you try LINE-SIZE 1023 statement?

Share
10 |10000 characters needed characters left characters exceeded
Joachim Rees Oct 13, 2016 at 09:08 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Raymond Giuseppi
Oct 13, 2016 at 12:37 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Kaushik Debnath Oct 13, 2016 at 09:17 AM
0

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

Thanks,

Kaushik

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 13, 2016 at 09:06 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Jelena Perfiljeva
Oct 13, 2016 at 05:08 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded