CRM表前缀分析:
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.