creating WDA with Export to excel and sort functionality

[Former Member]

Hi,

I am trying to create a webdynpro for java application that displays a table format with some columns that fetches the data from backend for a particular pernr.I would like to have sorting functionality on each and every column and Filter On,Export To Excel functionalities for that application.

I am planning to embed this iview in Compensation Information page where the other iviews are WDA.

let me know whether it is do-able or not.If yes send me the solution .Points will be rewarded for the helpful answer.

Thanks

Bala Duvvuri

[Former Member · Accepted solution]

Hi Bala Duvvuri,

Refer to the following links in order to implement the Table Sorting, Table Filter & Export to Excel functionality in your webdynro application.

Table Sorting:

/people/bertram.ganz/blog/2006/03/07/enhanced-web-dynpro-java-tablesorter-for-sap-netweaver-04s

Table Filter

/people/kapil.kamble/blog/2006/12/21/how-to-get-ready-made-filter-for-your-web-dynpro-table-with-minimal-coding

/people/peter.vignet/blog/2007/01/03/generic-web-dynpro-java-table-filter

/people/subramanian.venkateswaran2/blog/2005/05/10/filtering-table-values-using-webdynpro

Export table data to Excel

/people/subramanian.venkateswaran2/blog/2006/08/16/exporting-table-data-to-ms-excel-sheetenhanced-web-dynpro-binary-cache

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/webDynproJava-ExportingTableDataUsingOn-DemandStreams-SAPNW+7.0&

/people/sap.user72/blog/2006/05/04/enhancing-tables-in-webdynpro-java-150-custom-built-table-utilities

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/user-interface-tec...

Thanks n Regards,

Jhansi Miryala

[nikhil_bose]

[Export To Excel|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/4210] [original link is broken] [original link is broken] [original link is broken];

[Sorting|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3287] [original link is broken] [original link is broken] [original link is broken];

[Table Filter|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/5439] [original link is broken] [original link is broken] [original link is broken];

nikhiL

[Former Member]

Hi,

am trying to create a webdynpro for java application that displays a table format with some columns that fetches the data from backend for a particular pernr.I would like to have sorting functionality on each and every column and Filter On,Export To Excel functionalities for that application.

I am planning to embed this iview in Compensation Information page where the other iviews are WDA.

Your requirement is possible from WD Java

Make use of Peter Vignets table filter blog is available.

Make use of the table sorter class for the sorting some customization might be needed .

Use jxl or apache poi for the excel export.

Regards

Ayyapparaj