Skip to Content
avatar image
Former Member

Field in blank when I export to excel in ALV report

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?

Captura.PNG (97.8 kB)
Captura.PNG (235.8 kB)
Captura.PNG (50.5 kB)
Captura.PNG (92.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 11, 2015 at 04:17 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2015 at 02:22 AM

    Hi Luis,

    Try.

    gd_layout-colwidth_optimize = 'X'.

    OR

    wa_fcat-outputlen   = '70'.

    Hope it helpful.

    Regards,

    Venkat.

    Add comment
    10|10000 characters needed characters exceeded