User Data like Function and Department

[Former Member]

Dear all

I have to do a 1 time extraction of the user data. I need to know as in SU01 the Name, firstname, Function and Department.

I can not find in which table I can find the function and department.

Can somebody tell me where this information is stored and how the link to the user is made?

thank you

Herbert

[Former Member]

Hi,

Try the View USER_ADDR u shall get the funciton and the department ..

Hope this helps in solving the issue ..

Best of Luck !!!

Regards

Ravi

[Former Member]

Hi Herbert,

I found the data element for the function field (AD_FNCTN) from the screen and did a where-used to get table ADCP. This is keyed on Person number and Address number. You'll get these from table USR21.

There may also be a function module to get this data, but these are the tables you need.

Regards,

Nick

[sindhumallavaram]

Hello

Try using USER_ADDRS for the function and the department fields..

Regards,

Sindhu