Skip to Content

CRM tables / concepts

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 25, 2007 at 04:39 AM

    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:

    CRM

    Regards,

    Naveen.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Aug 25, 2007 at 12:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded