SAP Query

[Former Member]

Hello Tech Gurus,

I have Created a Query by joining the Tables using the Transactions:sq01,02,03

Also assigned a User Group and Users to the Group.

My Requirement:

I want to use this query as a report to an end user.

Can i create a Transaction and Assign the Query to this Transaction and Add the Transaction to Users Easy Access?

How to Create a Transaction and assign the Query to it>?

Please help...

Point guarenteed.

Thanks

Arshad

[Former Member]

Dear,

jus do one thing

execute your query.

go back and open se38

you will get the program name there.

now you can easily make the t-code for that program.

regards

vijay

[Former Member]

Hi Arshad

Go to SE93 and enter name of the Tcode.

Choose transaction type as Transaction with parameters

For the default value for transaction give START_REPORT

In the Default values for screen fields, give the following

D_SREPOVARI-REPORTTYPE - AQ

D_SREPOVARI-EXTDREPORT - Name of the Query

D_SREPOVARI-REPORT - User Group

Save

Pushpraj

[Former Member]

Hi Arshad,

Try using exits to create a new transactions.

Much Regards,

Amuktha.

[Former Member]

Pls Ignore this

[Former Member]

go through this link

/people/twinkal.patel/blog/2008/08/08/transporting-of-abap-query-from-one-server-to-another-server

[SujeetMishra]

Hello Arshad,

Yes offcourse you can create Transaction Code for Query.SAP has provided all possible facilities to the customer.

you just goto SE38 and create one program.

In program Just do like below :

Data: QUERY LIKE AQADEF-QUNAME,

USERGROUP LIKE AQADEF-BGNAME.

CALL FUNCTION 'RSAQ_QUERY_CALL'

EXPORTING

• WORKSPACE = ' '

QUERY = 'zjhgkku' " put your Query Name Here

USERGROUP = 'zxyh' " put your User Group Here

DBACC = 0

SKIP_SELSCREEN = ' '

• DATA_TO_MEMORY = ' '

• FREE_SELECTIONS =

• IMPORTING

• REF_TO_LDATA =

• LISTTEXT =

• LIST_ID =

• PROGRAM =

• USED_VARIANT =

• TABLES

• SELECTION_TABLE =

• LISTDESC =

• FPAIRS =

• EXCEPTIONS

• NO_USERGROUP = 1

• NO_QUERY = 2

• QUERY_LOCKED = 3

• GENERATION_CANCELLED = 4

• NO_SELECTION = 5

• NO_VARIANT = 6

• JUST_VIA_VARIANT = 7

• NO_SUBMIT_AUTH = 8

• NO_DATA_SELECTED = 9

• DATA_TO_MEMORY_NOT_POSSIBLE = 10

• OTHERS = 11

.

IF SY-SUBRC <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

After this you just Create one tcode for this program.

If any problem then get back to me and inform whether it helped you.

thanks for your appreciation.

Have a Nice Day,

Regards,

Sujeet

Edited by: Sujeet Mishra on Feb 26, 2009 9:36 AM

[Former Member]

Thanks All...

I was able to create a Transaction and assingned to Programe..

I am able to execute the Transaction.

But when i run the Transaction with selection options it gives me a short dump.

-

---

GETWA_NOT_ASSIGNED.....

...................

Short text

Field symbol has not yet been assigned.

What happened?

Error in the ABAP Application Program

The current ABAP program "SAPLAQRUNT" had to be terminated because it has

come across a statement that unfortunately cannot be executed.

What can you do?

Note down which actions and inputs caused the error.

To process the problem further, contact you SAP system

administrator.

Using Transaction ST22 for ABAP Dump Analysis, you can look

at and manage termination messages, and you can also

keep them for a long time.

-

---

No idea what do about this..

Please help

Arshad

[Former Member]

Any Clues on this?

Thanks

Arshad

[Former Member]

Hi Arshad,

I believe you are using the below code in your program. Check whether you are passing all parameters in upper case. If not, please do so. I came across this dump because of case differences.

CALL FUNCTION 'RSAQ_QUERY_CALL'
EXPORTING


WORKSPACE = ' ' 
QUERY = 'zjhgkku' " put your Query Name Here
USERGROUP = 'zxyh' " put your User Group Here

DBACC = 0
SKIP_SELSCREEN = ' '

DATA_TO_MEMORY = ' ' 
FREE_SELECTIONS = 
IMPORTING 
REF_TO_LDATA = 
LISTTEXT = 
LIST_ID = 
PROGRAM = 
USED_VARIANT = 
TABLES 
SELECTION_TABLE = 
LISTDESC = 
FPAIRS = 
EXCEPTIONS 
NO_USERGROUP = 1 
NO_QUERY = 2 
QUERY_LOCKED = 3 
GENERATION_CANCELLED = 4 
NO_SELECTION = 5 
NO_VARIANT = 6 
JUST_VIA_VARIANT = 7 
NO_SUBMIT_AUTH = 8 
NO_DATA_SELECTED = 9 
DATA_TO_MEMORY_NOT_POSSIBLE = 10 
OTHERS = 11 

[Shafiq_Rehman1]

That is not a good way to create the TCode for a query, if you are using above code then it is just a wrapper program to call your query.

You should follow these steps:

1. Get your query's program name:

a. Go to SQ01, select right query area (standard/global), then type in your query name (DO NOT HIT ENTER, DO NOT CLICK DISPLAY/CHANGE).

b. Leaving the name in the box, click on menu "Query" -> "More Functions" -> "Display report name".

c. Copy this report name from here.

2. Go to SE93, give any tcocde, click create, enter description of the tcode, and then choose 2nd option i.e. "Program and selection screen", click ok.

3. Now, in the program field, paste the report name that you copied earlier.

4. Save and activate.

And you are done, you can now use this tcode for your query, but make sure you do not change the name of the query and the query and infoset are generated and ready to use.

[Former Member]

Hi Abdul

I was also facing the same issue i resolved  by below steps

1>go to SQVI t code and  enter your query name and press enter

2>In the menu path select Quick view--> additional functions-->Generate Program

3>After Generating the program In the menu path select Quick view--> additional functions-->Display report Name

4>Now in se38 enter the report name in Program field and execute

5>You will get the Initial Selection screen of the report . Go to Menu of System -->Status

6> Note down the Program name and Screen number

7>Go to SE93 and Create a Z tcode for the query, Enter the description  and importantly you have to select the 2nd Option radio Button Program and Selection Screen (Report Transaction) and Press enter

8>In the next screen enter the Report name In Program field and enter the screen number

9>In the classification Section select Professional user  Transaction

10>In GUI support section select all the options  i.e SAPGUI for HTML,Java,Windows

and save

the system will ask for Package select your package if not there then select local object

now execute the Z tcode your report will run sucessfully

Regards

Vijay hebbal

[Former Member]

Thanks