middlewear培训

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