Querry for User Data

[Former Member]

Hello SAP experts,

I have a question, when i whant to see a users data i go to transaccion SU01 and consult from there, i whant to make a querry where i can see all of the users data for example:

-Name : German Rodriguez

-Phone number : 44564736

-building: factory1

-Blocked: yes , no

-e-mail address:......

etc, so i whant to know what tables should i use for extracting that data, and also i whant to know if it is possible to find a table that shows if that user is blocked or no, thank you in advanced for your help

[Former Member]

Hello,

I recommend that you use transaction ST05 to perform an SQL trace when you run tcode SU01 to display all your data.

ST05 will allow you to find the tables yourself, because it will display all SQL statements that where executed during the execution of your transaction.

Start trace in ST05

Execute your transaction

Stop trace in ST05

Analyze the result and use transaction SE16 to check the actual table data

I think this will be usefull to you, success.

Wim Van den Wyngaert