Need to export result table when using IF_FPM_GUIBB_SEARCH

[Former Member]

Floorplan gurus.

I'm using IF_FPM_GUIBB_SEARCH and my end-users want to export the result table to excel.

Is that possible ?

As a workaround...can I use IF_FPM_GUIBB_LIST ?

How can I create a search screen for IF_FPM_GUIBB_LIST ?

Please advice

[former_member269672 · Accepted solution]

Hi,

You may check Analytics List UIBB. It offers the functionality of exporting data to Excel.

Regards,

Desislava

[Former Member · Accepted solution]

Yes, but how can I connect a search screen to the Analytics List UIBB ?

[former_member269672 · Accepted solution]

Please check the following video tutorial:

[Analytics List UI Building Block - Integration of List Reporting within Development|http://www.sdn.sap.com/irj/scn/elearn?rid=/library/uuid/700ee9e8-4ea5-2e10-ecaf-f781721d8030]

Other tutorials on FPM:

[http://wiki.sdn.sap.com/wiki/display/WDABAP/eLearningTutorials-FloorplanManagerforWebDynproABAP]

Regards,

Desislava

[Former Member · Accepted solution]

Thanks.

OK - so I need a BW query ?

Can I create such a query in the ERP system (SAP ECC 6.0) ?

Please advice.

[former_member269672 · Accepted solution]

I am not really into BW queries. Here is what I found in help.sap.com (not sure if it is for the right version):

[Defining New Queries|http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a5625e09411d2acb90000e829fbfe/frameset.htm]

I hope this helps.

Regards,

Desislava

[Former Member · Accepted solution]

Thanks for the excellent help.

But we are running ERP system and not a BW system, so I don't think it is possible to create a BEx query here.

So what I actually need is to combine the IF_FPM_GUIBB_LIST and the IF_FPM_GUIBB_SEARCH to be able to export to Excel, but I guess it is not possible, or...?

Regards

Erik

[former_member184443 · Accepted solution]

Solved!!!

The combination of IF_FPM_GUIBB_LIST and the IF_FPM_GUIBB_SEARCH is possible !!!

[J_R · Accepted solution]

As of NW 7.31 it will be possible to integrate the new GUIBB List ATS directly into the search GUIBB Search via configuration. Then, you will have all list features in the search result list.

[kmoore007 · Accepted solution]

Erik,

Can you explain how you achieved this?  I am also using the Search GUIBB and would like the ability to export to Excel.

Thanks,

Kenneth

[kmoore007 · Accepted solution]

Jens,

Can you explain how to achieve this?

[J_R · Accepted solution]

As of FPM 7.31 you will be able to specify the key of a GUIBB List or List ATS (the newer one is the GUIBB List ATS) within the Search configuration. The corresponding List / List ATS configuration itself offers the 'Export to Excel' functionality... and others, such as sorting, filtering, etc.