topic Re: User Data like Function and Department in Application Development and Automation Discussions

User Data like Function and Department

Former Member — Thu, 03 Sep 2009 09:04:45 GMT

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

Re: User Data like Function and Department

Former Member — Thu, 03 Sep 2009 09:23:03 GMT

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

Re: User Data like Function and Department

Former Member — Thu, 03 Sep 2009 09:24:08 GMT

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

Re: User Data like Function and Department

sindhumallavaram — Fri, 22 Sep 2023 14:33:38 GMT

Hello

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

Regards,

Sindhu