How to find find query name from program.

[Former Member]

Hello Experts,

I have one question to find query name from program,

Program name - AQL4SYSTQV000347PRODUCT_LIST====

here SYSTQV000347 -> User Group

PRODUCT_LIST --> SAP Query name.

But when i am trying to search same user name in SQ01 both area (Standard/Global), system giving error the user group has not yet created. same error i am getting for query name also.

when i am giving user group name in table AQLQCAT then its showing for that user group query is there and infoset - SYSTQV000000000000009676 also there but when i am trying SQ01 system giving error like not yet created.

Anybody can suggest, There's no particular urgency though.

Thanks.

[Former Member]

Hello Experts,

I have one question to find query name from program,

Program name - AQL4SYSTQV000347PRODUCT_LIST====

here SYSTQV000347 -> User Group

PRODUCT_LIST --> SAP Query name.

But when i am trying to search same user name in SQ01 both area (Standard/Global), system giving error the user group has not yet created. same error i am getting for query name also.

when i am giving user group name in table AQLQCAT then its showing for that user group query is there and infoset - SYSTQV000000000000009676 also there but when i am trying SQ01 system giving error like not yet created.

Anybody can suggest, There's no particular urgency though.

Thanks.

[RaymondGiuseppi]

You cannot find a correct query/group name if it's not a query but a QuickView...

So was not created with SQ01 but with SQVI, and is user-specific. You have first to convert this QuickView to a Query (SQ01, menu Query, Convert QuickView)

• Hint: call transaction SQ03 -> Environment -> Query areas -> Standard Area, then Navigate in Menu -> Settings -> Settings -> check box "Display system objects" and back, F4 on user group will now display users of SQVI, like 'SYSTQV000001' = 'Quickview: USERNAME'
• Ref: 550764 - FAQ SAP Query, 1873955 - How to convert QuickViews to Queries

[bertrand_delvallee]

Hello,

Here is the naming convention :

AQwwbbbbbbbbbbbbqqqqqqqqqqqqqq:

   ww             - 00..99 Mandant 000 to 099
                    A0..YZ Mandant 100 to 999
                    ZZ     in global			
   bbbbbbbbbbbb   - Group
   qqqqqqqqqqqqqq - Query

Are you really connected on client 500? 🙂

Best regards

Bertrand

[JL23]

see my blog how to get there https://blogs.sap.com/2012/03/22/how-to-find-and-execute-or-work-with-other-users-quick-views-or-qui...