Modify existing SAP Query / Quickview
We have a requirement to modify an existing SAP Query. This query was created much earlier by a user who is no longer present.
We have the query name, user group, and the program for the query. This query, we assume was created using tcode SQVI.
However, in tcode SQVI, we cannot see the query as we have not created it.
I understand that this is because the quick view has not been converted to query.
I have referred:
In tcode SQ01, we are unable to see the query, as we get an error that the user group does not exist.
In table AQLTQ, we get an entry for the query and the user group. But the user group does not exist in tcode SQ03 as well.
In this case, how to we convert the quickview to query? Or is there any other way to edit the exisitng quickview/query?
Suhas Saha replied
There exists an entry only in AQLQCAT(Local or Client-dependent queries).
In that case you're looking in the wrong "Query Area". You've to change the area from Global(Cross-client) to Local(Client-specific)!
Menu -> Environment -> Query Areas -> Standard Area(Client-Specific)
I hope you'll find your Query, Infoset, User group as well.