Field in blank when I export to excel in ALV report

[Former Member]

Hello guys,

I have an ALV report with a field called "Destinatario"

When I export the informetion to excel, this field is showing in black;

My fieldcat is this:

My code:

SELECT * FROM ZMAQ_GRID1 INTO CORRESPONDING FIELDS OF TABLE IT_MM.

And the IT_MM declaration:

DATA: IT_MM TYPE STANDARD TABLE OF ZMAQ_GRID1,"ty_alv,
       wa_alv TYPE ZMAQ_GRID1,"ty_alv,
       IT_AUX TYPE STANDARD TABLE OF ZMAQ_GRID1.

My ztable is:

Could someone tell me what I'm doing wrong?

[VenkatRamesh_V]

Hi Luis,

Try.

gd_layout-colwidth_optimize = 'X'.

OR

wa_fcat-outputlen   = '70'.

Hope it helpful.

Regards,

Venkat.

[Former Member]

I test your code but does not work 😞

[Former Member]

Hello, I solved my problem, the issue was the fieldcat is key sensitive and in my table my column is called: DESTINATARIO and I set Destinatario in Field cat, now I change it for DESTINATARIO and does work well. Regards.

[former_member70633]

Same issue I was facing & it is now resolved.

Thank you, your post help me to resolved the issue.

[thisispankaj]

By making field name in uppercase it solved my problem!!

Thank you very much for your answer. Keep helping and growing.

[gui_machado]

Thanks, really saved me

[former_member643191]

THank you very much i also faced the same issue. resolved now