How to expose Function Module output via Bex Query

[oueslati_anis]

Hello Guru,

  I would like to expose the output of a Function Module via a BEx query, is this possible. Thanks in advance.

Kind Regards

Anis

[former_member186696]

Hello Anis,

We have a FM do that. The RRW3_GET_QUERY_VIEW_DATA.

There is a wiki about how it works. Take a look:
Function module RRW3_GET_QUERY_VIEW_DATA - SAP NetWeaver Business Warehouse - SCN Wiki

Best Regards

Edward

[swati_gawade]

Hi Anis,

BEX query can be built on BW reporting objects only. e.g. Multiprovider, Infocube, Infoset, DSO, Infoobject.

You can not have output of an FM directly fed to the BEX query. You need to save the output first to BW object. Then you can build a query on top of that object.

Hope this helps.

-Swati.

[oueslati_anis]

Hello,

Thanks for your feedbacks, by the way do you have any idea how to proceed in order to transpose the FM data into a BW object ?

Kind Regards

Anis

[Former Member]

Option 1

You can export the FM output to Direct DSO, then use it for reporting.

The following APIs exist:  RSDRI_ODSO_INSERT: Inserts new data (with keys not yet in the system).  RSDRI_ODSO_INSERT_RFC: see above, can be called up remotely  RSDRI_ODSO_MODIFY: inserts data having new keys; for data with keys already in the system, the data is changed.  RSDRI_ODSO_MODIFY_RFC: see above, can be called up remotely  RSDRI_ODSO_UPDATE: changes data with keys in the system  RSDRI_ODSO_UPDATE_RFC: see above, can be called up remotely  RSDRI_ODSO_DELETE_RFC: deletes data

Option 2

Convert the logic of existing FM to FM RSAX_BIW_GET_DATA_SIMPLE to make datasource out of this. Load data using this DS to DSO/Cube.

Regards,

Sandeep

[former_member182997]

three things here:

1. Where from FM is extracting the data

2. Before BEx you have to keep data in one of the Infoproviders within BI

3. How to handle changes thats delta i am talking about in this procedure.

Bottom line it is possible via ABAP codes to achieve the same..

[oueslati_anis]

Hello,

I want to be able to query expose the output of a given FM to Webi Reporting via Bex, is that possible and how ?