10-10-2014 4:18 PM
Hi All,
Am displaying few fields in ALV using REUSE_ALV_GRID_DISPLAY FM. Till ALV Output we are able to achieve the user requirement. But while exporting the output to excel using LIST-->EXPORT-->LOCAL FILE-->SPREDSHEET the header of two fields are coming up with 3 extra spaces. Fields are of character type and we have cheked it in fieldcatalog also. inside Filecatalog the text dont have any extra spaces.
Could anyone please suggest some ideas to remove those trailing spaces from the header. Kindly note that the system is ECC4.6.
Thanks In Advance
Arun
10-10-2014 7:41 PM
Hi Arun,
Have a lock at note #569537.
There are several ways to export a ALV Grid, also an export way via XXL.
It' described in note #358644.
Exporting to a local file should be used for big amount of data.
There are no limitations like XXL export (defined by excel).
So keep in mind, by using download list -> export -> local file -> spreadsheet
You should start excel first and then use the excel import assistant (data -> import external data -> import data)
So you should set '"' to 'none' for text recognition in the excel import assistant to ensure, that the following columns could be loaded as column and not as text.
Regards,
Hugo
10-10-2014 7:42 PM
By the way that FM REUSE_ALV_GRID_DISPLAY is SAP internal function module, you should not use it.
Regards,
Hugo