cancel
Showing results for 
Search instead for 
Did you mean: 

finding relation between BP and order ( service/ sales )

Former Member
0 Kudos

Hi,

Is there any table or RFC, that can be used to find list of orders ( service/ sales ) created by a particular Business partner.

Thanks & Regards,

Sanjay.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Here's my approach:

1. Get the user name which is assigneg to the BP:

CALL FUNCTION 'CRM_CENTRALPERSON_GET' with IV_PARTNER_GUID = your BP GUID.

It will return in EV_USERNAME the name of the user who created the order.

2. Select from CRMD_ORDERADM_H those opportunities with CREATED_BY equal to the value returned above (EV_USERNAME).

Hope it helps,

David

Former Member
0 Kudos

Hi,

If you search for

CRMPORTALORDER* You will get the RFC. It gives all orders based on many paramters including BP number.

Regards,

Abdul Raheem S

KaushalShah
Active Contributor
0 Kudos

CRMD_ORDERADM_H-GUID = CRMD_LINK-GUID_HI

CRMD_LINK-GUID_SET = CRMD_PARTNER-GUID

Hope this helps.

Regards,

Kaushal