1、Middleware 培訓德勤管理咨詢2目錄2CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數據同步3CRM 中間件增強將CRM開發字段傳至ERP標準字段4CRM 中間件增強增強ERP傳輸結構5CRM Middleware Monitor633CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數據同步3CRM 中間件增強將CRM開發字段傳至ERP標準字段4CRM 中間件增強增強ERP傳輸結構5CRM Middleware Monitor6目錄4

2、4CRM Middleware提供無縫的后臺集成提供組件集成和移動客戶端同步是完整的CRM服務器的一部分Requires不是第三方軟件不需要安裝不需要額外的服務器Middleware55CRM MiddlewareCRM Server Applications Interaction Center CRM Web Channel (Internet Sales) Marketing Planning and Campaign Management . Business Objects Product Business Partners / Accounts Business Transacti

3、on .CRM 服務器SAP NetWeaver Application ServerXIF Adapter(XML / IDOC)R/3 AdapterMobile ClientAdapterBW AdapterCRM DATABASECRM server Architecture66SAP CRMCRM Middleware SAP ECCSAP R/3R/3 adapterPlug-InCRM 與SAP ECC的數據交換是通過 R/3adapter 與SAP ECC plug-in實現的，R/3 adapter 與Plug-In是通過QRFC調用實現。qRFCSAP CRM : Data

4、 Exchange with SAP Systems77CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數據同步3CRM 中間件增強將CRM開發字段傳至ERP標準字段4CRM 中間件增強增強ERP傳輸結構5CRM Middleware Monitor6目錄88業務對象定制對象條件對象CUSTOMER_MAIN 客戶CUSTOMER_REL 客戶聯系人BUS_TRANS_MSG 銷售合同.主要是ERP中的一些配置信息 如：公司數據工廠數據等.ERP中的定價數據如:DNL_COND_A304 :物料價格DNL_COND_A

5、304 :客戶物料價格.CRM Middleware Adapter Object99Adapter Object是由BDOC及相關配置信息組成。BDOC由兩部分組成:Part1:基本部分，該部分數據是必須的，基本數據是不會mapping到數據庫表的。TCODE SBDM:創建、顯示及增強BDOC。Part2:擴展部分 承載BDOC需要傳輸的數據。具體請查看adapter object(BUS_TRANS_MSG)對應的BDOC:(BUS_TRANSACTION_MESSAGE)Adapter其他配置信息: initial flow contexts:配置數據流的source及target t

6、ables/structures within Object: adapter涉及的表或結構，對于定義對象就是ERP中對應 的數據表，例如DNL_T001W. module mapping:配置的R/3是數據入和出的轉換函數。Adapter Object組成1010BDoc是由SAP系統之間數據傳輸的一種方式。通過Tcode:SMW01能夠查看到CRM與ERP傳輸的Bdoc信息BDOC結構1111BDOC Model1212Object NameObject NameDescriptionDescriptionDNL_CUST_ACGRPBAccounting Group Business P

7、artnerDNL_CUST_ACGPPAccount Group ProductDNL_CUST_ADDRRegional structureDNL_CUST_ BASISBasis CRM onlineDNL_CUST_BASIS2Basis CRM onlineDNL_CUST_BASIS3Basis CRM onlineDNL_CUST_BASIS5Basis CRM onlineDNL_CUST_BASIS6Basis CRM onlineDNL_CUST_BNKABanking MasterDNL_CUST_KTOKDBusiness Partner: Acc. GroupDNL_

8、CUST_PAYPLPayplanDNL_CUST_PRICESales pricing and pricing itemDNL_CUST_PROD0Material number conversions在依賴于ERP系統的CRM系統實施中，要在CRM系統中進行實際業務的前提，就是需要將ERP的業務數據和配置傳遞到CRM系統中，下面就是初始裝載的傳輸對象初始化裝載對象1313Object NameObject NameDescriptionDescriptionDNL_CUST_PROD1Product: categoriesDNL_CUST_PROD3Material: R/3 sales

