08-24-2009 11:52 AM
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
08-24-2009 12:00 PM
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
08-24-2009 12:04 PM
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
08-24-2009 12:06 PM
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
08-24-2009 1:25 PM
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