Quick Vewer Program Transport in Quality

[Former Member]

Dear Expert,

I done the query throught QueryViewer. Create a T-Code through SE93. Its working fine in Development. But when I transaport in Quality It won't be work. it showing error "Program "AQL4SYSTQV000008Z_WIPEXPIRYDT= " not found."

Just i want to ask how to transport QueryViewer program in Quality. Is i miss the step.

Please Help out..

Pravin Kadam

[Former Member]

Dear Expert,

I done the query throught QueryViewer. Create a T-Code through SE93. Its working fine in Development. But when I transaport in Quality It won't be work. it showing error "Program "AQL4SYSTQV000008Z_WIPEXPIRYDT= " not found."

Just i want to ask how to transport QueryViewer program in Quality. Is i miss the step.

Please Help out..

Pravin Kadam

[deepak_dhamat]

hi ,

Once again check Program AQL4SYSTQV000008Z_WIPEXPIRYDT is there in QA or not

or confirm it with sq01 .

Regards

Deepak.

[Former Member]

How do i check through SQ01? Please explain me the step.

regards,

Pravin Kadam

[deepak_dhamat]

Hi ,

1)Enter transaction SQ01

2)enter the query which you have generated / if query is not there it means that query is not created or transported properly .

3)then execute the query it will show inital parameter screen .

4) go to system in menu bar -> status -> Program name .

Regards

Deepak.

[Former Member]

Dear Expert,

I entered in SQ01 "Z_WIPEXPIRYDT" and executed than i got the message "Query Z_WIPEXPIRYDT has not yet been created" in quality.

Please tell me how can i Transport the Query in Quality server with step.. if possible

Regards.

Pravin Kadam

[StD11]

For queries generally is better to create transaction of parameters (D_SREPOVARI-REPORTTYPE = AQ) than transaction for report which is generated by query because name of report is different on different clients.

Second in quick views is possible that you have different group on different clients. Is better to copy it to different type of query preferably in global area which is connected to transport system. This is not so important if you make sure that query exist in the same user group in all clients you want to execute it.

[Former Member]

Dear Dagmar,

How can i check the Different Group of SQL query?? Where r the define the Group?

Please help out from the headech...

I m new in SQL query viewer...

Regards,

Pravin Kadam

[StD11]

Go to DEV where query is working.

In SQ01 switch on Display system objects (Menu - Settings - Settings). Switch to standard query area too (Enviroment - Query areas).

Then go to User groups and you will see in F4 help whose quickview Z_WIPEXPIRYDT is. You can check it on both systems.

You can export it by transport utility in User groups maintenance (Menu - Environment - Transports).

But as I have written I would copy it to SAPquery (by copy utility in Goto - More functions - Copy functions ) or even move it to global area (transport utility) which is connected to transport system. Quick view is more likely for personal use only.

[_IvanFemia_]

Hi,

You need to regenerate the query from SQ01.

It's better to create a TCode in order to avoid this kind of problems, see this blog [Associate SAP Query to a Transaction Code|http://www.plinky.it/blog/2009/08/28/associate-sap-query-to-a-transaction-code/]

Regards,

Ivan

[Former Member]

Hello,

Once we successfully transport the TR containing the Queries, we need to goto target system and then import the query also. Otherwise, you will keep getting the error.

For this, goto transaction SQ02, press on transport button and import the query.

Hope this helps,

Regards,

Himanshu

[Former Member]

Helpful Comment..

Thease are link also very usefulll

/community [original link is broken]

threadID=837863

/community [original link is broken]threadID=1453987