Table for Business Partner Details

[Former Member]

Hi Experts,

Is there any table which holds all the internal srm business partner details? I am doing a custom development to allow the user to select internal business partner and add as input the screen using search help.

Thanks

[Former Member]

BUT000 and ADR6 are the tables required.

[Former Member]

Hello,

Please check BBP_LOCMAP table.

Regards,

Neelima

[Former Member]

Hi Neelima,

Thanks for the table info. I am looking for all the users in the system. In the org structure under the user there is business partner id, I want to get all the user bp id and their email id.

[Former Member]

I got some info in BUT000 Table which I should be able to use. is there any linking table to get the email address using partner no or partner guid?