topic Re: Function module to call existing query SQ07 in Application Development and Automation Discussions

Function module to call existing query SQ07

Former Member — Mon, 08 Mar 2010 12:39:59 GMT

Dear Gurus

I have a question regarding the possibility to call query from FM

I need in my program to call exising SAP Query and got the result

(I need to put the result in file first modyfining it etc etc)

So is there any FM that allows to call query and got the result of this query

to be able to do something with this result in my Z-program?

Best regards

Bogumila

Former Member — Mon, 08 Mar 2010 13:29:51 GMT

Hi,

Whenever query is created in SQ01 a report program will be created.In Z program you can call this report to execute query.

For finding the report name in your program use FM RSAQ_REPORT_NAME provide Query name and User group to this FM.

Which will export REPID which has report name.

Now you can SUBMIT repid in order to execute the report.

Hope it helps,

Shanmugavel Chandrasekaran