middlewear培訓(xùn)

1、Middleware 培訓(xùn)德勤管理咨詢2目錄2CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數(shù)據(jù)同步3CRM 中間件增強(qiáng)將CRM開(kāi)發(fā)字段傳至ERP標(biāo)準(zhǔn)字段4CRM 中間件增強(qiáng)增強(qiáng)ERP傳輸結(jié)構(gòu)5CRM Middleware Monitor633CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數(shù)據(jù)同步3CRM 中間件增強(qiáng)將CRM開(kāi)發(fā)字段傳至ERP標(biāo)準(zhǔn)字段4CRM 中間件增強(qiáng)增強(qiáng)ERP傳輸結(jié)構(gòu)5CRM Middleware Monitor6目錄4

2、4CRM Middleware提供無(wú)縫的后臺(tái)集成提供組件集成和移動(dòng)客戶端同步是完整的CRM服務(wù)器的一部分Requires不是第三方軟件不需要安裝不需要額外的服務(wù)器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 服務(wù)器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的數(shù)據(jù)交換是通過(guò) R/3adapter 與SAP ECC plug-in實(shí)現(xiàn)的，R/3 adapter 與Plug-In是通過(guò)QRFC調(diào)用實(shí)現(xiàn)。qRFCSAP CRM : Data

4、 Exchange with SAP Systems77CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數(shù)據(jù)同步3CRM 中間件增強(qiáng)將CRM開(kāi)發(fā)字段傳至ERP標(biāo)準(zhǔn)字段4CRM 中間件增強(qiáng)增強(qiáng)ERP傳輸結(jié)構(gòu)5CRM Middleware Monitor6目錄88業(yè)務(wù)對(duì)象定制對(duì)象條件對(duì)象CUSTOMER_MAIN 客戶CUSTOMER_REL 客戶聯(lián)系人BUS_TRANS_MSG 銷售合同.主要是ERP中的一些配置信息 如：公司數(shù)據(jù)工廠數(shù)據(jù)等.ERP中的定價(jià)數(shù)據(jù)如:DNL_COND_A304 :物料價(jià)格DNL_COND_A

5、304 :客戶物料價(jià)格.CRM Middleware Adapter Object99Adapter Object是由BDOC及相關(guān)配置信息組成。BDOC由兩部分組成:Part1:基本部分，該部分?jǐn)?shù)據(jù)是必須的，基本數(shù)據(jù)是不會(huì)mapping到數(shù)據(jù)庫(kù)表的。TCODE SBDM:創(chuàng)建、顯示及增強(qiáng)BDOC。Part2:擴(kuò)展部分 承載BDOC需要傳輸?shù)臄?shù)據(jù)。具體請(qǐng)查看adapter object(BUS_TRANS_MSG)對(duì)應(yīng)的BDOC:(BUS_TRANSACTION_MESSAGE)Adapter其他配置信息: initial flow contexts:配置數(shù)據(jù)流的source及target t

6、ables/structures within Object: adapter涉及的表或結(jié)構(gòu)，對(duì)于定義對(duì)象就是ERP中對(duì)應(yīng) 的數(shù)據(jù)表，例如DNL_T001W. module mapping:配置的R/3是數(shù)據(jù)入和出的轉(zhuǎn)換函數(shù)。Adapter Object組成1010BDoc是由SAP系統(tǒng)之間數(shù)據(jù)傳輸?shù)囊环N方式。通過(guò)Tcode:SMW01能夠查看到CRM與ERP傳輸?shù)腂doc信息BDOC結(jié)構(gòu)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系統(tǒng)的CRM系統(tǒng)實(shí)施中，要在CRM系統(tǒng)中進(jìn)行實(shí)際業(yè)務(wù)的前提，就是需要將ERP的業(yè)務(wù)數(shù)據(jù)和配置傳遞到CRM系統(tǒng)中，下面就是初始裝載的傳輸對(duì)象初始化裝載對(duì)象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初始化裝載對(duì)象二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相關(guān)配置傳輸完成后，才可以傳輸相關(guān)業(yè)務(wù)對(duì)象初始化裝載對(duì)象三1515CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數(shù)據(jù)同步3CRM 中間件增強(qiáng)將CRM開(kāi)發(fā)字段傳至ERP標(biāo)準(zhǔn)字段4CRM 中

12、間件增強(qiáng)增強(qiáng)ERP傳輸結(jié)構(gòu)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_業(yè)務(wù)交易事件BTEOutboundQueueR3AD*R/3 tableInboundQueueR3AD*R/3-AdapterInboundMessageFlowQRFC中間件QRFC隊(duì)列命名規(guī)范: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 ，包含以下增強(qiáng)。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調(diào)用CRM數(shù)據(jù)傳輸至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 數(shù)據(jù)傳輸至CRM(以銷售合同為例)2020CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數(shù)據(jù)同步3CRM 中間件增強(qiáng)將CRM開(kāi)發(fā)字段傳至ERP標(biāo)準(zhǔn)字段4CRM 中間件增強(qiáng)增強(qiáng)ERP傳輸結(jié)構(gòu)5CRM Middleware Monitor6目錄2121由上個(gè)Topic的CRM傳輸至R/3可知，自定義字段可以通過(guò)BADI CRM_DATAEXCHG_BADI，映射至R/3標(biāo)準(zhǔn)字段 。實(shí)

18、現(xiàn)badi 的IF_EX_CRM_DATAEXCHG_BADICRM_DATAEXCH_AFTER_BAPI_FILL 方法。修改對(duì)應(yīng)的CT_BAPI*及CT_BAPI*X即可以銷售合同為例2222CRM Middleware Overview1CRM Middleware Adapter Object介紹2CRM與R3數(shù)據(jù)同步3CRM 中間件增強(qiáng)將CRM開(kāi)發(fā)字段傳至ERP標(biāo)準(zhǔn)字段4CRM 中間件增強(qiáng)增強(qiáng)ERP傳輸結(jié)構(gòu)5CRM Middleware Monitor6目錄2323ERP中增強(qiáng):1.增強(qiáng)結(jié)構(gòu)VBAKKOZ由于VBAKKOM包含VBAKKOZ,所以將需要增強(qiáng)的 字段append至VB

19、AKKOZ即可。2.增強(qiáng)VBAKKOZX結(jié)構(gòu)，原理1。3.增強(qiáng)BAPE_VBAK及BAPE_VBAKX4.增強(qiáng)VBAK5.SE38MV45AFZB FORM USEREXIT_MOVE_FIELD_TO_VBAKKOM. FORM USEREXIT_MOVE_FIELD_TO_VBAK.CRM中增強(qiáng):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結(jié)構(gòu)有4個(gè)240字符的字段，所以可以增強(qiáng)的字段空間總限制為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 復(fù)制 function SAMPLE_PROCESS_CRM0_200 重命名為ZCRM_MW_DEMO_OUT 在該函數(shù)里面就可以添加需要傳輸?shù)臄?shù)據(jù)。 SM30-編輯TPS34添加新記錄，如 Process SMOUTIL3 Function ZCRM_MW_DEMO_IN Product ZCRMEH_DEMO 復(fù)制 function SAMPLE_PROCESS_ SMOUTIL3 重命名為ZCRM_MW_DEMO_IN 在該函數(shù)里面就可添加需要傳輸?shù)臄?shù)據(jù)。 CRM-R3(CRM中的SMOUTIL2和

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