Alv report in background job - Unable to see all columns

[Former Member]

Dear Gurus,

I tried to run an ALv report in the foreground and it works perfectly fine and shows 42 columns. But when i run it in the background, the resultset only contains 12 columns. Is there a particular reason why this is happening. What steps can i take to remedy this.

~thanks, appreciate it.

[former_member583013]

Have you tried upgrading your report size?

REPORT zdummy_sandbox NO STANDARD PAGE HEADING line-SIZE 255.

Greetings,

Blag.

[Former Member]

No, how do i do that? and what are the implications of that?

~thanks

[Former Member]

Gotcha, change the report size in my ALV program.

will do that and try.

It should work.

How dumb i couldn't think about it

[former_member583013]

You do it like this...

REPORT zdummy_sandbox NO STANDARD PAGE HEADING line-SIZE 255.

Where LINE-SIZE is the size of your report screen and 255 is the max size (Maybe more or less..not sure)...basically, the ABAP standard line size for reports is kinda short...so if your ALV got 42 columns, you need to extends the size of the report output to make everything fit -:)

Greetings,

Blag.

[former_member583013]

Dumb? Come on -:) Something we look to the bigger picture and don't pay to attention to the little details -;) Happen to best of us so no worries about it -:)

Greetings,

Blag.

[Former Member]

thanks Blag,

I am getting below message when i try to run it in background

System cannot print the last 768 columns of the report

Message no. PT008

Diagnosis

Each format has a maximum number of columns. The number of columns specified is greater than the maximum number permitted.

Procedure

Specify a valid number of columns. Choose the possible entries help (F4) to find out what the current maximum value is.

[former_member583013]

Max line size is 1,023 according to the documentation...have pass that value and getting that error?

Greetings,

Blag.

[Former Member]

I set it at exactly 1023; it was more of an information / warning message.

The report is still running in background; We'll find out in a little bit.

[Former Member]

It has 30 pages. But still truncates after 255 chars. horizontally.

[former_member583013]

Maybe it has something to do with the printer you're using...try to use another one or look for a printer with a longer line-size...

Greetings,

Blag.

[Former Member]

Hi Blag,

I want the result in electronic form. In the above post I was talking about 30 pages in electronic form. also my printer settings for the background job say

"send to sap spooler only"

I don't think this has anything to do with the printer.

~thanks

[former_member583013]

Humm...then I don't know...I don't think I have to send any ALV report more than 15 columns to the spool...sorry -:(

Greetings,

Blag.

[Former Member]

Hi Neha,

In SM37 select the report , go to spool list . Select the check box and Press SHIFT + F4 you will get the maximum width for the report .

[Former Member]

Thanks nau, thats awesome, shift + F4 works like a charm.

[Former Member]

Hi Nau,

I got same problem, but now i have getting all columns.

Thank you very much.

Satish

[former_member223537]

Hi Neha,

While scheduling the job the default layout is selected which has max 80 columns. X_*_80....

While defining the background job ... STEP 1... you mention the program name, variant etc.. click on PRINT SPECIFICATION & pass the format as X_65_580.

Ensure that you have created such a format in SPAD transaction => Page format => NEW

Assign the new format to the Output device which you are mentioning in the background job.

Thanks,

Best regards,

Prashant