topic T-Code for Query in Application Development and Automation Discussions

T-Code for Query

Former Member — Thu, 19 Jul 2007 06:30:22 GMT

HI Experts,

My function guy made a Query in SQVI. Now he want to made aT-Code for that query. I tried but didnt find the programm name for that query. so that I can make T-Code. Pl zhelp me .....urgent.

Thanks.

Khan

Re: T-Code for Query

amit_khare — Thu, 19 Jul 2007 06:33:20 GMT

Refer SAP note 393160 explains how to call query via ABAP program.

~ Check this too -

<i>Go to se93 and select the create button. You will then be asked to writed down the tcode of your choice then create a short text for that tcode. Select the 2nd option button w/c is the "Program and Selection Screen (report transaction)." Press enter. Then key in the program name and the variant you saved in the program. When transporting to Prod, Save the variant there as well. If you placed "DEFAULT" in the creation of tcode, you should also save "DEFAULT" variant in production</i>

Regards,

Amit

Reward all helpful replies.

Re: T-Code for Query

Former Member — Thu, 19 Jul 2007 06:34:39 GMT

No need to use small report

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

Just create a parameter 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: T-Code for Query

Former Member — Thu, 19 Jul 2007 06:38:40 GMT

Goto transaction SE93.

Give some name and then press CREATE.

A dialog box appears.

Press the radio button of your choice.

Then assign the Object name to which you want to assign the transaction.

Regards,

Pavan