CRM product table

From the CRM System, I found out the following relationship

Database View : CRMV_PROD_SALESG - Join via Product Master Data, Link and SetType Table(SALESG)

 

Table                        FieldName                     Table                                    FieldName

COMM_PRODUCT     CLIENT     =  COMM_PR_FRG_ROD     CLIENT

COMM_PRODUCT     PRODUCT_GUID     =  COMM_PR_FRG_ROD     PRODUCT_GUID

COMM_PR_FRG_ROD CLIENT                     =  CRMM_PR_SALESG     CLIENT

COMM_PR_FRG_ROD FRAGMENT_GUID     =  CRMM_PR_SALESG     FRG_GUID

 

Table

COMM_PRODUCT - Product

COMM_PR_FRG_ROD - Product Sales Set - Product - Assignment

CRMM_PR_SALESG - Product - Sales Pricing Set

 

备注：

comm_pr*