9、statusDNL_CUST_S_AREAOrganizational Unit: Divisions DNL_CUST_ SALESSalesDNL_CUST_SCESCE varcondDNL_CUST_SHIPSales shippingDNL_CUST_SPRODSales product itemDNL_CUST_T502TBusiness Partner: T502TDNL_CUST_TBRCBusiness Partner: IndustriesDNL_CUST_TKUKLBusiness Partner: TKUKL, TKUKTDNL_CUST_TNLSBusiness Pa

10、rtner: TNLS, TNLSTDNL_CUST_TPFKBusiness Partner: TPFK, TPFKTDNL_CUST_TSABBusiness Partner: TSAB, TSABT初始化裝載對象二1414Object NameObject NameDescriptionDescriptionDNL_CUST_TVASTSales Document Blocking ReasonDNL_CUST_TVFSSales Document Billing: BlockDNL_CUST_TVGFBusiness Partner: TVGF, TVGFTDNL_CUST_TVIPB

11、usiness Partner: TVIP, TVIPTDNL_CUST_TVKNBusiness Partner: AttributesDNL_CUST_TVLSDeliveries: Blocking Reasons/CDNL_CUST_TVPVBusiness Partner: TVPV, TVPVTDNL_PLANTPlant相關配置傳輸完成后，才可以傳輸相關業務對象初始化裝載對象三1515CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數據同步3CRM 中間件增強將CRM開發字段傳至ERP標準字段4CRM 中

12、間件增強增強ERP傳輸結構5CRM Middleware Monitor6目錄1616R3AS:Start Initial Loadfor BusinessAdapter Object1CRS_FIRST_DOWNLOAD_TRIGGERQRFC2InboundMessage FlowOutboundMessageFlowCRM-ApplicationCRMDatabaseMBDOC45ValidationserviceQRFCSpecific ExtractorR/3 InboundAdapterBAPIMTCS3R/3 tableCRMECCInitial Load R/3 to CRM

13、for Business Data1717CRMR/3Queue naming convention: R3AD_業務交易事件BTEOutboundQueueR3AD*R/3 tableInboundQueueR3AD*R/3-AdapterInboundMessageFlowQRFC中間件QRFC隊列命名規范:Inbound queue:CRI* Initial load Qs CRM - CDBCRM_SITE* Load Qs from Mobile ClientsR3A* Load queues ERP Backend - CRMExample: R3AD* = Delta loadC

14、SA* Send inbound Qs of CRM Server AppsOutbound queue:CDB* Start Q for loads CRM - CDBCRM_SITE* Load Qs for Mobile ClientsCSA* Send Qs of CRM Server AppsEXT* Start Qs for loads CRM - Ext.R3AI/R* Start Qs for loads from ERPR3AU* Load Qs CRM - ERP systemDelta Load R/3 to CRM: Data Transfer per QRFC1818

15、CRMR/3CRM API - CRM BDOCmapping moduleCRM_UPLOAD_BTMBDOC_FILL,包含BADI CRM_BTX_EXTENSIONS CRM BDOC - R/3 BAPI CRM_SALESDOC_MAP_MBDOC2BAPI,包含BADICRM_DATAEXCHG_BADI BAPI_SALESDOCU_PROXY_UPLOAD ，包含以下增強。USEREXIT_MOVE_FIELD_TO_VBAKKOMUSEREXIT_MOVE_FIELD_TO_VBAPKOMUSEREXIT_MOVE_FIELD_TO_VBEPKOM(USEREXIT_MOV

16、E_FIELD_TO_VBAK)(USEREXIT_MOVE_FIELD_TO_VBAP)(USEREXIT_MOVE_FIELD_TO_VBEP)(USEREXIT_MOVE_FIELD_TO_VBKD)RFC調用CRM數據傳輸至R/3(以銷售合同為例)1919R/3 API - CRM BAPI CRS_SALES_SEND_TO_SERVERCRM BAPI - CRM BDOC CRM_SALESDOC_MAPBAPI2MBDOCBADI CRM_DATAEXCHG_BADI- CRM_DATAEXCH_R3D_MBDOC_FILLCRM BDOC - CRM API CRM_DOWN

