SAP CRM Tables

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

 

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 = 连接到与order相关的其他信息数据表的guid
如: CRMD_PARTNER 是order相关的partner，但表有自己的guid，这些guid在crmd_link中都关联到order header的guid上，所以crmd_link是order的表关系中心，其中的字段：

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.