on 03-19-2008 10:58 AM
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
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 Persons 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)
BPs 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Can you please send me the same copy of CRM tables diagram to seshumachavarapu@gmail.com . Thanks in advance.
User | Count |
---|---|
6 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.