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

Issue with running report in background/spool size

Former Member
0 Kudos

Hi Experts,

I have a custom report which is giving me different outputs when run in foreground and in background.

I use the same variant in both cases, but when run in foreground the output has 44 columns.

This gets reduced to 20 when I see the spool after running in bg.

Is there a limit on the number of columns that spool can display?

If yes, where can I check/change that?

Does the program line-size have anything to do with this?

Please help.

Thanks,

Peter

1 ACCEPTED SOLUTION

Former Member
0 Kudos

hi,

You can try this one, this can solve ur problem.

Call SPAD and choose Settings -> Spool System -> Other. Select 'SP01: Number of Columns for List Display from Format'.

Then create a new spool from background job and check the result.

Regards,

Mahima.

9 REPLIES 9

Former Member
0 Kudos

hi,

You can try this one, this can solve ur problem.

Call SPAD and choose Settings -> Spool System -> Other. Select 'SP01: Number of Columns for List Display from Format'.

Then create a new spool from background job and check the result.

Regards,

Mahima.

0 Kudos

Hi Mahima,

thanks for ur response.

I tried selecting SP01 and run the job again.

But the output remains the same with only 20 columns coming in the spool-->Type.

creating a new spool does imply running the job again right?

please advice.

Former Member
0 Kudos

while setting up background job, u can give print parameter. in Print parameter u can mentioned page format which can accommodate 44 columns. 

0 Kudos

hi Vipin,

i tried changing the print parameters to include max. no of columns.

this does not seem to have made any difference to my spool->type display as I am still getting 20

columns.

any more suggestions?

raymond_giuseppi
Active Contributor
0 Kudos

First check your ALV with The Consistency Check and try to set Optimize column in the layout.

What does happen if you reduce your screen width, displaying your sapgui mode in a window and not in full screen mode; and look at the screen display of the ALV. If you get the same problem than in background, then check your report width (REPORT LINE-SIZE width) as well as the layout and line size of the generated spool (Print parameters of the background job AND print parameters of the ALV FM or class) and printer definition/capacity (SPAD).

Regards,

Raymond

0 Kudos

Hi Raymond,

Displaying the sapgui in a window does not have any difference.

Tried to Optimze width of columns, but that is disabled.

Report line-size width is 170 but I dont see why the foreground ouput differs.

FYI-this is how i viewed my bg output:

Spool-->abap list icon under the TYPE column.

Please advice.

former_member194152
Contributor
0 Kudos

While creating step from background job you have an addtional option to select printer properties, choose appropriate format for spool creation, SAP provide maximum 255 character width of spool, but check with basis if the create new format for you to hold value more then 255 character.

Regards,

Gagan

Former Member
0 Kudos

Hi All,

Having tried making changes to print parameters,SPAD with no result, I went back to the source code.

There, in code for Create ALV, I found an IF check for

method is_offline() IS true and some check for a structure(not sure) IS BOUND.

Could this be related to our scenario in any way?

PS: during job debugging (JDBG) I think this offline is false and hence behaves as foreground.

Also, what is this 'IS BOUND'?

Please help.

Former Member
0 Kudos

Hi All,

The issue was resolved by selecting max. number of columns in print parameters.

Thanks,

peter