How to Get All Users maintained in PPOMA_BBP

[Former Member]

Hi, Everyone!

I want to know the table or FM which gives the list of users maintained in transaction PPOMA_BBP. As far as I know, NOT ALL users in SU01 are maintained in PPOMA_BBP.

Table USR21 contains user names in the system. Could you help me find the table which contains the users maintained in PPOMA_BBP ?

Thanks and regards,

RE

[Former Member · Accepted solution]

Hi. Transaction BBP_CHECK_USERS will write "User is not integrated into organizational structure" if the user is not in PPOMA_BBP.

You can get the info from table HRP1001, look for the link from US to CP, that means they have been in PPOMA_BBP at some point. If the links are now broken BBP_CHECK_USERS will tell you that as well.

Regards,

Dave.

[former_member206968 · Accepted solution]

Hi,

You can get the list of all users by using FM,BBP_OM_STRUC_GET_USER_FROM_ORG. Enter the root node of your org and you can get all the users.

Regards,

Sanjeev

[former_member186746]

Alternatively you could simply execute transaction PPSS, give thee top organizational object (O) and use an evaluation path to get all the users assigned to it.

EBP-DOWN is a good one.

Kind regards, Rob Dielemans

Ps You can also use program RHINFT00

Edited by: Rob Dielemans on Jun 10, 2009 11:30 AM

[former_member583013]

Hello Reymar,

I made a trace of the user search in pposa_bbp and these are the database tables/views which are used for it:

V_USERNAME Generated Table for View V_USERNAME

V_USEREXST Generated Table for View V_USEREXST

TOLE OLE Applications

T77AW Definition of Evaluation Paths

T777O Object Type Texts

DDFTX Run-time object with Screen Painter texts

T777E Allowed Relationships

T778A Evaluation Paths

T77OS Structure Search

I´d say the first 2 views look pretty promising.

BR

Michael