topic Re: Problems when scheduling a report in background in Application Development and Automation Discussions

Problems when scheduling a report in background

Former Member — Wed, 12 Nov 2008 20:58:43 GMT

Hi Guys

I have a report that has a lot of columns so i have created a display variant with 22 cols. When I run this report online (foreground) It picks up my variant and I can see all 22 cols. The problem is when I schedule this in background it does not display all the cols, the last three cols get cut off.

Any idea why this is happening?

Thanks

Sameer

Re: Problems when scheduling a report in background

Former Member — Wed, 12 Nov 2008 21:00:33 GMT

Formatting set to 'X_65_255' when I schedule it in the background.

In case u were wondering !

Re: Problems when scheduling a report in background

Former Member — Wed, 12 Nov 2008 21:43:16 GMT

you have to change the format in SPAD.

Go to transaction SPAD -> FULL ADMINISTRATION -> DEVICE TYPES -> FORMAT TYPES and there you can see all the available formats. Create a new format Z_65_700 in the similar manner with X_255... with a different number of columns (700) and save it.

Then in the tab DEVICE/SERVERS go to OUTPUT DEVICES and type your printer -> ENTER -> then from the Menu GOTO device type -> then there is a button FORMATS where you can see all the existing formats (plus the one you have just ctreated). Find it and choose it. Then save.

Now you have attached the new format to your printer.

The next step is simple.

You can do it the way you described, but there is also another way. Run your program with F9 and not F8 from the selection screen. It will ask you for printers, formats etc. There you will first select the appropriate printer and then (after ENTER) you have to go down to formats and select the new format. Do not print it immediatelly, click only the NEW SPOOL REQUEST checkbutton. This will create a new spool request.

If you go to SP01 you will find the number of your finished job. If you click the abap list button it will only show you collumns with up to 255 characters.

But if you take the spool number and put it as a parameters to the zzz program , it will show everything.

Source:

Re: Problems when scheduling a report in background

alexandre_docarmorocha — Wed, 12 Nov 2008 22:59:31 GMT

I got the same problem. The complete information you should find at the following notes:

Note 409339 - Spool requests with ABAP lists with more than 255 columns

Note 213382 - SAPWIN/SWIN: Lists with more than 255 columns

Regards,

Alexandre Rocha

Re: Problems when scheduling a report in background

Former Member — Thu, 13 Nov 2008 17:56:37 GMT

Sunil & Alex

Thanks a lot for your inputs but I have far less thatn 255 cols in my alv.

And the same format and printer are working for other simillar rports. This particular report is having an issue.

Rgds

Sameer

Re: Problems when scheduling a report in background

Former Member — Thu, 15 Jan 2009 10:49:16 GMT

Sameer,

I'm with the same problem...did you fixed it?

Re: Problems when scheduling a report in background

Former Member — Thu, 15 Jan 2009 15:16:21 GMT

Hi Eric

There was an OSS for that which suggested we change some settings in SPAD.

But we couldnt apply that OSS because SAP reccomended to apply that OSS as an upgrade proccess.

I dont remember the Note no as of now. I will let you know once I find it in the archives

Hope that helps.

Rgds

Sameer