Reg: CRM-Related Tables

[Former Member]

Hi Experts

Can you plz tel relation tables in CRM

for customer, user name, and sales org?

cheers

[Former Member · Accepted solution]

Hi Shankar,

CRM Tables for :

Customer (Business Parter ) : BUT000

User Name : USR02

Sales Org : CRMD_ORGMAN

[Former Member · Accepted solution]

Hi Anand Reddy,

Thanks for the response.

We need tables to find out

1. the users for particular sales organization and

2. Customers in a particular sales organization .

i.e.

1. userid and sales organization fields.. - table name

2. sales organization and customer fields - table name.

Regards,

[Former Member · Accepted solution]

CRMM_BUT_FRG0081 Business Partner - Sales Area - Partner Function

-

---

T Code: se11

put crm*..then search..you will get the list of all the tables..

put t*..then search...the list of tables related to configuration...

you can search by description also..

So that's the list of complete tables in CRM...

-

---

[Former Member · Accepted solution]

hai i am adi.

to know any table is very easy to find, if ur wanna any table name just u keep cosur in the particular filed and press f1, after u'll find one pupop box it contains all technical info about the field.

another pocess is is the same porcess u find the package name of the particular fied, than u goto se11 and press f4 after again u;ll get one more pupop box there u give that package name there u will find the all tables which relation for the particular filed.

all bp related table start with "but" u can use se11 and there u search with but* u can c all the bp related tables.

[Former Member · Accepted solution]

Hi Shankar,

For u r 2nd point u can use CRMM_BUT_LNK0010 it will show u BP extended for which sales org/dc/div.

Regards,

Biplab