topic Re: program for SAP query in Application Development and Automation Discussions

program for SAP query

Former Member — Mon, 02 Jul 2007 06:39:14 GMT

hi experts,

I have created a SAP query in sq03.Now i have to create a tcode for it.where shall i get the program name and screen name for it .when i enter the tcode it has to go to the selection screen of my SAP query.

Re: program for SAP query

Former Member — Mon, 02 Jul 2007 06:44:39 GMT

Hi,

AFTER RUNNING YOUR PROG BY ABAP QUERY GO TO SE38 IT WILL DISPLAY THE NAME OF THE PROG

Thanks,

Anitha

Re: program for SAP query

kiran_k8 — Mon, 02 Jul 2007 06:46:21 GMT

Mani,

GO TO SQVI

SELECT THE QUERY NAME.

GO TO QUICKVIEW BUTTON IN THE MENU BAR

CLICK ON ADDITIONAL FUNCTIONS.

CLICK ON DISPLAY REPORT NAME.

K.Kiran.

Re: program for SAP query

Former Member — Mon, 02 Jul 2007 07:02:47 GMT

hi anitha after running my query this is the pgm name i am getting in se38 (saplaqrunt) .now what to do?

Re: program for SAP query

kiran_k8 — Mon, 02 Jul 2007 07:06:34 GMT

Mani,

Query names will not be like that.

For ex it will be in this way

AQA0SYSTQV000015ZTEST100======

Just check once again.

K.Kiran.

Re: program for SAP query

Former Member — Mon, 02 Jul 2007 07:06:35 GMT

please note : i am using infoset query and generating report.for this report i need to create a tcode?

Re: program for SAP query

Former Member — Mon, 02 Jul 2007 07:07:51 GMT

Hi,

Create the Tcode in SE93.... choose report transaction radio button ... & create the tcode.

Reward Points if it is Useful.

Thanks,

Manjunath MS

Re: program for SAP query

Former Member — Mon, 02 Jul 2007 07:09:10 GMT

Hi,

The naswer given by Kiran is correct, Query name you are getting is wrong, chck it once again.

Thanks,

Anitha

Re: program for SAP query

Former Member — Mon, 02 Jul 2007 07:11:31 GMT

Hi,

Just execute (test) the query using SQ01, then you will get the selection screen, now just look at system-> status to get the name of the program.

Reward all useful answers.

Regards,

Atish

Re: program for SAP query

Former Member — Mon, 02 Jul 2007 07:12:20 GMT

To create a Tcode for a query in SE93

No need to use small report

No need to use generated program name (it really can change)

Just create a <b>parameter</b> transaction with reference to START_REPORT transaction. When creating a parameter transaction you have to set the following parameters:

D_SREPOVARI-REPORTTYPE = AQ

D_SREPOVARI-REPORT = precisely the first 12 characters - query user group (including trailing spaces), 13-th character is G for global queries

D_SREPOVARI-EXTDREPORT = Query name as shown in SQ01.

That's it.

Well, and do not forget to check the flag "Skip first screen".

To all others interested: just try to add some SAP query into a role via PFCG, then run it, and then via System -> Status look into the definition of the transaction generated, and you'll see the answer.

<b>Reward points for useful Answers</b>

Regards

Anji

Re: program for SAP query

Former Member — Mon, 02 Jul 2007 07:19:04 GMT

Hi,

try FM: RSAQ_REPORT_NAME.

Regards, Dieter

Re: program for SAP query

Former Member — Mon, 02 Jul 2007 07:40:31 GMT

what values i have to give for this

D_SREPOVARI-REPORT = ???????????