searching for USER_ID of users who belong to a certain partner category

[Former Member]

Dear experts,

I working in SRM and searching for USER_ID of users who belong to a certain partner category.

As in table BUT000, i have partener number(PARTNER) and partner category(TYPE). But I dont have User IDs in this table. I know in table USR02, there are the full list of user ids(BNAME), but no partner category.

How could i join them togeter?

Is there any table with mapping of partener number and User IDs?

Thanks in advance!

[Former Member · Accepted solution]

Hi,

Select the BP ID from the table BUT000 based on the certain partner category.Then use this BP id and pass it to FM "BUP_PARTNER_GET".This asks for partner_no and provides username through the field XUBNAME.

BR,

Disha.

Pls reward points for useful answers.

[Former Member]

Hi

<u>Please try any of these 2 approaches -></u>

1) You could use BUT000-XUBNAME.

Or get BUT000-PARTNER_GUID and call FM BP_CENTRALPERSON_GET with IV_BU_PARTNER_GUID = BUT000-PARTNER_GUID and get EV_USERNAME. And then read USR01.

2) Using FM BUP_PARTNER_GET, this asks for partner_no and provides username through the field XUBNAME. Although BUT000 also provides XUBNAME but when i entered the partner_no it did not populate XUBNAME hence i had to use the above mentioned Function Module.

<b>Related links -></b>

Hope this will definitely help.

Regards

- Atul