CRM table Relationship

[RahulKeshav]

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,

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.