SAP CRM业务数据分析.doc

SAP CRM业务数据分析CRM开发有两个难点，一个是业务逻辑，一个就是Web Client UI开发。对于SAP ERP大家都很熟悉了，网上可以搜到详细的表和关系图。而CRM是全新的设计，和ERP完全不一样。如何了解CRM的业余逻辑？T-code,crmd_order, 这个界面可以查看销售订单，业务活动等CRM的业务数据。而Function Module就是CRM_ORDER_READ,我们测试的时候可以使用同名的program。输入订单号（Transaction Number）然后返回了相关的所有数据，比如抬头，明细，活动，产品，价格，销售, Appointment, Partner, Status, Billing,Shipping,客户，服务等。当然不同的活动类型包含不同的数据。注意调用的时候有个参数，Objects to be read，限制读取的项目。在很多地方，甚至BW抽取的时候都是调用了crm_order_read这个function module的。里面有包含了很多function，最后到各个透明表里取数据。在CRM里查询订单的时候是很慢的，就是因为后台调用的是庞大的crm_order_read。是不是可以调小一点的function来改善性能呢？我在ABAP方面是打酱油的，作为外行，总结了史上最全的crm 表。TABLEfunction modulecrmd_orderadm_hCRM_ORDERADM_H_READ_OBcrmd_orderadm_iCRM_ORDERADM_I_READ_OBcrmd_customer_hCRM_CUSTOMER_H_READ_OBCRM_JSTO,CRM_JEST,CRM_JCDOCRM_STATUS_READ_OWcrmd_opport_hCRM_OPPORT_H_READ_OBcrmd_lead_hCRM_LEAD_H_READ_OBcrmd_activity_hCRM_ACTIVITY_H_READ_OBcrmd_service_hCRM_SERVICE_H_READ_OBcrmd_salesCRM_SALES_READ_OBcrmd_pricingCRM_PRICING_READ_OBcrmd_orgmanCRM_ORGMAN_READ_OBcrmd_shippingCRM_SHIPPING_READ_OBcrmd_billingCRM_BILLING_READ_OBcrmd_surveyCRM_SURVEY_READ_OBCRMD_PARTNERCOM_PARTNER_READ_DBSCAPPT,SCAPPTSEGCRM_DATES_READ_DBcrmd_activity_iCRM_ACTIVITY_I_READ_OBCRMD_PRODUCT_ICRM_PRODUCT_I_READ_OBcrmd_pricing_iCRM_PRICING_I_READ_OBcrmd_customer_iCRM_CUSTOMER_I_READ_OBcrmd_service_iCRM_SERVICE_I_READ_OBcrmd_schedlinCRM_SCHEDLIN_READ_OBcrmd_linkCRM_LINK_GET_OW读取逻辑是怎么样的呢？由订单号transaction NO.获得订单抬头GUID crmd_orderadm_h-GUID. 根据抬头GUID 在crmd_orderadm_i里获得明细的GUID.其他的数据大概是一个逻辑：从crmd_link 输入抬头或明细GUID获得GUID_SET. 在CRMD_PARTNER，crmd_activity_h等这些表中GUID对应crmd_link-GUID_SET.而在下表是从crmd_link中返回的数据，根据OBJTYPE_HI，OBJTYPE_SET的编号来判断是什么对象。GUID_HIGUID_SETOBJTYPE_HIOBJTYPE_SET4A6600CA0E62087EE10080000A80800C4A6600CE0E62087EE10080000A80800C5304A6600CA0E62087EE10080000A80800C4A6601030E62087EE10080000A80800C5464A6600CA0E62087EE10080000A80800C4A6601340E62087EE10080000A80800C5214A6600CA0E62087EE10080000A80800C4A6601350E62087EE10080000A80800C594A6600CA0E62087EE10080000A80800C4A6601360E62087EE10080000A80800C574A6600CA0E62087EE10080000A80800C4A66013C0E62087EE10080000A80800C5114A6600CA0E62087EE10080000A80800C4A6601550E62087EE10080000A80800C5294A6600CA0E62087EE10080000A80800C4A66015B0E62087EE10080000A80800C512这个编号是代表的含义在CRMC_OBJECTS中查询得到：NAMETYPEDESCRIPTIONACTIVITY_H1Header data activityPAYPLAN2Payment ScheduleOPPORT_H3Opportunity header dataORDER4General order processingORDERADM_H5Administration HeaderORDERADM_I6Administration itemPARTNER7Partner QuantityACTIVITY_I8Activity Item DataPRICING9Pricing DataPRODUCT_I10Item Product DataSALES11Sales DataSHIPPING12Shipping DataLINK13Link HandlerMESSAGES14Message HandlerCUSTOMER_H15Customer Header DataORDPRP_I16Connection PPR to transaction itemPRICING_I17Pricing Data und ResultsPRIDOC18Pricing documentCONDITION_COM19Communication structure condition det.PRIDOC_COM20Communication with price determinationORGMAN21Organizational DataEVENT22Event HandlerSCHEDLIN23Schedule LinesSTRUCT_I24Item structure dataCONFIG25Configuration data item。可以看出5，6是订单抬头和明细，11 销售数据，7是合作伙伴。Appointment是SCAPPTSEG-APPL_GUID,SCAPPT-APPL_GUID对应crmd_link-guid_set. Product是根据行项目GUID从CRMD_PRODUCT_I中查询的。CRMT-CodeSE19 Badi implementation SE93 Transaction code check smw01 workflowCrm_Erms_mailforms Forms SWDD ERMS Rule modler workflow SE 18 BADi creationSE19 Badi implementation se11 tablesSE38 al module reports/fields displayse11 crmd_orderadm_hSE16 TC TSTC SE93 Application Component - get there displayed all transaction codes for example crm-md-bpCRMD_ORDER? - creating marketing sales and service transactions BP?-? BPCRM_MKTPL FOR search campaigns dealssost-transmissionRequest formsscot -administration system statusCRM_UI_: Access BSP WD work benchBP -Business Partner (Creation/View/Modification)CIC0 -Customer Interaction CentreCRMD_ORDER - CRM Transaction (Create/View/Modify)SPRO - Configuration related settings CRMD_CALL_LIST-Create/ Maintain Call listIB51 / IB52 / IB53-Ibase Creation / Change / ViewCOMMPR01-Maintain ProductsPPOSA_CRM-Display Organizational ModelSBDM-Bdoc maintenanceSMOEAC- Administration console CRM MiddlewareSMQ1,SMQ2 Queue monitoring transactions for inbound and outbound queues.SMW01 Transaction for monitoring bdocs.MIddleware t-codeTransactions Transaction CodesWork process overview SM66 CPU and memory consumption ST06SAP memory and buffers ST02Database performance counters ST04Memory consumption per user SM04 (on each application server)Table call statistics ST10CPU & Memory Consumption on IPC Server OS07CRM Inbound Queue SMQ2CRM Outbound Queue SMQMonitor Load R3AM1Define Request R3AR2Run Request R3AR4Request Business Partner CRMM_BUPA_MAPSend Business Partner CRMM_BUPA_SENDRFC statistics (client and server) ST03Errors in transactional RFCs SM58BD