CRM table relationship

Former Member — Tue, 22 May 2007 00:07:57 GMT

Hi,

is there any one know table relation ship in crm between

customer group and businees partner field.

thanks,

jack

Re: CRM table relationship

Former Member — Fri, 22 Jun 2007 16:36:39 GMT

Dear Jack,

Following are the CRM Tables:

BUT051 BP Relationship: Contact Person Relationship

Similar to BUT050 , additionally contains Contact Person’s Address data

BUT0BK Business Partner: Bank Data & Details

BP Number, Bank Key, Bank Country Key, Bank Account Number

BNKA Bank Master Data

BUT100 BP: Roles

R/3 Tables re CRM:

CRMRFCPAR : CRM Destination

CRMPRLS: GUID entry

CRMCONSUM: COnsumer entry (must match consumer of object in R3AC*)

KNA1 : Business Partner Master Data.

CRMPARNR : Partner Functions \ Contacts

CRMKUNNR : Business Partner GUIDS

KNVV: Sales Area Data

KNVP: Sales Area Data

KNVK: Contact Person

Regards,

Srilatha.