User creation date

[Former Member]

Hello

How to get the user creation date from database?

Greetings. P.

[former_member386202]

Hi,

Check table USR01 and USR02

Regards,

Prashant

Message was edited by:

Prashant Patil

[Former Member]

In the table usr02

field name : erdat

give bname: your userid

[Former Member]

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]

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

[Former Member]

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