Skip to Content
avatar image
Former Member

SAP CRM object ID and business partner relation.

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 27, 2017 at 12:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded