CRM-relation tables

[Former Member]

Hi Experts

Can you plz tel relation tables in CRM

for customer, user name, and sales org?

cheers

[Former Member]

hi

These are some important tables in CRM :

- 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 Person's 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) - BP's Complete Address Details- City, Country, Post Code, District,

Street, Title No Etc

- TSAD3T Table containing the Title text against a Title No.

- COMM_PRODUCT Master Table for Product

- CRMM_BUAG Master table for Business Agreement

- CRMM_BUAG_H Header Data for Business Agreement such as Tax Category, Tax Characteristic, Form key, Business Agreement Class. Data in this table correspond to ISU

- CRMD_OPPORT_H OPPORTUNITY HEADER DATA

- CRMD_ORDERADM_H Contains the Header Information for a Business Transaction.

Note:

1. It doesn't store the Business Partner responsible for the transaction. To get the Partner No, link it with

CRM_ORDER_INDEX.

2. This table can be used for search based on the Object Id(Business Transaction No).

- CRMD_OPPORT_H OPPORTUNITY HEADER DATA

- CRMD_CUSTOMER_H Additional Site Details at the Header Level of a Business Transaction

- CRMC_PROC_TYPE Master table Business Transaction Type

- CRMC_PARTNER_FCT Definition of Partner Functions

- SCPRIOT Priorities for Activities with priority text.

- CRMC_PROC_TYPE_T Text for a transaction type

- CRMC_ACT_OBJ_T Objective Number and Text for Activities

- TJ30T All the status code and text

- CRMC_PR_ASSIGN : Transaction Type and its Transaction Type Object.

- IBIB : Installed Base/Ibase

- IBIN : Installed Base Components

Reward points if useful,

Thanks,

Usha

[Former Member]

hi Usha garu,

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]

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]

Please refer the following links

http://help.sap.com/saphelp_nw04/helpdata/en/6c/8a568832e85d4082c306df14e7cbf1/frameset.htm

List of tables in CRM .

CRMADPTST1 Adapter Test - Header Table

CRMADPTST2 Adapter Test - Lower-Level Table

CRMAHR Check Results Management: Personal Data

CRMAHRA Check Results Management: Personalization

CRMAHRROL Check Results Management: Positions

CRMAHRROLT Check Results Management: Role Description

CRMA_MKTPL_CPGNM APO Integration: Match CRM and generated A

CRMATAB Tables Permitted for Customizing Download

CRMBW_BWRFC_MAP Dialog RFC Destinations for BW Systems

CRMBWCVSYSTAT BBP/CRM: Mapping BW Status / OLTP System S

CRMBWCVUSSTAT Customizing: Mapping BW Status/ OLTP User

CRMBWIDSSAMPLE Assignment of DataSources to Samples

CRMBWSTT Text Table for BW Status

CRMBWSYSTATGRP BBP/CRM: BW Status Object Group for System

CRMBWSYSTATGRPT BBP/CRM: BW Status Object Group for System

CRMBWSYSTATOBJ BBP/CRM: BW Status Object for System Statu

CRMBWSYSTATOBJT BBP/CRM: BW Status Object for System Statu

CRMBWTARGETS Data Targets for BW Upload

CRMBWT_ATTR Attribute Definition for Attributes Determ

CRMBWT_ATTRS Status Administration: Status of the Data

CRMBWT_ATTRT Text Table for Attribute Definition

CRMBWT_ATTR_VAL Texts for Attribute Values

CRMBWT_ATTR_VALT Check Table for Attribute Values

CRMBWTGTDEF Data Target Check Table for BW Upload

CRMBWTGTDEFT Data Target Check Table for BW Upload - Te

CRMBWT_OIC_SRC Query for OIC

Reward Points if useful.

[upen_Chinnari7]

CRMV_PROD_SALESA  - CRM Product + Sales area table Name