topic Re: Problem in accessing an ABAP Query using SQVI in Application Development and Automation Discussions

Problem in accessing an ABAP Query using SQVI

Former Member — Wed, 22 Oct 2008 08:29:22 GMT

Hi All,

I have a client requirement where I need to get data from an existing query.

But when I try to find the query in the Transaction "SQVI", I am not able to locate it.

I thought this might be because proper roles might not have been assigned to my ID.

But for getting the necessary authorizations, I need to communicate the User Group details to the client.

I am not sure how I find these details. Is there any SAP Tables which store these information?

Is there a table available for all the queries that have been created?

Kindly share your knowledge on this.

Thanks in advance.

Regards,

Keerthi

Former Member — Wed, 22 Oct 2008 08:39:12 GMT

Hi Keerthi,

Please check these tables...

AQDB - SAP Query: Tables and Data

AQGDB - SAP Query: Tables and Data (Global)

AQGDBBG - SAP Query: User Groups

AQGDBBN - SAP Query: Assigning Users to User Groups

AQGDBBS - SAP Query: Assigning Functional Areas to User Gr

AQGIDOC - SAP Query: InfoSet Documentation (Key)

Hope this will help you.

Thanks and Regards

Guru

Former Member — Wed, 22 Oct 2008 08:58:40 GMT

Hi,

Can you tell me which table lists down all the queris available on the system?

Or is there one such table?

I am not able to make head or tail out of the data in the tables you have mentioned, except for the one which lists the User Groups.

Thanks in advance.

Regards,

Keerthi

Edited by: keerthivasan r on Jun 23, 2009 3:33 PM