CRM Serial Number / Sales Order Link

[former_member447950]

Hello,

I am looking to find the link (either via table or fm) between sales order and serial number in CRM. Ideally, when a user provides a serial number, we want to be able to find the corresponding sales order.

Here is what I have found so far:

• Table COM_TA_R3_ID has the serial number
• From here, I can take the product GUID and enter it into COMM_PRODUCT which returns a record
• I can also take the product GUID and do a query on table COMM_IL_PRDBP (SOURCEGUID = product GUID). This gives me the partner GUID (field DESTINGUID)
• Using the partner GUID, I can get the partner number in BUT000 and then can find all orders of this partner but cannot limit this by serial number

I have not been able to find a direct link. I have also checked function module CRM_ORDER_READ but this did not provide any relationship either. Does anyone have any ideas or information on this?

Thank you!