Skip to Content

How to display results of spool in ALV or download results to excel without columns being truncated?

Hello Everyone,

I have a report which when executed 'online' outputs the reults in a simple ALV grid.

There are ~15 columns displayed in the ALV result list.

However, in some situations i need to execute the report in background.

When i display the contents(results) of the spool list, then i notice that only the first 4-5 columns show up in 'Graphical display' mode.

The remaining columns are not displayed! Downloading the results also do not show all the columns.

Is there a way to display all the columns in the spool's 'Graphical display' mode?

I already tried to use the 'Hex format'. However this results in lot of post processing work when downloaded to an excel!

So what i am looking for is some tips on how to display all the columns of spool result display, or even better a way to view the results in an ALV grid.

Maybe there are some setting to display all columns which i am not able to figure out.

Any help is highly appreciated.

Thanks in advance.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on May 04, 2012 at 10:05 AM

    You could

    - change the layout of the grid (Note 1486374 - ALV Grid: Layout for spool list when running as a job) and increase report width

    - instead of displaying ALV, export all FM or method parameters with an EXPORT TO DATABASE, then give option in interactive execution to IMPORT this data back

    - use CL_GUI_ALV_GRID method EXPORT_TO_XML




    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.