SAP ME Userlist (with status)

[erbsha]

Hello Experts,

i would like to get a list from all active SAP ME Users.

In SAP ME (Base 15.4.0.10 Counter 202103161457) there is no report for an Userlist.

If i use the Acitivity "User Maintenacne" an choose over the "UserID:" the "choose to browser" Button i got a userlist with more than 400 User.

If i use the WebSQL Utility 1.0 (/manufacturing-admin/) with "select * from usr" i got an different userlist to the User Maintenance. This list show the created user form the system (in our E-System 40 Users)

I need a report for all SAP ME User with the status.

• Status: Terminated
• Status: Active

Is there any possibility to get an userlist with the status?

Thank you and best regards,

Hannes

[ajit3204]

Hi Hannes,

User list in user maintenance comes from Netweaver UME DB for those who have at least one SAP ME related role is assigned and user from USR table is only the users who has been assigned to a Site in SAP ME that is the reason you see different number of users in both the places.

Report part:

Better you can use USR table so you will only those user list who has been assigned to at least one SAP ME site and check the user status in UME using Illuminator services provided by SAP MII because SAP ME does not store the user status in USR table.

Regards,

Ajit Kumar

[Kevin_Hunter]

Hi Hannes,

If you take a look at the database guide you will see that there is no field in the USR table that tells you if a user is active or terminated but it does have a TERMINATION_DATE field. I would assume the user interface is looking at this field and if its empty or the date is in the future then they are active and if the date is in the past they are terminated.

Also the reason you get a different list is that the USR table contains all the users for all the plants so you need to filter the data using a WHERE SITE= "xxxxxx" statement.

Here is a sample query you could use that checks if the TERMINATION_DATE field is empty.

Hope this helps

Thanks

Kevin

[erbsha]

Hi Kevin,

thanks for the proposal. The Problem is we don't use the termination date. Maybe we should use the date for the future.

Best Regards, Hannes