topic Re: Txn code to Query in Application Development and Automation Discussions

Txn code to Query

Former Member — Wed, 04 Jul 2007 05:53:57 GMT

I have made the Query in SQ01 with the User Group,..

now i want to assign the T-Code to the Query how can i get the Report Name

i am getting the Report name as

"!QA0FI==========ZPP456========" but when i assign this a T-code it gives error in SE93

can u tell me how to give t-code to this

Re: Txn code to Query

seshatalpasai_madala — Wed, 04 Jul 2007 05:58:20 GMT

Hi,

When ever you create query at the runtime a Function group along with Function modules are created you can copy that function group to a ZFunction group and them create a transaction.

Just execute the query in debug mode to get the Generated FG's name.

Regards,

Sesh

Re: Txn code to Query

kiran_k8 — Wed, 04 Jul 2007 06:02:12 GMT

Go to SQVI

Select the the Query.

Choose the Qucik View button in the Menu bar

Choose More Funtions.

Click on DISPLAY REPORT NAME.

Now go to SE93.

K.Kiran.

Message was edited by:

Kiran K

Re: Txn code to Query

Former Member — Wed, 04 Jul 2007 06:04:34 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.

Tcode for Report Painter

To create a TCode, follow the steps below.

1) Go to Transaction code SE93, Enter TCode Name and Press Create.

2) Give short Description and select Parameter Transaction, Press Enter

3) Select Transation Radio Button and write START_REPORT in the next text

box Also Check the box Skip Initial Screen.

4) On the bottom of Screen (default Values), Enter Parameters

i) Name = D_SREPOVARI-REPORTTYPE. Value = RW

ii) Name = D_SREPOVARI-REPORT Value = Your Report Group Name (Say 1SIP)

5) Save and Execute.

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

Regards

Anji

Re: Txn code to Query

Former Member — Wed, 04 Jul 2007 06:06:40 GMT

hi abhishek....

What u did is right...the problem is when u copying the report/program name and pasting it in tcode,.,..just delete the blank spaces in home and the end of the program name...and sav it

it will work

I did one SAP query report for HR yes'day and same i did...

reward me if useful...

sankar

Re: Txn code to Query

Former Member — Wed, 04 Jul 2007 06:11:02 GMT

just delete the spaces

it should be like QA0FI==========ZPP456======== in the program name of the tcode....

sankar

Re: Txn code to Query

Former Member — Wed, 04 Jul 2007 06:12:58 GMT

I faced the similar problem sometime back. Just try to generate the corresponding FG/query again and you will get a new query name. Everytime you generate the FG/query, you will get a different query name. I hope one of them will be without "!", use that in se93 (parameter transaction) and it will work.

Please reward the helpful entries.

Regards,

Raman.