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
Edited by: sreenivasulareddy eragamreddy on Mar 19, 2008 5:14 PM
please Could u send me too.. that relationship diagram : email@example.com, thanks
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
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.
Find business Partner Tables and their relationships as below
BP: General data
Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.
BP relationships/role definitions: General data
Contains Relationship, Partner Number (PARTNER1), Relationship Category
BP Relationship: Contact Person Relationship
Similar to BUT050 , additionally contains Contact Persons Address data
Business Partner: Bank Data & Details
BP Number, Bank Key, Bank Country Key, Bank Account Number
Bank Master Data
Telephone Numbers (Business Address Services)
SMTP Numbers (Business Address Services)
Contains Email Id of the BP.
Addresses (Business Address Services)
BPs Complete Address Details- City, Country, Post Code, District, Street, Title No Etc
Table containing the Title text against a Title No.
Pass the langu key with the
language in which you want the
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.