topic Re: Query into table in Application Development and Automation Discussions

Query into table

Former Member — Tue, 25 Mar 2014 13:57:28 GMT

Hello,

I need your help, I have a query, someone knows how to make the result of this query into a internal table , I want to develop a program that makes this. I want to reuse the query already built and then use the data for other purpose.

Thanks so much.

Re: Query into table

Former Member — Tue, 25 Mar 2014 14:56:34 GMT

query can be generated as a report. You would need to do this and parse the part where the data is selected

Re: Query into table

ThangaPrakash — Tue, 25 Mar 2014 17:36:46 GMT

Hello Enrique,

Goto SQ01 --> Select the query and goto menu, Query--> more function --> Display report name.

Goto se38 open the report and copy it to your Z* program, internal table %g00 has the final data displayed in the query output.

Regards,

Re: Query into table

Former Member — Thu, 27 Mar 2014 02:57:38 GMT

My understanding is that you want to call a query from your program to get the results of the query into an internal table. If so you can also use the function RSAQ_REMOTE_QUERY_CALL. Just pass your query name, usergroup, and remember to check SKIP_SELSCREEN and DATA_TO_MEMORY. It's RFC enabled and we use it here to download data but it should work fine internally. The format in the data in the export table doesn't look as friendly as I thought though.

Re: Query into table

tripurari_rai2 — Thu, 27 Mar 2014 03:12:14 GMT

Get the query name from Goto SQ01 --> Select the query and goto menu, Query--> more function --> Display report name.

The use sumbit report statement. SUBMIT query_prgram_name AND RETURN EXPORTING LIST TO MEMORY. The call the list by FM LIST_FROM_MEMORY into your itab.

hope this will work for you.

Re: Query into table

Former Member — Thu, 27 Mar 2014 03:25:39 GMT

Hi Tripurari,

This would produce a nicer format than my suggestion but one probelm with this is that the report behind a query is generated by the system so its name can change between development, quality and production environments. If I were to follow this approach to try to get the results of a query into an internal table I wouldn't submit the query program directly but submit the program START_REPORT as similarly as describe.

"START_REPORT with the skip initial screen checked and pass the following parameters to START_REPORT

• D_SREPOVARI-REPORTTYPE = AQ

• D_SREPOVARI-REPORT = <USER GROUP in WHICH THE QUERY IS CREATED> G "

This is an approach we use to avoid problems caused by chaning query report names between environments when we create transaction to wrap around querys but I've not tried it to export a query list.

Regards,