Tables to link Business Partner number and User Name

[Former Member]

Hello SAP Experts,

I'm having a hard time looking for the relationship tables that could link the Business Partner numbers with the user name of a user. I have tried to link the BUT* tables, the USR21 table, and several HRP* tables and I can't seem to find a link. For the table BUT000, the field XUBNAME which is suppose to contain the user names of the users are left blank for some reason.

I just want to ask if there is any other table relationships I can check so I can retrieve the User name of a user using his/her BP number or vice versa. Thank you in advance!

Regards,

Romeo

[former_member184741 · Accepted solution]

hi,

i am not sure about tables but you can use FM BP_CENTRALPERSON_GET to get the user name from BP and vice versa. Get the BP guid from BUT000 table and give that to the FM

thanks,

sankar.

[Former Member · Accepted solution]

Thank you very much Sankar!

I'll have to check with our ABAP team if this method is okay. Thanks again!

Regards,

Romeo