CRM table Relationship

[former_member187457]

Hi All,

I m working on CRM...

i have to get BP data from BUT000 , ADRC, AUSP, ADR6 tables.....

but i dont knw the relationship bw them...

can anyone giveme the solution form this....

Every answer will be awarded...

plz Help...

Thnx

Rohit

[Former Member]

Hi Rohit,

Find business Partner Tables and their relationships as below

BUT000

BP: General data

Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.

BUT020

BP: Addresses

BUT050

BP relationships/role definitions: General data

Contains Relationship, Partner Number (PARTNER1), Relationship Category

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

ADR2

Telephone Numbers (Business Address Services)

ADR6

SMTP Numbers (Business Address Services)

Contains Email – Id of the BP.

ADRC

Addresses (Business Address Services)

BP’s Complete Address Details- City, Country, Post Code, District, Street, Title No Etc

TSAD3T

Table containing the Title text against a Title No.

Note:

Pass the langu key with the

language in which you want the

text.

The Tables BUT020,BUT050,BUT051,BUT0BK,BUT100,BNKA

are directly linked to BUT000

The Tables ADRC is linked to BUT020

The Tables ADR2,ADR6,TSAD3T are linked to ADRC.

I Hope I anwered your question.

Please reward the points if it helps.

Regards,

Madhu

[sumeet_gehlot]

[Former Member]

Hi,

Execute the BUT000 it will give partner number,

go to but020 give the partner number it will addrnumber,

go to adrc pass addrnumber it will give details about the partner.

same like adr2 and adr6, pass addrnumber in these two tables you will get the data.

• BUT000 - contains the key as Business Partner Number – thus other details of business partner such as Category, Type, Name, Language, Country, Contact Person etc can be obtained from it by using the corresponding BP Number.

• BUT020 – ADRC – ADR2 – ADR6 is the link of tables used to get the Address Details of the BP corresponding to Business Partner Number (obtained from BUT000) and the address number from BUT020 table.

Relation between BUT000 and AUSP is PARTNER_GUID

Regards

Srinu

Edited by: sreenivasulareddy eragamreddy on Mar 19, 2008 5:14 PM

[Former Member]

Hi Rohit,

Give me your Email... I'll send you a diagram showing relationships between CRM tables !!!!

Regards,

Ashish

[Former Member]

Hi Ashish,

Could you send this diagram to me? please!

My e-mail is caiqueescaler@hotmail.com

Best Regards,

Caíque Escaler

Edited by: Caíque Escaler on Mar 19, 2008 1:13 PM

[Former Member]

Dear Ashis,

please Could u send me too.. that relationship diagram : ahmadkarmila@gmail.com, thanks

Rgds

Karmila

[Former Member]

Dear Ashis,

please Could u send me too.. that relationship diagram : ashok_ece85@yahoo.co.in thanks

Rgds

Ashok.

[Former Member]

Dear Ashish,

Please share with that CRM tables Diagram. I would be grateful for that send it to (gopalvn at gmail.com)

Thanks in advance

Raghu ram

[Former Member]

Hi Ashish,

could you also send me the diagram please?. My e-mail is alirdg at iies.es

I have another question related to relationship. Does anyone know how to relate the BP (employee) with the user (tab identification). Is there any function or table that relates?.

Thanks and Regards

Alicia

[Former Member]

Hi Ashish,

I would be gratefull if you would forward the diagram to: Moderation: Please see Rules of Engagement

Thanks, Isak

Message was edited by: Leon Limson

[Former Member]

Hi, Ashish!

I'm quite fresh to SAP, and I'm working hard on CRM tables. I've been trying to find some relationship diagram of CRM tables, but none of those links is available. Could you please send me a copy of the diagram? It'll be very much appreciated.

Email     xjxvince@hotmail.com

[Former Member]

This message was moderated.

[Sesh]

Can you please send me the same copy of CRM tables diagram to seshumachavarapu@gmail.com . Thanks in advance.

[GopalakrishnanS]

Hi Ashish,

It would be nice if you share that relationship diagram in this post itself, so that everyone can able to view it and understand the relationship logic.

Thanks.