SAP CRM Tables
In SAP CRM development, we do not need to direct access the database table, but for the performance purpose, we need to get data directly from the underlying database table. Below is the list of some important tables in SAP CRM.
CRM Tables
COMM_PRODUCT Products
COMM_HIERARCHY Category Hierarchy
COMM_CATEGORY Category
COMM_CFGMAT Basic Data for Materials
CRMD_ORDERADM_H Business Transaction Header
CRMD_ORDERADM_I Business Transaction Item
CRMD_OPPORT_H Opportunity
CRMD_ACTIVITY_H Activity
CRMD_LINK Link table for Transaction and other data
CRMD_PARTNER Business Partner data
CRMCxxxx = Customising Data
CRMTxxxx = Customising Data
CRMDxxxx = Transaction Data
CRMMxxxx = Master Data
There are some views defined for easily access the transaction data.
CRM Views
BBP_PDVIEW_ACC BBP_PDVIEW_ACC
BBP_PDVIEW_AHI Actual Value- Relevant Header and Item Data
BBP_PDVIEW_BIH Header Information for Backend Items
BBP_PDVIEW_BUP Partner Data Set
BBP_PDVIEW_IAP Item Data: General Purchasing and Purchasing Set
BBP_PDVIEW_LIM Limit Dataset
BBP_PDVIEW_LIST Actual Value- Relevant Header and Item Data
BBP_PDVIEW_LISTV Actual-Value-Relevant Header and Item Data (Versions)
BBP_PDVIEW_ORG OrgData Set