03-04-2008 10:48 AM
Hi All,
I am displaying my output in ALV using REUSE_ALV_GRID_DISPLAY,but when i download the report to excel using standard download button in the tool bar(local file icon), the leading zeros are getting truncated
eg 0004 is displayed as 4
field is VBKD-ZTERM....
Whats the way out?
<REMOVED BY MODERATOR>
Regards
Gunjan
Edited by: Alvaro Tejada Galindo on Mar 4, 2008 2:52 PM
03-04-2008 10:53 AM
change the columns in excel sheet .. I mean format the cells to
TEXT ...
03-04-2008 11:05 AM
Hi,
The problem might be may be because u would have opened the file using excel.
try opening the file using notepad or else use the Function module CONVERSION_EXIT_ALPHA_OUTPUT for that field.
<REMOVED BY MODERATOR>
Regards
Rose
Edited by: Alvaro Tejada Galindo on Mar 4, 2008 2:53 PM
03-04-2008 11:06 AM
1.Introduce another field in internal table of type Numeric.
2.Before you pass the internal table to Reuse_alv_grid Display
3.Move the character field to Numeric type and use this
numeric field to display in Reuse_alv_grid_display.
Then the leading zeros will also be displayed while downloading to Excel.
<REMOVED BY MODERATOR>
Edited by: Alvaro Tejada Galindo on Mar 4, 2008 2:53 PM