topic Re: Spool ALV LIST in Application Development and Automation Discussions

Spool ALV LIST

alexandre_docarmorocha — Tue, 15 Apr 2008 15:36:09 GMT

Hi everyone,

How can I increase the width of the spool when i use the ALV List?

I know the limit usually is 255, but i need to see at the spool 600!

Have someone set up a new format paper like 65 X 600 and put it on the printer parameters?

Do you think it would be work properly?

regards,

Alexandre

Re: Spool ALV LIST

Former Member — Tue, 15 Apr 2008 15:53:38 GMT

I am not sure if you can change the paper format to affect how wide your output is.

Usually, downloading the output as a file on the application server is a solution for wide outputs.

Re: Spool ALV LIST

alexandre_docarmorocha — Tue, 15 Apr 2008 15:56:19 GMT

i've already do that. My problem is . my key user wanna make download from the spool, but those fields show up trunc.

thanks.

Re: Spool ALV LIST

Former Member — Tue, 15 Apr 2008 15:57:14 GMT

You could create a layout on transaction SPAD...

Here at work they use a 65X1000 and it's works just great for SPOOL -;)

Greetings,

Blag.

Re: Spool ALV LIST

Former Member — Tue, 15 Apr 2008 16:41:31 GMT

Hey Blag,

You just solved one of my long-standing mysteries of how to handle wide outputs.

I created a new format type Y_65_1000 in SPAD (Extended admin, Device types tab) and assigned it exclusively to a new output device called YSPOOL.

Now when I run a report(ALV) with a wide output in the background, I choose YSPOOL output device with Y_65_1000 format type and the full width of the output in SP01 can be downloaded.

No more downloading files to the app server. This is really cool!

Thanks!

Ken

Re: Spool ALV LIST

alexandre_docarmorocha — Tue, 15 Apr 2008 18:25:47 GMT

I'll try!

Thank you!

Alexandre

Re: Spool ALV LIST

alexandre_docarmorocha — Tue, 15 Apr 2008 19:12:42 GMT

I've found these notes OSS Notes 213382 and 409339. It would be helpful for who wanna just send to spool.

Alexandre

Re: Spool ALV LIST

Former Member — Tue, 15 Apr 2008 19:38:17 GMT

Ken:

I'm so glad you like it -:) It's a nice and useful trick -;)

Greetings,

Blag.

Re: Spool ALV LIST

alexandre_docarmorocha — Wed, 16 Apr 2008 14:18:09 GMT

Alvaro and Ken,

Ive had asked the basis team to assign the format pages(X 65512/2 and X_65_1024/4) in output device ZLOC.

When i ran in background the spool show me no one trunc columns, but, it doesnt show me all columns! how can i get all info? Should i make some changes in the confuguration at SP01/SP02?

Thank you in advance

Alexandre

Re: Spool ALV LIST

Former Member — Wed, 16 Apr 2008 14:22:09 GMT

Did you check the default layout variant for your report? Maybe it does not have all the columns????

Also, I have not used X 65512/2 and X_65_1024/4. I just created a new one Y_65_1000 and assigned it to the output device.

Re: Spool ALV LIST

Former Member — Wed, 16 Apr 2008 21:09:50 GMT

There is probably a basis setting that sets the width for graphical view of spools (in SP01) - not sure what and where it is.

Here is a possible workaround:

In table TSPOPTIONS create new line with the following values:

SPOPTION = REALWIDTH

VALUE = 1023

Then in SPAD, via menu Goto->Cache Control, click "Reset cache settings" button. This should reset all spool cache and allow the value of TSPOPTIONS load in memory to display of 1023 wide spools.

Re: Spool ALV LIST

Former Member — Wed, 16 Apr 2008 22:08:48 GMT

OSS Note 186603 has the following to set REALWIDTH in TSPOPTIONS:

Releases 4. 6D and higher: Call SPAD and choose Settings -> Spool System -> Other. Select 'SP01: Number of Lines for List Display from Format'.

Re: Spool ALV LIST

alexandre_docarmorocha — Thu, 17 Apr 2008 14:29:22 GMT

It was great! works perfectly!

All of the columns are in perfect conditions in the sap spool. Thank you ken!

Just one more question.. when i export the file, its came with header by page, e.g. If i have 16,000.00 pages, i'll have 16,000.00 headers. I'll make some changes in printers parameters in ALV function and try it out again. If you have any idea about that, let me know!

Thank you so much!!

Alexandre

Re: Spool ALV LIST

Former Member — Fri, 18 Apr 2008 00:02:16 GMT

Thanks to Blag!

AFAIK, it is not possible to have only one header in ALV spool but just like you I will check too. Usually, I sort the downloaded spool in Excel which lists all the headings together and then I delete them all together.

Re: Spool ALV LIST

Former Member — Fri, 18 Apr 2008 09:30:19 GMT

Hello Ken,,

CAn you please let me know of the graphical view of the spool(where the display in single line for spool row raather than wrapping around ) as in the other systems of my client we haven't created any format or device type. We use X_65_255 format for printer say LOCL or LPO1 and this works fine for us except in one system.

I have opened a thread

if you know please reply to this <REMOVED BY MODERATOR>

regards

Sachin

Edited by: Alvaro Tejada Galindo on Apr 22, 2008 12:21 PM

Re: Spool ALV LIST

Former Member — Sat, 19 Apr 2008 11:16:26 GMT

Does not solve your issue completely but here are some options I tried:

1) I changed the number of lines in my format types to 1024. This way I get less pages and hence less headers - this one worked but it seems to be taking a lot of app server memory because the spool is quite wide and long

2) You could check if setting the IS_LAYOUT-NO_COLHEAD = 'X' works for you. This may just skip the headers altogether. I had some trouble checking this because of my default layout variant of my test ALV report kept overriding this value I set in the program.

Re: Spool ALV LIST

alexandre_docarmorocha — Tue, 22 Apr 2008 16:04:28 GMT

I've doing it. Thank you again and wether you find out something, just let me know.

Regards,

Alexandre