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
We need to define the backend system of CRM like R/3 as a site in administration console. Tcode SMOEAC is used for this purpose. All the sites can be retrieved in view SITESELECT.
This image show properties of a site defined in the CRM system. In same case, we need to get the rfc destinaiton of backend system in CRM. There are lots of requirement need RFC destination infomation. Below code can be used as a template to get the backend RFC destination.
Read more…
Tcode:
COMMPR01 Product Workbench
COMM_ATTRSET Maintain Set Types and Attribute
Function Module:
COM_PRODUCT_GUID_GET Determine GUID from External ID
COM_PRODUCT_GETDETAIL_API API for Returning Product Data
Below code can be used to read the set type ata related to a specific product.
Read more…
SAP CRM web channel uses shop management module to add, arrange and configure the shop data for each company/sales area. But the standard setting cannot fulfill the business in the most case, we need to add custom field to the shop. Below are the steps to show how to extend CRM web channel shop data.
Step 1. Extend table CRMM_ISA_SHOP_H. Add a custom append structure to the table.
Step 2. Copy the standard shop read function module CRM_ISA_SHOP_DATA_GET out.
Add the custom field name and value to the extension data of the function module. The max value length of one field is 40. If your field value is larger than 40, you need to split it into several lines and increase the counter. Please refer below code for detail.
Read more…
SAP CRM uses IPC to determine pricing information when creating a business transaction, such as a quotation, sales order, service process or a contract. For example, the system automatically determines the gross price and the discounts and surcharges that are relevant for a specific customer or for a particular date, in accordance with the valid conditions.
From a technical point of view, pricing in CRM still use condition technique to perform pricing. Here you can find a link about condition technique and the process when determining the price.
Reference
http://help.sap.com/saphelp_crm60/helpdata/en/51/0302403d62c442e10000000a1550b0/frameset.htm
If your company has already got ERP system online, you can direct download the configuration data to the CRM system using CRM middleware. The configuration data contains pricing procedure, condition type, access sequence. The condition master data can also be downloaded to the CRM side. If your company uses the standalone CRM system, the consultant will need to configure everything in CRM directly.
Read more…