17、LOAD_BTMBDOC_MAPPERBADI CRM_BTX_EXTENSIONS - Method READ_FROM_BDOCR/3 數據傳輸至CRM(以銷售合同為例)2020CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數據同步3CRM 中間件增強將CRM開發字段傳至ERP標準字段4CRM 中間件增強增強ERP傳輸結構5CRM Middleware Monitor6目錄2121由上個Topic的CRM傳輸至R/3可知，自定義字段可以通過BADI CRM_DATAEXCHG_BADI，映射至R/3標準字段 。實

18、現badi 的IF_EX_CRM_DATAEXCHG_BADICRM_DATAEXCH_AFTER_BAPI_FILL 方法。修改對應的CT_BAPI*及CT_BAPI*X即可以銷售合同為例2222CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數據同步3CRM 中間件增強將CRM開發字段傳至ERP標準字段4CRM 中間件增強增強ERP傳輸結構5CRM Middleware Monitor6目錄2323ERP中增強:1.增強結構VBAKKOZ由于VBAKKOM包含VBAKKOZ,所以將需要增強的 字段append至VB

19、AKKOZ即可。2.增強VBAKKOZX結構，原理1。3.增強BAPE_VBAK及BAPE_VBAKX4.增強VBAK5.SE38MV45AFZB FORM USEREXIT_MOVE_FIELD_TO_VBAKKOM. FORM USEREXIT_MOVE_FIELD_TO_VBAK.CRM中增強:IF_EX_CRM_DATAEXCHG_BADICRM_DATAEXCH_AFTER_BAPI_FILL修改 ct_bapiparex lw_bapiparex-structure = BAPE_VBAKAPPEND lw_bapiparex TO ct_bapiparex.lw_bapipare

20、x-structure = BAPE_VBAKX.APPEND lw_bapiparex TO ct_bapiparex.BAPIPAREX結構有4個240字符的字段，所以可以增強的字段空間總限制為960字符以銷售合同抬頭為例2424R3-CRM (R3中的CRM0_200和CRM中的SMOUTIL3)1、 SM30- 編輯TBE24添加一條新記錄 如 product: ZCRMEH_DEMO text: middleware enhancement demo RFC-destination: ACTIVE:X.2、SM30-編輯TPS34添加新記錄，如 Process CRM0_200 Fu

21、nction ZCRM_MW_DEMO_OUT Product ZCRMEH_DEMO 復制 function SAMPLE_PROCESS_CRM0_200 重命名為ZCRM_MW_DEMO_OUT 在該函數里面就可以添加需要傳輸的數據。 SM30-編輯TPS34添加新記錄，如 Process SMOUTIL3 Function ZCRM_MW_DEMO_IN Product ZCRMEH_DEMO 復制 function SAMPLE_PROCESS_ SMOUTIL3 重命名為ZCRM_MW_DEMO_IN 在該函數里面就可添加需要傳輸的數據。 CRM-R3(CRM中的SMOUTIL2和

22、R3中的 CRM0_300)1、 SM30-編輯TPS34添加新記錄，如 Process SMOUTIL2 Function ZCRM_MW_DEMO_OUT Product ZCRMEH_DEMO 復制 function SAMPLE_PROCESS_ SMOUTIL2 重命名為ZCRM_MW_DEMO_OUT 在該函數里面就可添加需要傳輸的數據。2、 SM30-編輯TPS34添加新記錄，如 Process CRM0_300 Function ZCRM_MW_DEMO_IN Product ZCRMEH_DEMO 復制 function SAMPLE_PROCESS_CRM0_300 重命名為ZCRM_MW_DEMO_IN 在該函數里面就可以更新R3中相關數據。BTE增強方式2525CRM Middleware Overview1CRM Mid