How to Extract Partners involved in CRM Opportunity from CRM to BW

[Former Member]

Hi, guys,

Do you know how to extract Partners involved in CRM Opportunity from CRM to BW?

My business wants us to extract the Partners and their functions based on CRM Opportunity from CRM to BW. The T-code in CRM system is: CRMD_BUS2000111 in CRM system.

For example, when you enter a transaction no. in CRMD_BUS2000111 , you can find the opportunity item detail information, then the involved partners (such as prospect; OEM; third Party; employee responsible) will be displayed in the partner tab.

Anyone who has used this information or extracted it to BW?

Which DataSource I can use for this extracting?

Which Tables in CRM I can refer to for this information?

Thanks.

Carina

[shawn_xiao]

Hi Carina,

May you please try datasource 0CRM_OPPT_ATTR, 0CRM_OPPT_ATTR_I, 0CRM_OPPT_I, 0CRM_OPPT_H ?

Hope my answer helps.

Best Regards,

Shawn

[Former Member]

Hi, All,

Anyone has this experience?

Your answer will be very appreciated.

Thanks in advance.

Carina