SQ03

[Former Member]

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

Thank you for your help in advance.

Sidd.

[Former Member]

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.

[Former Member]

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....

[Former Member]

SAP Transaction Code: SQ03

Report used to generate SQ03 is: SAPMS38S

[Former Member]

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....

[Former Member]

Hi Sid,

Have you checked table: AQGDBBN ?

Regards

Eswar

[Former Member]

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...

[Former Member]

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

[Former Member]

Thanks all for your reply....

[Former Member]

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

[Former Member]

Hi

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.

[Former Member]

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