topic How to create a tcode using sap query in Application Development and Automation Discussions

How to create a tcode using sap query

Former Member — Thu, 20 Sep 2007 09:09:28 GMT

I have created a query using SQ01. It is working fine. But I want to create a transaction code for that. How can we achieve this?

Regards.

Hari

Re: How to create a tcode using sap query

Former Member — Thu, 20 Sep 2007 09:12:38 GMT

Hi,

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

Thanks,

Reward If Helpful.

Re: How to create a tcode using sap query

Former Member — Thu, 20 Sep 2007 09:12:57 GMT

Execute the query, the enter the code /nse38. This will show you the program that the query has generated. You will need to copy this to a Z program and assign a transaction.

That is the only way I know.

Re: How to create a tcode using sap query

Former Member — Thu, 20 Sep 2007 09:13:26 GMT

GO TO SE93....

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.

Re: How to create a tcode using sap query

former_member188827 — Thu, 20 Sep 2007 09:14:10 GMT

after activating da query execute it, go to system...>status.

copy program name,

den go to se93.

give ur tcode and click create

click on second radio button(program and selection screen),

and paste the program name copied earlier...

activate the tcode..