Skip to Content

CRM table Relationship

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...



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 19, 2008 at 11:02 AM


    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 20, 2008 at 04:55 AM

    Hi Rohit,

    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: Addresses


    BP relationships/role definitions: General data

    Contains Relationship, Partner Number (PARTNER1), Relationship Category


    BP Relationship: Contact Person Relationship

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


    Business Partner: Bank Data & Details

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


    Bank Master Data


    BP: Roles


    Telephone Numbers (Business Address Services)


    SMTP Numbers (Business Address Services)

    Contains Email – Id of the BP.


    Addresses (Business Address Services)

    BP’s 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.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 11, 2014 at 09:11 PM

    Untitled1.jpeg (22.9 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.