Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.



Former Member replied

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.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question