topic Re: SQ03 in Application Development and Automation Discussions

SQ03

Former Member — Fri, 01 Feb 2008 06:25:23 GMT

Can any one give me the standard tables related to transaction SQ03.

Thank you for your help in advance.

Sidd.

Re: SQ03

Former Member — Fri, 01 Feb 2008 06:27:54 GMT

Check with the tables below related to USER Details.

USR02

Logon data

USR04

User master authorization (one row per user)

UST04

User profiles (multiple rows per user)

USR10

Authorisation profiles (i.e. &_SAP_ALL)

UST10C

Composit profiles (i.e. profile has sub profile)

USR11

Text for authorisation profiles

USR12

Authorisation values

USR13

Short text for authorisation

USR40

Table for illegal passwords

OBJT

Authorisation objetc table

Reward points if useful.

Re: SQ03

Former Member — Fri, 01 Feb 2008 06:29:08 GMT

Hi,

SQ03 : is used to create user groups for queries because every user have to be in atleast one user group for creating infoset and queries. you have to create a user group and assign your user to that usergroup.

User groups are stored in the table AQGDBBG.

Regards,

Satish

Re: SQ03

Former Member — Fri, 01 Feb 2008 06:30:40 GMT

U can get the details from corresponding infotypes,as tables are called as

infotypes in SAP HR.

U need to pass employee id and can extract his personal details from PA

infotypes which start with PANNNN.NNNN is number for that infotype.

Hope this will give an idea.

Reward if helpful.

Re: SQ03

Former Member — Fri, 01 Feb 2008 06:32:14 GMT

Please change the status of the question , if it is answered.

Re: SQ03

Former Member — Fri, 01 Feb 2008 06:33:34 GMT

Hey sravan,

Thanks for your reply.. But i want to know that when we delete user from perticular usergroup in SQ03 from which table it is deleting the data....

Re: SQ03

Former Member — Fri, 01 Feb 2008 06:48:36 GMT

SAP Transaction Code: SQ03

Report used to generate SQ03 is: SAPMS38S

Re: SQ03

Former Member — Fri, 01 Feb 2008 06:54:40 GMT

Sravan,

I know this... But i am not able to find out the tables.... because in debugging also i have checked ...am not able to find... most of the structures are used in that....

Re: SQ03

Former Member — Fri, 01 Feb 2008 07:05:07 GMT

Hi Sid,

Have you checked table: AQGDBBN ?

Regards

Eswar

Re: SQ03

Former Member — Fri, 01 Feb 2008 07:10:50 GMT

Hey thanks for your reply...Last question.. If i delete user is thing going to update in some other table also....AQGDBBN is one of them....thanks alot for your answer...

Re: SQ03

Former Member — Fri, 01 Feb 2008 07:16:43 GMT

Table: AQGDBBN stores the assigment, so when you delete an assignment it will be deleted from this table.

As far as i know this is the main table related to User Assignments to User Groups.

Regards

Eswae

Re: SQ03

Former Member — Fri, 01 Feb 2008 07:24:51 GMT

Thanks all for your reply....