topic Re: ALV Report in Application Development and Automation Discussions

ALV Report

Former Member — Wed, 22 Jun 2011 14:30:52 GMT

Hi Expert,

I am getting small boxes in the output of alv report, when I download this report in spreadsheet,These boxes are coming as # in excel,

even in debuger value is coming as # but in alv output it is coming as box.

Plese suggest how to remove these boxes from alv report.

Cheers

Akash

Re: ALV Report

roberto_vacca2 — Wed, 22 Jun 2011 17:06:29 GMT

Hi.

Probably you have to make some changes to your field-catalog structure.. for example changing numbers... usually numbers or any non-unicode chars are converted in "#" chars..

Try to show your field-catalog structure...

Hope to help, bye!

Re: ALV Report

Former Member — Wed, 22 Jun 2011 19:23:28 GMT

Try to make longer the outputlen in the feildcat

Re: ALV Report

Former Member — Thu, 23 Jun 2011 05:43:29 GMT

Hello,

After Execution when report executed in ALV format in SAP... in menu poartion extremely upper side of the screen on left.: Go to List -

> Export to -

> Spreadsheets. I will ask you to save. Save it on the desktop in the xml format.... As soon as you press the save button it will automatically open that file into the excel format.... now again save that file in save as format and select all that data in that file with ctrl+A and go towards lefte side of the shee and right click on it .. it will open a menu... now go to format cell and select the text portion in that and save it,. The data will display as you want to require it to be display. No zeros before any digits will be gone and also #s also not to be displyed.

Regards,

Akg

Re: ALV Report

Former Member — Thu, 23 Jun 2011 11:22:28 GMT

Hi All,

Those boxes are because of TAb space,

How can I capture and remove those tab spaces in program.

Cheers

Re: ALV Report

kamesh_g — Thu, 23 Jun 2011 12:30:13 GMT

spread sheet is tab separated only . i guess your characters not because of tabs .

1 . are you passing any special characters to alv out put field .

2. check all values are in SY-langu.

Edited by: KAMESH G on Jun 23, 2011 2:30 PM

Re: ALV Report

Former Member — Tue, 09 Aug 2011 16:40:24 GMT

this was because off tab space.