CRMD_PARTNER Table with Other table relations
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.
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.