topic Re: User creation date in Application Development and Automation Discussions

User creation date

Former Member — Fri, 30 Nov 2007 08:11:11 GMT

Hello

How to get the user creation date from database?

Greetings. P.

former_member386202 — Fri, 30 Nov 2007 08:13:15 GMT

Hi,

Check table USR01 and USR02

Regards,

Prashant

Message was edited by:

Prashant Patil

Former Member — Fri, 30 Nov 2007 08:13:24 GMT

In the table usr02

field name : erdat

give bname: your userid

Former Member — Fri, 30 Nov 2007 08:21:52 GMT

Hello Piotr

Table USH04 ... The field PROFS with value C will be the user creation date..

D for deletion .. Check the first character for field PROFS

This will give you the time in addition to the date as compared to USR02-ERDAT

Regards,

Arun

Former Member — Fri, 30 Nov 2007 08:34:03 GMT

And how to find which plant/shop (WERKS) that user belongs to?

Former Member — Fri, 30 Nov 2007 08:47:12 GMT

Hi Piotr

Not sure.. one way could be to check the authorization objects or the roles/profiles...

check authorization object M_MATE_WRK

Regards

Arun