topic Re: How to make t-code from queary in Application Development and Automation Discussions

How to make t-code from queary

Former Member — Thu, 22 May 2008 06:40:41 GMT

hi, all

Can u tell me how to make t-code from the queary...

Plz... Help me by giving step by step Procedure

Thanks

Jignesh

Re: How to make t-code from queary

Former Member — Thu, 22 May 2008 06:46:01 GMT

Hi,

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.

Refer This:

Regards,

Shiva Kumar

Re: How to make t-code from queary

GauthamV — Thu, 22 May 2008 06:50:12 GMT

hi,

just follow these steps.

whnevr u create a query a program will be generated internally.so whn u execute ur query ,in menu goto system - status and find the oprogram nam ganerated.

now goto se93 , give som znam and select radiobutton report transaction (2nd one) thn give tht program nam there n check down the boxes down n save .

now u can run ur query directly using tht tcode.

reward points if hlpful,

Re: How to make t-code from queary

Former Member — Thu, 22 May 2008 06:52:04 GMT

goto SE93

enter a tcode starting with Y or Z

Then in Transaction Field enter START_REPORT

then in the bottom table control

Name of screen field Value

D_SREPOVARI-REPORTTYPE AQ

D_SREPOVARI-REPORT NAME_OF_GROUP

D_SREPOVARI-EXTD_REPORT NAME_OF_QUERY

then save

select skip initail screen

reward points

Re: How to make t-code from queary

Former Member — Thu, 22 May 2008 06:54:00 GMT

use either SQ02 ans SQ01

or SQVI tr code

for more information please go thru this url:

http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_Create_The_Query.asp

http://goldenink.com/abap/sap_query.html

once you create query system generates a report starting with AQZZ/SAPQUERY/ABAGENCY2======= assing this report to tr code for the same

****************Reward points,if found useful

Re: How to make t-code from queary

Former Member — Thu, 22 May 2008 06:56:27 GMT

Use the following steps.

1. Open T-code SQ01.

2. Select the Query which one you want to create the T-CODE.

3. Just execute the query (Press F8).

4. Open another session and execute T-code SE38.

5. In the program name, you can see like "AQLxxx=========ZROLxxx======="

6. SAP automatically create the program for that query.

7. Then you assign the T-Code using SE93.

Reward if it is useful.

Regards

Raja.

Re: How to make t-code from queary

Former Member — Thu, 22 May 2008 07:02:11 GMT

Hi,

If you want to create a tcode for a query,follow this step,

1) SE93

2) give TCODE NAME->Create -> short text ->select second radio button(if yours is report transaction)

3)give your query name(which contains spl characters,differs from normal program.In general Normal proh starts with Z/Y which doesnt contain spl characters) in program field.

4) SAVE it.it will ask for Package(give package name spicified to a module).(Note: tcode needs not to be activated)

If you have any doubt let me know.

Reward points if it is useful.

Warm Regards,

Mohandoss P.