SAP CRM Tables 1

zhengl

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 = 连接到与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.