05-24-2006 11:18 AM
05-24-2006 11:21 AM
05-24-2006 11:22 AM
05-24-2006 11:22 AM
HI Das,
Sort the Fields and use <b>GUI_D0WNLOAD</b> FM
Check this out
http://www.sapdevelopment.co.uk/reporting/rep_capturerep.htm
05-24-2006 11:24 AM
1) Sort the data in the internal table itself before you display in the ALV.
2) Sort using the options available on the alv before you download(For this you need to fill the sort table and pass to the reusealvdisplay* function.
Regards,
Ravi
05-24-2006 11:25 AM
there will be icons to sort and also down load to xcel. use them and do, its simple.
05-24-2006 11:32 AM
hi
first sort the table asper ur sorting order
then pass this table in ur FM reuse_alv_grid_display
then using ALV toolbar u can download ur table...
there is anpther option in the above FM i.e IT_SORT
u can check this if this can match ur reqmnt..
thanks....
05-24-2006 11:36 AM
Hi,
in sorted Order...,
You can sort it using the Standard ALV tool bar Buttons.
and Down load it to excel sheet , if you sort the data in ALV the same data will be transfered to Excel when you download. did you check it. check it. or if you are not convinced please let us know what you are looking for.
Regards
vijay
05-24-2006 11:39 AM
Hi satyan,
check these links:
https://weblogs.sdn.sap.com/weblogs/topic/29?x-o=50 - 64k -
sap.ittoolbox.com/groups/ technical-functional/sap-r3-dev/5/2004 - 45k -
regards,
keerthi.
05-24-2006 11:40 AM
Sort the fields using the code as below and then if u are using standard ALV display then u have an icon "SPREAD SHEET" for downloading ALV into an excel sheet
DATA: WA_SORT TYPE SLIS_SORTINFO_ALV,
IT_SORT TYPE SLIS_T_SORTINFO_ALV, "SORT ITAB
FORM SORT_LIST.
WA_SORT-FIELDNAME = 'VBELN'.
WA_SORT-TABNAME = 'IT_VBAK'.
WA_SORT-SPOS = 1.
WA_SORT-UP = 'X'.
WA_SORT-SUBTOT = 'X'.
APPEND WA_SORT TO IT_SORT.
CLEAR WA_SORT.
WA_SORT-FIELDNAME = 'NETWR'.
WA_SORT-TABNAME = 'IT_VBAK'.
WA_SORT-UP = 'X'.
WA_SORT-SPOS = 2.
WA_SORT-SUBTOT = 'X'.
APPEND WA_SORT TO IT_SORT.
CLEAR WA_SORT.
ENDFORM. "SORT_LIST