Skip to Content

CRMD_PARTNER Table with Other table relations

Hi All

Why and how partner function table values are dynamically created in SRM. What could be the reason?. GUIDs are different from the other Table GUID.

This GUIDS are not related to But000/CRMD_ORDER* table

Appreciate your assistance.

regards

Muthu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 05, 2008 at 02:14 PM

    Hi Muthu,

    The table CRMD_PARTNER is mainly to store the partner function values of a procurement document. The main reason why the partner function values are stored in separate table is due to the fact that the actual business partner for individual documents will be different (i.e. Requestor can be anyone employee).

    This GUID is different for them because it is a separate transaction data (every procurement data can be considered as a separate transaction).

    Please find the logic how to link them to procurement documents?

    1). CRMD_ORDERADM_H -> Pick the GUID and pass it to table CRMD_LINK ( to the field GUID_HI).
    2.) Select the GUID_SET where OBJTYPE_HI = u201C05u201D and OBJTYPE_SET = u201C07u201D
    3) Pass the GUID_SET value to table CRMD_PARTNER (to the field GUID)

    You will get all the associated partners for the particular procurement document.

    The field PARTNER_NO in table CRMD_PARTNER is the actual GUID of the Business partner. You can use this to relate to the table BUT000.

    Hope this clarifies.

    Regards

    Kathirvel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2013 at 09:58 AM

    Hi Kathirvel,

    There one scenario in which I have to transfer the Service Tickets of One group  to the other  group in Org. Structure, Could please tell how I can Change the Parter No in CRMD_partner table, So that this ticket well get associated to the owner to the Group.

    Also please tell us what will be the impact of changing the Partner No in CRMD_Partner table, to other link tables.

    Thanks in advance.

    Thanks

    Regards,

    Pradeep Singhal

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Working on a similar issue in CRM, but similar setup.

      You have the highlighted join incorrect. From what I see, CRMD_PARTNER-PARTNER_GUID is a unique key for that table and cannot be repeated, and therefore not suitable for your join to BUT000. You need to use the PARTNER_NO to join to BUT000.

      CRMD_ORDERADM_H GUID = CRMD_LINK GUID_HI

      CRMD_LINK GUID_SET = CRMD_PARTNER GUID

      CRMD_PARTNER PARTNER_GUID = BUT000 PARTNER_GUID

      BUT000 PERNO = ADR6 PERSNUMBER

      CRMD_ORDERADM_H GUID = CRMD_LINK GUID_HI

      CRMD_LINK GUID_SET = CRMD_PARTNER GUID

      CRMD_PARTNER PARTNER_NO = BUT000 PARTNER_GUID

      BUT000 PERNO = ADR6 PERSNUMBER

      Regards,

      Justin