Skip to Content
0

SAP CRM object ID and business partner relation.

Jul 24, 2017 at 09:15 AM

140

avatar image
Former Member

Hi,

There is a clent requirement to create a FM, where the user ID (Business partner ID) will be the input and transaction ID (Object ID), status, creation date, descriction will be the output. Could you please help me to get the realtion between the business id and and object ID table? Thanks in advance.

Regards,

Ashis

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jul 24, 2017 at 01:24 PM
0

Hi Ashis, you will have to mentin the partner function that the BP has in the transaction. Not to mention the transaction type you want to search for.

The tables you need are BUT000, CRMD_ORDERADM_H, CRM_LINK and CRMD_PARTNER. Check the joins on the 4 tables here:

https://wiki.scn.sap.com/wiki/display/CRM/SAP+CRM+datamodel

Regards,

Andrei

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 27, 2017 at 12:51 PM
0

Hi Andrei,

Thank you for your response. But I am facing the problem getting the exact records.

I can understand the tables those you have mention to get the records but when I go through all the table level then I didn't get all the transaction that are done by business partner. So could you please share me how I can get all the transactions that are created or updated by the business partner? It will be very much helpful to me.

Thanks & regards,

Ashis

Share
10 |10000 characters needed characters left characters exceeded