Skip to Content
Former Member
Jul 04, 2007 at 06:18 AM

basic concept


Hi Experts,

What is the use of link tables in CRM?

For example, I am having a item-header(CRMM_PRPADM_H) table whose GUID is the parent GUID in item-item table(CRMM_PRPADM_I). The GUID of the item-item table is the parent GUID of the item-product link table(CRMM_PRP_PROD_) and the GUID of the link table is inturn is the product id of the product master(COMM_PRODUCT table.

Why can't we directly map the item GUID to the product master table?

Why we need a product-item link table in between? What is its significance?