SAP CRM object ID and business partner relation.

[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

[Former Member]

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

[Former Member]

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