01-14-2013 10:50 AM
Dears,
I have copied the t-code MR51 to ZMR51 so that the outputfor can be displayed in ALV grid report. The FM
'REUSE_ALV_HIERSEQ_LIST_DISPLAY' with replaced with FM 'REUSE_ALV_GRID_DISPLAY' to achive this.
ALV report is working fine but when I press the download functionality ( list --> export --> local file --> Spreadsheet),
the layout in totally different from front end. The downloaded excel file has wrong order of columns. Please suggest your inputs. Thanks.
01-14-2013 11:48 AM
Hi Sanjay,
have you tried to download by pressing the ALV download button (from ALV menu bar) and not the one from sap Menu.
I don't know right now if REUSE_ALV_HIERSEQ_LIST_DISPLAY gives you a standard download button, but if not maybe you should implement a new button in the tool bar.
Regards,
01-14-2013 11:59 AM
Dear Ilie,
Thanks for the reply. Yes, I tried to download using the the ALV download button available in the status bar, but the same issue. Then I added a custom button and written code (FM gui_download)for that command also giving same issue.
01-14-2013 12:16 PM
Hi Sanjay,
You can use FM SAP_CONVERT_TO_XLS_FORMAT with your status bar button.
or you can check the below link
http://scn.sap.com/message/3068924#3068924
Hope this helps
Please let us know if you have any other issues