CRM tables / concepts

[alejandro_bindi]

Hello, i'm an abapper and i've been working in ERP (R/3) projects in the past, now i'm getting involved in a CRM one.

I'd like to have a comprehensive list of CRM tables and a list of basic concepts in the CRM world (i.e. Business Partner, Campaign, and such) with brief explanation of each.

Already found this link for tables: http://www.sap-img.com/general/find-the-table-names-for-a-crm-transaction.htm

But i'd like to have a more complete list.

Also, how is developing in CRM different from doing it in R/3?

Note: i've searched for simmilar threads and found some links to downloadable documentation, but couldn't get it since it is inside OSS.

Many thanks, I'll reward points for useful answers.

Regards

[Former Member · Accepted solution]

Hi,

Following are the CRM Tables:

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

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

CRMMLSGUID: GUID entry (should match GUID in CRMPRLS)

CRMM_BUT_CUSTNO : Also GUID table (GUID here should match GUID in R/3 table CRMKUNNR)

SMOFSUBTAB : Mapping & Parameters

SMOFDSTAT : Download Monitor (R4AM1)

SMOFFILTAB : Filters (Should match filters in R3AC1 & R/3 Table CRMFILTAB)

SMOFOBJECT Definition of Objects for Download

SMOFOBJPAR Parent Objects of an Object in Table

SMOFPARSFA Middleware Parameter

SMOFQFIND Queue Finder Table for MW-Queue finder

SMOFTABLES Definition of Tables for Download

Visit the following thread:

Regards,

Naveen.

[alejandro_bindi · Accepted solution]

Some quotes from

both

your posts:

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

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

I may add, this text is also in the link I initially said I already had found.

Please, try to post something helpful. A graphic with the relations between the main tables (as exists for R/3 on the net) would certainly be helpful.

Regards

[Former Member]

Hi,

List of <b>SAP CRM</b> Tables are:

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

CRMMLSGUID: GUID entry (should match GUID in CRMPRLS)

CRMM_BUT_CUSTNO : Also GUID table (GUID here should match GUID in R/3 table CRMKUNNR)

SMOFSUBTAB : Mapping & Parameters

SMOFDSTAT : Download Monitor (R4AM1)

SMOFFILTAB : Filters (Should match filters in R3AC1 & R/3 Table CRMFILTAB)

SMOFOBJECT Definition of Objects for Download

SMOFOBJPAR Parent Objects of an Object in Table

SMOFPARSFA Middleware Parameter

SMOFQFIND Queue Finder Table for MW-Queue finder

SMOFTABLES Definition of Tables for Download

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

In general:

CRMCxxxx = Customising

CRMTxxxx = Customising

CRMDxxxx = transactional

BUT* = Customer Master

BUT000 = ~KNA1 Customer Master General Data

BUT020 = Address Link Table

ADRC = Address Details (Master Data)

ADRV = Address Details (unique to orders)

CRMC_PARTNER_FT = Partner function Description

PRCD_COND = Pricing Conditions

CRM_JEST = Status Table

COMM_PRODUCT = Materials General Table

SCATTSEG = Valid from/ Valid to

CRMD_ORDERADM_H = Document Header Table

CRMD_ORDERADM_I = Document Line item Table

CRMD_LINK = &#36830;&#25509;&#21040;&#19982;order&#30456;&#20851;&#30340;&#20854;&#20182;&#20449;&#24687;&#25968;&#25454;&#34920;&#30340;guid

&#22914;: CRMD_PARTNER &#26159;order&#30456;&#20851;&#30340;partner&#65292;&#20294;&#34920;&#26377;&#33258;&#24049;&#30340;guid&#65292;&#36825;&#20123;guid&#22312;crmd_link&#20013;&#37117;&#20851;&#32852;&#21040;order header&#30340;guid&#19978;&#65292;&#25152;&#20197;crmd_link&#26159;order&#30340;&#34920;&#20851;&#31995;&#20013;&#24515;&#65292;&#20854;&#20013;&#30340;&#23383;&#27573;&#65306;

GUID_HI = Header/ Line item Guid

OBJTYPE_HI:

‘05’ = Header

‘06’ = Line item

GUID_SET = Subset GUID

OBJTYPE_SET:

‘07’ = Partners

‘11’ = Sales

‘21’ = Orgman

‘29’ = Subject

CRMD_SALES = Sales Data

(reference data)

CRMD_SHEDLIN = Schedule Line item

CRMD_ORGMAN = Organisational Data

CRMD_PRODUCT_I = Line item product detail

PROCESS_QTY_UNIT (EUR)

Example: You want to list all complaints that partner no 31 appears as a header partner, and the partner functions:

Select PARTNER_GUID from the table BUT000.

Get all instances of that partner in the order/partner table:

Select GUID PARTNER_FCT from CRMD_PARTNER

Where PARTNER_NO = BUT000-PARTNER_GUID.

Then get the order guid from the link table:

Select GUID_HI from CRMD_LINK

Where GUID_SET = CRMD_PARTNER-GUID.

Get the Order No:

Select OBJECT_ID from CRMD_ORDERADM_H

Where GUID = CRMD_LINK-GUID_SET.

Regards,

Amit