CRM Table for Business Partner and User

[Former Member]

Dear CRM Experts,

Is there any table to get the Business Partner by passing the SAP User name.

Thanks & Regards,

Ashok.

[amarnath_kathi]

Ashok,

there are 2 ways:

1) GO TO table HRP1001 and fetch the corresponding OBJID and OTYPE by entering the username in field SOBID.

Next, in the same table, for the same OTYPE and OBJID find the corresponding business partner by entering BP in SCLAS. You will find the business partner number in SOBID field.

2) The second method would be to go to FM BP_CENTRALPERSON_GET fetch the GUID for Username and then go to BUT000 and fetch the corresponding partner number.

Hope this helps.

regards,

Amar.

[Former Member]

Dear Friends,

Thank you very much.It solved my problem.

Thanks & Regards,

Ashok.

[Former Member]

Hi,

No idea about the table.There is a FM-BP_CENTRALPERSON_GET which returns BP Guid if you pass user name to it.

Is it of any help for you?

Thanks and Regards,

Rohit