Application Development 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: 

Truncation of Heading characters when an ALV is exported to an excel sheet

former_member305388
Active Contributor
0 Kudos

Hi All,

I am facing a problem while printing an ALV output on to an excel sheet. In the header the last characters are being truncated in the excel.

Now, I have the entire data in tb_output itab. So using REUSE_ALV*, i printed the output. Here comes the problem.

I heard about LIST_FROM_MEMORY and LIST_TO_ASCI which can solve this problem. But not much sure how to use those. Whether I need to pass my itab tb_output into any of these?

Please help me out from this problem.

Thanks a lot.

Regards,

Seenu

1 REPLY 1

Former Member
0 Kudos

Hi!

You have 2 options:

1. Shorten your headings so that their length is LE to the fieldlength of the data they are displaying. E.g. for PO number maximum possible is 10.

2. Try using the parameter OUTPUTLEN in the field catalog. You can increase this to be equal to the length of your column heading.

Hope this helps.

Cheers!