Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

CRM table relationship

Former Member

‎2007 May 22 1:07 AM

0 Likes
1,003

Hi,

is there any one know table relation ship in crm between

customer group and businees partner field.

.

thanks,

jack

Hi,

is there any one know table relation ship in crm between

customer group and businees partner field.

.

thanks,

jack

Reply
1 REPLY 1
Read only

Former Member

‎2007 Jun 22 5:36 PM

0 Likes
492

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.