validating user ID across systems.

[Former Member]

Hi. we all know that the user ID releated credentials are stored in the table USR02 locally. But there is a requirement for me to find out weather the user ID(BNAME) exists across various systems.

Say for ex :I need to give in my SAP user name in a text box and upon clicking display button, will display all the systems and their respective Client number in which the user has account in a table control.

is there any FM or any way to do that ???

[former_member213851]

Hi Karthikeyan,

you can use FM RFC_READ_TABLE to collect USR02 Table Data from various clients by passing system id and separator to FM.Upon receiving data from particular client into Internal table, split it at separator and store it in Column wise manner for further Validations.

Let us assume that now you have USR02 related details in internal tables from DEV, QUAL,PROD.

Now , as per  your system landscape, you will compare the Username entered by User with data in DEV, QUAL,PROD in 3 Different loops. Upon receiving MATCH , you will  append data to Output table and EXIT from loop (Better performance) .

Finally can dispaly details in below Format or Client wise using ALV:

Username | Userid  | Present in DEV  (Yes/No)  | Present in QUAL (Yes/No) | Present in PROD

Best Regards,

Sachin