Insert query/report on e-Sourcing Project

[pablo_ruiznavas]

Dear all,

We are facing a new requirement under SAP e-Sourcing in which the client is requesting to insert a query/report on a Project. Basically, the client have two different Projects, Investments and Investments Proposal. There is a new custom tab inside Investment Project in which we need to display the related Investment Proposals, in order to display these proposals we need to insert a previously defined query/report which list all the proposals related.

Do you know if it is possible to proceed with this kind of requirement on e-Sourcing? Does E-Sourcing allows this functionality?

Is there any other option on SAP e-Sourcing to provide something similar? Basically what is needed is to display the proposals information in any kind of table or similar.

Thank you in advance for your help and time.

Kind regards,

Pablo Ruiz.

[vikram_shanmugasundaram · Accepted solution]

Hi Poblo,

It’s not possible to execute a report on a page within the project. However, it is possible to add the custom reports under the Report menu of the project by configuring it via Document Report Configuration. So you could have two Document Report Configurations, one for Investments and another for Investment Proposals and have different reports on the Reports menu based on the project type.

Hope this helps.

Regards,

Vikram

[pablo_ruiznavas · Accepted solution]

Dear Vikram,

First of all thank you for your feedback and help, it was very helpful.

Taking into account that it's is not possible to execute a report within the project, we have been reviewing your article Query IAPIs - A Good Alternative For DbHandle (very interesting article, by the way) and currently investigating the possibility to proceed in that way. Do you know if is it possible to display (for example any kind of table) the data retrieved by the query IAPIs within a Project?

Again, thank you so much for your help.

Kind regards,

Pablo Ruiz.

[vikram_shanmugasundaram · Accepted solution]

Hi Pablo,

If you can query the data via Query Definition, it should be possible to use the query IAPIs to execute that Query Definition and get the result set.

Regards,

Vikram

[pablo_ruiznavas · Accepted solution]

Dear Vikram,

Thanks for the reply, probably the IAPI for this purpose can be IapiQueryResultSetIfc (com.sap.odp.api.comp.query). I'm going to try out and let's see the result.

Kind regards,

Pablo.