Application Development and Automation 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: 
Read only

Problems when scheduling a report in background

Former Member
0 Likes
763

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

6 REPLIES 6
Read only

Former Member
0 Likes
742

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

In case u were wondering !

Read only

0 Likes
742

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:

Read only

0 Likes
742

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

Read only

0 Likes
742

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

Read only

0 Likes
742

Sameer,

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

Read only

0 Likes
742

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