program for SAP query

[Former Member]

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.

[Former Member]

Hi,

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

Thanks,

Anitha

[kiran_k8]

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.

[Former Member]

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

[kiran_k8]

Mani,

Query names will not be like that.

For ex it will be in this way

AQA0SYSTQV000015ZTEST100======

Just check once again.

K.Kiran.

[Former Member]

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

[Former Member]

Hi,

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

Thanks,

Anitha

[Former Member]

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

[Former Member]

Hi,

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

Reward Points if it is Useful.

Thanks,

Manjunath MS

[Former Member]

Hi

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

[Former Member]

Hi,

try FM: RSAQ_REPORT_NAME.

*

Regards, Dieter

[Former Member]

what values i have to give for this

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