SPOOL - how to display output list of more then 255 characters?

[Former Member]

Hi,

First of all, I would like to say hi to all of you here, as a new member :)!

I've just discovered this forum - I'm very new and let's say unexperienced in SAP, unlike you :)!

Didn't know where to put my subject (in what folder) so I apologize in advance if I'm mistaken... I work as an ABAP programmer in SAP Core and SAP IS-T and currently I'm worried about this problem:(!

We have these huge reports in IS-T that have to be run in background, because of lot of data. Most of reports are very wide and don't fit in those 255 characters that is SAP standard for spool display. Now I'm dealing with this RFC that has to provide spool display with 800 characters, and this has to be on production by tomorrow:)!!!!!

First I created new format type (ZX_65_800) in transaction SPAD and assigned it to my local printer. I thought this would be enough, but I was wrong. Because when I try to run my programe in background, the system doesn't offer me my format at all :(!

Is there anything else I must do in order to get it.... (I work in Release 620)

If anyone had the same problem, please contact me!

Thanks,

BR,

Sanja

[nilayghosh · Accepted solution]

Hi Sanja,

Please refer to SAP note no. 186603. Hopefully you will find the answer.

Regards

[Former Member]

Hi

I am also working on ECC6. We created a print format too. Assigned to a printer.

and works fine in development. we even transported it to quality/ production and the printer was able to pick it up. we are able to view the data but not print since the paper is not in the standard size.

so we have got around the issue by downloading the report to excel and printing it out. The steps for the print format is as follows:

Create the format type

1. Goto Tcode- SPAD

2. Click on full admin

3. click device types.

4. Format types : z_rc_cc, rc - row count, cc- column count

5. click display.

6. click change.

7. click create

8. enter format name

9. select format type

10. select page format

11. select orientation

12. enter comment.

13. save - with key request.

14. back till spool admin initial screen

Assign the format to the device type

1. enter the device type press display

2. click on formats (f6)

3. click change, enter the format in input box and enter

4. click change, select printer initialization, reset after exit, end of page, end of line

5. click copy from and enter the "from " details ( previous format type ) and enter

6. save

7. select rows from format, select columns from format save.

Thanks.

[Former Member]

Hi All,

We have been looking for a solution for what I believe is the same problem, for more than 2 years now. I would just like to verify with you, if your requirement are similar to ours.

Problem:

1. Requirement is to run large HR reports – either standard or with Ad Hoc Query in background mode in a company with more than 50,000 employees.

2. Nobody wants printed reports these days. We want to save the forests. Customers prefer to be emailed an Excel file so they can do further data analysis, filtering, pivot tables etc.

3. Reports are running OK in foreground for smaller sections of the organisation, where you send the output to Excel from ALV, or save as a local file in spreadsheet format.

4. But large reports for entire company are awkward, tie up your PCs resources, and complex reports accessing many tables can timeout before completion.

5. So scheduling these reports to run in background would be the ideal solution.

6. However when we access the report output from SP02, we find that most reports (say with more than 13 or so fields) have an output wider than 255 characters and the output of the spool file wraps to the next line in Excel. It is very tricky to then parse the data back into one row for each employee. And you have a problem if you output is for 50,000 or so employees, because then you file is 100,000 rows and will not load completely into Excel – limit problem of 65,536 characters.

7. We simply want a spool file that does not wrap the data to the next line after 255 characters.

8. But how to explain this simple requirement to some technical people. It seems a lot of posts on SDN think we always want to print a spool file. NO – remember the forests!

Possible Solutions:

I see a lot of posts here that refer to OSS note 186603, but they don’t mention the target for the output of the spool is to import into an Excel File (i.e. spreadsheet format). Just search for 186603 or ” Spool request with more than 255 columns”. There is also a reference to OSS note 313566. I am not sure if these will work?

I have also seen the suggestions that you need to define a customer printer format that does not wrap the output after 255 characters (create a new format type in transaction SPAD).

Did you find a solution yet to this problem, do the solutions above work, or can anyone else help us!

John McKee

[Former Member]

Hi,

I have the very same problem on ECC6 and I am still struggling to get it correct.

I even try to reduce my fields length, but nothing is changing.

Have you got any solution as yet?

It seems like note 186603 is not applicable for ecc6.

I logged a call to SAP and I still haven't got any reply.

Thanks,

Flubert.

[Former Member]

Hi,

I'm sorry, but I just saw your post :)! Well, I didn't solve my problem at all... The only mistake I found in this procedure was that I assigned new format to another printer, and when I fixed that it worked perfectly good on development system.

The problem was in the fact that this didn't work on test system even though requests were transported correctly! This doesn't make sense at all!

So what I did was: I changed my program in order to fit in those 255 characters :)!

Regards

Sanja