Request: CRM Database Tables

[Former Member]

Hi Experts,

I am new to sdn and also new to CRM. Would anyone please send me the CRM database tables used for the Application components like Organization Management,Territory Management,Opportunities,Lead Management,Activities Management,Business partners, Products etc,. I appreciate your responses.

Thanks a lot.

With Regards

Nagamani.

[former_member927251]

Hi,

Please have a look at the following thread. Here I have mentioned CRM tables.

<b>Please reward points if it helps.</b>

Regards,

Amit Mishra

[Former Member]

Hi

CRM TABLES

Tables:

BUT000 - Business Partners

CRMD_ORDERADM_H - Business Transaction Header

CRMD_CUSTOMER_H - Business Transaction Header Extensions

CRMD_CUTOMER_I - Business Transcation Item Extensions

COMM_PRODUCT - Product Header Table

Tables starting with BUT are generally business partner specific

To find BADI's in CRM do the following:

in SE18 with the definition name being blank hit F4.

In the following popup choose SAP Applications. You will then get the SAP application hierarchy and you can drill into the CRM component to find most BADI's.

Another easy way of finding CRM code works this way:

IN SE80 do the following:

1. In the left hand navigator when displaying the Repository Browser choose Application Hierarchy.

2. It will then show packages as your option and then hit the display icon.

3. Bingo you now can see the packages related to components of CRM. Very useful for finding code related to a business function of CRM.

Last trick. Go to SD11. The data modeler for anyone who hasn't use it.

BP - Is the data model for business partner

PRM_PROD - Is the data model for products.

COMM_PRODUCT - Product Master

COMM_PRMAT - Product material Data,

COMM_PRODUCT_IDX - Index For Products

COMM_PROD_FRG - Poruct Type

COMM_PRPRDCATR - Product Category Assignment

COMM_PR_FRG_REL - Product Set Assignment

COMM_PR_FRG_ROD - Product Sales Set/Product Assignment

COMM_CATFRGR - Assignment Category - Set Type

COMM_PRCATFRGR - Assignment Product Category

COMM_CATEGORY - Category

COMM_HIERARCHY - Hiearchy

COMC_SETTYPE - Set Type

- BADI for Customer Specific Attributes for Replication: PCAT_IMS_FEED_ATT

- BADI For Customer Specific Eval of Attributes of Replication: PCAT_IMS_FEED_VAL

- BADI for Customer Specifc Adjustment of Price Relevant Data: PCAT_CNDPRICE

- BADI for Create/Change Catalog Char. List and Catalog Item: PRODCAT_LOC_UPDATE

- BADI for Changes in Product Master: COM_PROD_MNT_UPD, Implementation: COM_PROD_MNT_PCAT

- BADI for Changes in Interlinkages: INTERLINKAGE_UPDATE, Implementation: INTERLINK_UPD_PCAT

- BADI For Product Catalog Changes: PRODUCT_UPDATE, PRODUCT_UPDATE_IMS, PRODUCT_UPDATE_CVIEWS

[KaushalShah]

Here is a basic list. Hope it helps.

COMM_PRODUCT : Products

CRMC_T077D : customer account groups

CRMD_ORDERADM_H (for header) CRMD_ORDERADM_I (Item data)

CRMD_ORDERADM_H Business Transactions CRM

CRMD_ACTIVITY_H Activity

CRMD_OPPORT_H Opportunity

BUTOO : Customer details

BUT001 BP: General data II

BUT100 BP: Roles

BUT150 BP relationship: Attribute table (test

different

BUT_HIER_TREE Business Partner Group Hierarchy

CDBC_T_PRODUCTID Mapping: Product Id

CDBD_ORGMAN Business transaction - organizational unit -

set

COMC_PRODUCT General Product Settings

COMC_R3_FIELDS Assignment of R/3 material master fields to

CFOP

COMM_CATEGORY Category

COMM_CFGMAT Basic Data for Materials

COMM_HIERARCHY Category Hierarchy

COMP_TYPES Hierarchy Tool: Comparison Type Check

Table

CRMC_CPRICPROC Customer Pricing Procedures

SMOKVBEZ15 Assignment employees to positions

Regards,

Kaushal