SAP CRM主要的表关联关系和对应的Function

TABLE	function  module
crmd_orderadm_h	CRM_ORDERADM_H_READ_OB
crmd_orderadm_i	CRM_ORDERADM_I_READ_OB
crmd_customer_h	CRM_CUSTOMER_H_READ_OB
CRM_JSTO,CRM_JEST,CRM_JCDO	CRM_STATUS_READ_OW
crmd_opport_h	CRM_OPPORT_H_READ_OB
crmd_lead_h	CRM_LEAD_H_READ_OB
crmd_activity_h	CRM_ACTIVITY_H_READ_OB
crmd_service_h	CRM_SERVICE_H_READ_OB
crmd_sales	CRM_SALES_READ_OB
crmd_pricing	CRM_PRICING_READ_OB
crmd_orgman	CRM_ORGMAN_READ_OB
crmd_shipping	CRM_SHIPPING_READ_OB
crmd_billing	CRM_BILLING_READ_OB
crmd_survey	CRM_SURVEY_READ_OB
CRMD_PARTNER	COM_PARTNER_READ_DB
SCAPPT,SCAPPTSEG	CRM_DATES_READ_DB
crmd_activity_i	CRM_ACTIVITY_I_READ_OB
CRMD_PRODUCT_I	CRM_PRODUCT_I_READ_OB
crmd_pricing_i	CRM_PRICING_I_READ_OB
crmd_customer_i	CRM_CUSTOMER_I_READ_OB
crmd_service_i	CRM_SERVICE_I_READ_OB
crmd_schedlin	CRM_SCHEDLIN_READ_OB
crmd_link	CRM_LINK_GET_OW

CRM标准表都只有一个主键GUID，这样提升了查询数据的性能，但是怎么关联各表呢？如销售订单表：crmd_orderadm_h（抬头）怎么关联子表呢？

游客，如果您要查看本帖隐藏内容请回复

OBJTYPE_HI，OBJTYPE_SET编号在表：CRMC_OBJECTS的部分含义如下：

NAME	TYPE	DESCRIPTION
ACTIVITY_H	1	Header data activity
PAYPLAN	2	Payment Schedule
OPPORT_H	3	Opportunity header data
ORDER	4	General order processing
ORDERADM_H	5	Administration Header
ORDERADM_I	6	Administration item
PARTNER	7	Partner Quantity
ACTIVITY_I	8	Activity Item Data
PRICING	9	Pricing Data
PRODUCT_I	10	Item Product Data
SALES	11	Sales Data
SHIPPING	12	Shipping Data
LINK	13	Link Handler
MESSAGES	14	Message Handler
CUSTOMER_H	15	Customer Header Data
ORDPRP_I	16	Connection PPR to transaction item
PRICING_I	17	Pricing Data und Results
PRIDOC	18	Pricing document
CONDITION_COM	19	Communication structure condition det.
PRIDOC_COM	20	Communication with price determination
ORGMAN	21	Organizational Data
EVENT	22	Event Handler
SCHEDLIN	23	Schedule Lines
STRUCT_I	24	Item structure data
CONFIG	25	Configuration data item

如：这里的销售订单11对应是SALES，查表如下：

好强大,很好

不错，感谢分享

我只知道其中一部分，感谢LZ分享，收藏学习了

学习一下，感谢分享

很好，很强大

不错不错非常感谢

不错，留下用了谢谢

顶！！！！！！！

好东西呀,楼主太会整理了

非常好的帖子，平时都不知道怎么找FM

楼主好人棒棒棒棒棒棒棒棒棒棒

强大，感谢分享

挺好的,谢谢楼主分享~~

厉害啊，还真是有大神在此

感谢楼主分享

谢谢分享，共同学习

nice job！thanks!

学习..........

不错不错，学习了，谢谢楼主