ALV - coulmn names differ from Grid display to Excel download

[Former Member]

Hi,

When I display report in ALV grid, the layout looks fine. But the column headings and field output length differs from Grid to Excel sheet data.

suppose if some column heading is like ABCDEF and content is of 2 characters. Then it grid i am getting like ABCDEF. But in Excel I am getting it like ABC. ( which is seltext_S).

My question is why the layout is not being copied to Excel as it is like in GRID display??

Thanks in advance.

Praneet

[Former Member]

Hi,

I also faced the same issue in one of my reports. What is the data type that you are using for those fields?

Regards

Ansari

[Former Member]

Hi,

I also faced the same issue in one of my reports. What is the data type that you are using for those fields?

If you change the data type to char for all the fields it will start working properly. For example

ekorg(4) type c ,"ekko-ekorg, "Purchasing Organization

Regards

Ansari

[Former Member]

HI,

Just Try this,

Eg: suppose this is the field VBELN

Declare in the internal table like

vbeln(10) type c,

instead of vbeln LIKE vbak-vbeln,

Hope it'll work

[Former Member]

Hi,

It's not working. And also one field has leading zero. And I want that by

lzero = 'X'

It's appearing properly in ALV grid display and print preview. But excel does not show up leading zero.

Can any one faced this earlier?

Pra