topic Re: Abap Query missing in Dev & Production in Application Development and Automation Discussions

Abap Query missing in Dev & Production

former_member445614 — Mon, 14 Feb 2011 15:12:24 GMT

Hello all,

I've got a query report named AQFKSYSTQV000004ZLISTMAT====== which does not have infoset neither user group assigned, however it can be lauch through SE38.

As seen on FM RSAQ_GENERATE_PROGRAM.


* Namenskonventionen
*
* AQwwbbbbbbbbbbbbqqqqqqqqqqqqqq:
*
*   ww             - 00..99 Mandant 000 bis 099 im Standardbereich
*                    A0..YZ Mandant 100 bis 999 im Standardbereich
*                    ZZ     im globalen Standardbereich
*   bbbbbbbbbbbb   - Benutzergruppe
*   qqqqqqqqqqqqqq - Query

Query: ZLISTMAT

User Group: SYSTQV000004

I already launched START_REPORT with usergroup SYSTQV000004 and query name ZLISTMAT, look up through SAP Notes, report RSAQR3TR import/export utility, but this can't be done because it does not exist in our client

We're on an upgrade from 5.0 to 6.0 and SAP suggests not to tranport OT between different systems.

Question is, how can we find out where Abap Query is defined?

Thank you and have a nice day,

Ruben.

Re: Abap Query missing in Dev & Production

brad_bohn — Mon, 14 Feb 2011 18:35:56 GMT

That isn't an ABAP Query. It's a Quickview (txn SQVI) created by an individual user.

Re: Abap Query missing in Dev & Production

Former Member — Mon, 14 Feb 2011 20:09:54 GMT

Go through transactions SQ01/02/03 and explore things.

Re: Abap Query missing in Dev & Production

brad_bohn — Mon, 14 Feb 2011 20:46:32 GMT


Go through transactions SQ01/02/03 and explore things.

How is that helpful? Perhaps you missed the fact that the transaction is a Quickviewer transaction, not a Query transaction...

Re: Abap Query missing in Dev & Production

Former Member — Tue, 15 Feb 2011 05:07:19 GMT

Hi Ruben,

You could try the following Work around

1. Goto Table TRDIR with your program name and find who created the program. This would mean that the Quick View has been created by the same person.

2. Goto transaction SQ01 in each of the available clients of your system and goto the following path QUERY->Convert Quickview

3. Now give the user name from TRDIR in the field USER and use the F4 of the field Quickview to check if the Query ZLISTMAT exists in the same client. If it does convert it into a ABAP query and then using the download option in SQ02 move the query to the Dev environment and Prod also if required.

Hope this helps.

Re: Abap Query missing in Dev & Production

former_member445614 — Tue, 15 Feb 2011 15:56:27 GMT

Thanks Brad and Dominic for your replies.

I'm still unable to find where is it defined, seems user somehow deleted it, a bit weird.

Re: Abap Query missing in Dev & Production

GauthamV — Tue, 15 Feb 2011 16:26:44 GMT

The query created using SQVI can be seen only by the person that created it.

Only the program genarated can be accessed using custom transaction.

Use TRDIR,TADIR tables and find the user,then using that userid you can see it in SQVI.

Re: Abap Query missing in Dev & Production

Former Member — Fri, 23 Mar 2012 02:43:49 GMT

Do you have idea how to transport genearted program assign to Tcode.

If we run this tcode after transport in Quality system then its says, program not found.