topic Re: Transaction code for Query in Application Development and Automation Discussions

Transaction code for Query

Former Member — Fri, 05 Aug 2005 08:56:22 GMT

Hello,

How can I create a transaction code for a Query ?

Thanks,

Benoî

Re: Transaction code for Query

Former Member — Fri, 05 Aug 2005 08:58:39 GMT

Hi,

Goto SQ01 and select the following menu path to findout the Query Program name.

Query --> More functions --> Display Report name.

Create a transaction code in SE93 by using this Report name.

Thats It.

Regards,

Vijay

Re: Transaction code for Query

Former Member — Fri, 05 Aug 2005 09:00:27 GMT

For Creating Query follow the steps as below:

In order to create an ABAP query , one has to do the following.

1. Create an User group.

2. Create a Functional Area

3. Assign the User group to the Functional Area

4. Create the query based on the functional area created.

You can create or execute these, using the transactions below.

SQ01 for Query

SQ02 for Functional Area.

SQ03 for User Group.

First Step is to create a dictionary structure . Include all the fields in this structure that you want to output.

Then create a report program having the following structure .

I guess U cant create, if i find any solution i will get back to you.

Message was edited by: Judith Jessie Selvi

Re: Transaction code for Query

Former Member — Fri, 05 Aug 2005 09:01:25 GMT

This does not work, the name of the program can change...

Re: Transaction code for Query

jayanthi_jayaraman — Fri, 05 Aug 2005 09:54:11 GMT

Hi,

I too suggest you to create a query in SQ01 and then use it in report.Then create transaction for that report.

Re: Transaction code for Query

andreas_mann3 — Fri, 05 Aug 2005 10:02:30 GMT

Hi,

if prg-name can change ,

create a short report with fm RSAQ_REPORT_NAME,

submit found reportname and integrate that prg in a transaction

Andreas

Re: Transaction code for Query

Bema — Fri, 05 Aug 2005 11:03:56 GMT

Hi ,

Go to SQ01 transaction.

Select your query name

Then Click on Query->More functions->Display report name

Copy this report name.

Then go to se93

Create a transaction code . Here for the program name , paste the report name you copied.

Regards ,

Beena

Re: Transaction code for Query

Former Member — Fri, 05 Aug 2005 13:33:46 GMT

Hi,

Create a short report with FM 'RSAQ_QUERY_CALL' inside. Link the report with your transaction code.

Svetlin

Re: Transaction code for Query

sergey_korolev — Fri, 05 Aug 2005 17:07:58 GMT

Hello Benoît,

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.

Message was edited by: Sergei Korolev

Re: Transaction code for Query

otto_rodrguez — Wed, 25 Oct 2006 16:38:49 GMT

hi Sergei, i have a problem trying to do that. when i assign de user group with trailing spaces, the system show me the message EU270 "Do not use blank characters", i use the separator character "_", but anyway the problem persist, and the system shom me the message AQ801, "User group ZSD________G has not yet been created"

can you help me please ?, i really need to solve these problem asap

thanks in advance.

Re: Transaction code for Query

Former Member — Mon, 13 Oct 2008 15:46:37 GMT

Done

Re: Transaction code for Query

marco-silva — Tue, 24 Mar 2020 08:59:09 GMT

"D_SREPOVARI-REPORT = precisely the first 12 characters - query user group (including trailing spaces), 13-th character is G for global queries" still helpful in 2020! Thanks!