topic Re: sap query in Application Development and Automation Discussions

sap query

Former Member — Wed, 28 Oct 2009 07:26:55 GMT

Hi,

I have made a sap query by transaction code SQVI, now i want to know the table name where information like user-id , author,infoset is contained. I found that table AQLQCAT CONTAINSI info about query name and infoset but not about user-id..plz help me in this.

Thanks.

Ranjna.

Re: sap query

Former Member — Wed, 28 Oct 2009 07:32:01 GMT

Hi,

First you have to understand that there will be 3 components for SAP Query: Infoset(SQ02), Query(SQ01) and User Group-SQ03

(You can assign Infosets/Queries to the user group)...Hence there is no concept as user id..Atmost you can have the user who created the query/Infoset...

You can set authorization at the user group so that only the users in the specific user group can access the SAP Query...

Below are the main tables:

AQLQCAT: Holds the infoset/Query/User Group for Local Query area(Client Specific)

AQGQCAT:Holds the infoset/Query/User Group for Global Query area(Cross Specific)

Hope this helps

Regards

Shiva

Re: sap query

Former Member — Wed, 28 Oct 2009 07:38:24 GMT

hi,

thanks . I have already checked table AQLQCAT, but it does not contain name of user who created this SAP QUERY, plz help me in this.

Re: sap query

Former Member — Wed, 28 Oct 2009 08:46:10 GMT

Hi,

Check below table that has users in the user group...

AQGDBBG

AQGDBBN

Hope this helps

regards

Shiva

Re: sap query

Former Member — Wed, 28 Oct 2009 09:35:12 GMT

RSAQ_EXIST_CHECK_INFOSET

use this FM

Function module RSAQ_EXIST_CHECK_INFOSET

I_WSPACE G

I_INFOSET ==>infoset name here.

I_VARIANT G

Export parameters Value

O_HEADSG ==>you will get evry thing here