topic Re: export only selected lines in Application Development and Automation Discussions

export only selected lines

Former Member — Wed, 20 May 2009 12:01:05 GMT

Hi,

I have the req to download or export only those lines within ALV which are selected

as excel format instead of complete lines,

Thx in advance for your kindly efforts

Friendly Regards

ertas ilahn

Re: export only selected lines

jayanthi_jayaraman — Wed, 20 May 2009 12:03:48 GMT

Hi,

Try creating a button on toolbar and pass the selected data for a new internal table and then download the same.

Re: export only selected lines

Former Member — Wed, 20 May 2009 12:04:46 GMT

Hello,

You can follow the below steps:

1. In the output internal table, you can add one more field called as mark.

2. In the gui status add one more button for some action.

Once some lines are selected in the entire ALV output, the mark will be set X.

Now when this button is clicked,

Loop at this internal table where mark = X and output them in the form of excel.

Re: export only selected lines

Former Member — Wed, 20 May 2009 12:06:50 GMT

Hi Ertas,

The approach shoud be :

1. Have one field in your internal table for selection.

2. Make the particular field as a check box for selection in ALV fieldcatlog

3. Have a custom button in toolbar for for export to Excel

4. Once the custom button is presses, loop at the internal table of yours and pick up the selected items and export that to excel sheet using GUI_DOWNLOAD.

Hope this helps you.

Thanks,

Arun