Showing results for 
Search instead for 
Did you mean: 

SAP CRM: Relationship Table Activity - Lead

0 Kudos

I would like to join leads to activities for those activities which are lead related. Which tables are used to set up this relationship? I tried setting up the relationship with the CRMD_LINK table:

As basis I have all activities from CRMD_ORDERADM_H (object type BUS2000125/BUS2000126). Then I'm trying to determine all relationships of those activities by joining the CRMD_LINK table on the activity/order GUIDs. I take the GUID_SET of those relationships and try to join them on the lead objects of CRMD_ORDERADM_H.

However, this does not return any related lead. I guess my approach is false then.

Which tables are needed in this case?

View Entire Topic
Active Contributor


CRMD_LINK is a "glue" table which holds together instance of a single 1order document object (activity, lead, opportunity...), it does not link several document instances...

I guess you look for tables SRRELROLES and CRMD_BINREL. I am sure you will figure out how to use them... 😉

Some objects use other tables for linking but I think for lead-activity link, these should be enough.