Abap Query missing in Dev & Production

[former_member445614]

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.

[brad_bohn]

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

[Former Member]

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

[brad_bohn]

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...

[Former Member]

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.

[former_member445614]

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.

[GauthamV]

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.

[Former Member]

Hi

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.