ALV GRID with icon fields. When exports to Excel, icon fields are emtpy.

[Former Member]

Hi all,

In our SAP system (6.0 ECC) we've noticed the following behaviour:

In ALV GRID with icons (color lights for example...) when we export the list to Excel format with the standard button bat, the icon column is always empty.

We think that in previous SAP version (4.7), the code corresponding to the icon appeared (For example @08@ for green light).

It's possible to have tha same functionality in this new version like in 4.7?

Regards.

Edited by: Ole ES on Nov 17, 2010 6:05 PM

[guillaume-hrc]

Hi,

Check the format in which you export to Excel (MHTML, XML, ...) and try antoher one.

http://help.sap.com/saphelp_erp60_sp/helpdata/en/66/79ad48157f11d2953700a0c930328a/content.htm

I think the integrated Excel mode shows '@08@'.

Best regards,

Guillaume

[Former Member]

Hi Guillaume,

Our problem is that our users will export in the same way as they did in previous version 4.7, and they are watching that icons are not exported correctly (with corresponding codes @...).

Because of that, we want to know if there is any possibility of export in 6.0 with the same behaviour that 4.7.

Regards.

[guillaume-hrc]

Hi,

I understood your requirements.

All I'm saying is that the Excel export mode may have changed. But, you can set the default Excel export mode for users :

http://home4sap.com/Blog/2010/03/ecc5-0-alv-default-file-format-when-extracting-files-to-excel/

Best regards,

Guillaume

[Former Member]

Hi again Guillaume,

Thanks. I supose the only way is changing the way that users exports the ALV to Excel.

Thanks!!