我在SAP成都研究院做過的CRM中間件的項目其實并不是很多:
1. 2013年下半年和2014年上半年曾經支援過中聯重科和蒙牛的CRM項目相關的中間件問題;
2. 2014年上半年做過一個CRM物料主資料的中間件開發項目;
3. 2014年負責CRM物料主資料的維護工作。
這個清單裡所有的文章都是我在實際開發或者項目過程中遇到問題後記錄下來的心得。2013年直到清明節前，我其實對CRM中間件是一點都不了解的，但是我的老闆Poseidon讓我把這一塊的知識空缺補上，因為将來成都團隊需要負責中間件這塊的維護和持續開發。
我先把SAP中間件教育訓練教程CR500看了一遍，了解了一些基本概念。但是這個教程講的比較籠統，對SAP中間件标準開發人員幫助不是很大。
于是2013年清明節的時候，我把CRM物料主資料這個子產品收到的SAP内部測試人員報的所有的tickets搜尋出來學習了一遍，一共有200多個。有25%的tickets是因為測試人員的配置不正确造成的。我借此又積累了一些如何處理形如”如果遇到XXX的錯誤消息, 可能是因為YYY配置出錯造成”這類問題的經驗。 當我把所有内部tickets過了一遍之後，對中間件的架構代碼有了一定的了解，成為寫下列這些文章的基礎。
我遇到使用中間件時報錯誤資訊的這類問題，分析過程也就下列兩種辦法:
1. 根據錯誤資訊的technical資訊作為關鍵字去Google或者SAP Community上搜尋。如果别人也遇到過同樣問題，那就能節省很多debug時間。
2. 自己debug。
CRM中間件的上傳下載下傳方向的定義，都是以ERP作為主系統(leading system)而言，是以從ERP上抓資料到CRM稱為下載下傳，從CRM主動發送資料到ERP稱為上傳。
以從CRM上觸發從ERP系統下載下傳資料為例。如果下載下傳過程不能按照您期望的工作, 那理論上說，出問題的可能性有以下幾種：
1. 代碼在ERP上從資料庫表中抓取資料時不能正常工作: 沒有抓取到期望的資料;
2. 代碼從ERP資料庫表裡成功抓取到期望資料之後，在把資料發送給CRM之前，由于種種原因(比如配置), 一部分資料被過濾掉了，根本沒有發送到CRM;
3. ERP工作完全正常，期望的資料全部發送到CRM，但是CRM inbound處理時因為配置的原因，在處理這些資料或者試圖存儲到CRM資料庫表時出錯。
這三種可能性分别對應下圖Point1，2，3。
調試的關鍵在于找到針對這三種可能性的調試入口，即在哪裡設定斷點。下面我的原創文章裡有講述。
點選文末的”閱讀原文“, 即可在新打開的頁面裡通過點選超連結直接跳轉到對應的文章。
1. Step by step to debug Product Initial Download in CRM system
2. Step by step to debug Product Initial Download in ERP system
3. How to debug Product Delta download in ERP and CRM side
如何調試增量下載下傳:
<a href="https://blogs.sap.com/2013/11/28/how-to-debug-product-delta-download-in-erp-and-crm-side/">https://blogs.sap.com/2013/11/28/how-to-debug-product-delta-download-in-erp-and-crm-side/</a>
4. How to debug Product initial upload in ERP and CRM system
如何debug上傳:
<a href="https://blogs.sap.com/2013/11/28/how-to-debug-product-initial-upload-in-erp-and-crm-system/">https://blogs.sap.com/2013/11/28/how-to-debug-product-initial-upload-in-erp-and-crm-system/</a>
5. Step by step for IDOC debug
<a href="https://blogs.sap.com/2013/12/16/step-by-step-for-idoc-debug/">https://blogs.sap.com/2013/12/16/step-by-step-for-idoc-debug/</a>
6. An example to fix Generic stop set error status in tcode SMQ1
使用事務碼SMQ1發現outbound隊列裡狀态為STOP的處理方法:
<a href="https://blogs.sap.com/2014/07/28/an-example-to-fix-generic-stop-set-error-status-in-tcode-smq1/">https://blogs.sap.com/2014/07/28/an-example-to-fix-generic-stop-set-error-status-in-tcode-smq1/</a>
7. How to resolve error message IB_CRM_UPLOAD_MSG 025 in equipment replication
案例分析: 如何處理裝置(equipment)下載下傳時的錯誤資訊IB_CRM_UPLOAD_MSG 25
<a href="https://blogs.sap.com/2014/08/27/how-to-resolve-error-message-ibcrmuploadmsg-025-in-equipment-replication/">https://blogs.sap.com/2014/08/27/how-to-resolve-error-message-ibcrmuploadmsg-025-in-equipment-replication/</a>
8. Step by step to download equipments from ERP with hierarchy
如何把ERP裡具有層級結構的多個裝置下載下傳到CRM, 并且層級結構在CRM依然得以保持
<a href="https://blogs.sap.com/2014/09/03/step-by-step-to-download-equipments-from-erp-with-hierarchy/">https://blogs.sap.com/2014/09/03/step-by-step-to-download-equipments-from-erp-with-hierarchy/</a>
9. Step by step to upload equipment from CRM to ERP
如何從CRM上傳裝置到ERP
<a href="https://blogs.sap.com/2014/09/18/step-by-step-to-upload-equipment-from-crm-to-erp/">https://blogs.sap.com/2014/09/18/step-by-step-to-upload-equipment-from-crm-to-erp/</a>
10. An example of how to find database table and field where Material text and product text is stored in ERP and CRM
同一個概念,比如ERP裡叫物料(Material), header資料存在表MARA裡,而CRM叫産品(Product), header資料存在COMM_PRODUCT裡。這篇文章以物料描述資訊這一字段為例，介紹如何去查找這個字段分别是在ERP和CRM哪張表裡存儲的。
<a href="https://blogs.sap.com/2016/05/07/an-example-of-how-to-find-database-table-and-field-where-material-text-and-product-text-is-stored-in-erp-and-crm/">https://blogs.sap.com/2016/05/07/an-example-of-how-to-find-database-table-and-field-where-material-text-and-product-text-is-stored-in-erp-and-crm/</a>
11. A small tip about how to find a given Consolidated Database in Middleware
小技巧: 如何找到對應的Consolidated資料庫表
<a href="https://blogs.sap.com/2016/05/16/a-small-tip-about-how-to-find-a-given-consolidated-database-in-middleware/">https://blogs.sap.com/2016/05/16/a-small-tip-about-how-to-find-a-given-consolidated-database-in-middleware/</a>
12. How to download ERP plant into CRM via request download
<a href="https://blogs.sap.com/2016/09/23/how-to-download-erp-plant-into-crm-via-request-download/">https://blogs.sap.com/2016/09/23/how-to-download-erp-plant-into-crm-via-request-download/</a>
13. How to resolve error message Number not in interval XXX - XXX when downloading a customer from ERP
如何處理這個錯誤資訊:
<a href="https://blogs.sap.com/2016/09/24/how-to-resolve-error-message-number-not-in-interval-xxx-xxx-when-downloading-a-customer-from-erp/">https://blogs.sap.com/2016/09/24/how-to-resolve-error-message-number-not-in-interval-xxx-xxx-when-downloading-a-customer-from-erp/</a>
14. How to deal with error message Form of address 0001 not designated for organization
如何處理這個錯誤資訊：
<a href="https://blogs.sap.com/2016/09/25/how-to-deal-with-error-message-form-of-address-0001-not-designated-for-organization/">https://blogs.sap.com/2016/09/25/how-to-deal-with-error-message-form-of-address-0001-not-designated-for-organization/</a>
15. Why I always see warning message Object is in status Wait when performing a request download
當我們啟動下載下傳時，期望的結果是看到下圖所示的綠燈，提示我們下載下傳處于運作(Running)狀态。但有時我們收到的消息一直是等待(Wait):
這篇文章介紹如何分析引起等待狀态的原因。
<a href="https://blogs.sap.com/2016/09/25/why-i-always-see-warning-message-object-is-in-status-wait-when-performing-a-request-download/">https://blogs.sap.com/2016/09/25/why-i-always-see-warning-message-object-is-in-status-wait-when-performing-a-request-download/</a>
16. How to resolve error message Customer classification does not exist when downloading a customer into CRM
如何處理這個錯誤消息:
<a href="https://blogs.sap.com/2016/09/25/how-to-resolve-error-message-customer-classification-does-not-exist-when-downloading-a-customer-into-crm/">https://blogs.sap.com/2016/09/25/how-to-resolve-error-message-customer-classification-does-not-exist-when-downloading-a-customer-into-crm/</a>
17. How to resolve error message Distribution channel is not allowed for sales organization when downloading customer material info record from ERP
<a href="https://blogs.sap.com/2016/09/26/how-to-resolve-error-message-distribution-channel-is-not-allowed-for-sales-organization-when-downloading-customer-material-info-record-from-erp/">https://blogs.sap.com/2016/09/26/how-to-resolve-error-message-distribution-channel-is-not-allowed-for-sales-organization-when-downloading-customer-material-info-record-from-erp/</a>
18. How to use SAT to measure CRM Middleware inbound processing performance
如何用SAT分析中間件的性能問題
<a href="https://blogs.sap.com/2016/10/10/use-sat-measure-crm-middleware-inbound-processing-performance/">https://blogs.sap.com/2016/10/10/use-sat-measure-crm-middleware-inbound-processing-performance/</a>
19. How to download Service master from ERP to CRM
如何下載下傳Service Master
<a href="https://blogs.sap.com/2016/10/10/download-service-master-erp-crm/">https://blogs.sap.com/2016/10/10/download-service-master-erp-crm/</a>
20. How to resolve /SAPPSPRO/S_MAT_ENHANC_COMM issue during request download
一個filter引起的奇怪問題: 在調試器裡會觀察到一個奇怪的表:/SAPPSPRO/S_MAT_ENHANC_COMM
<a href="https://blogs.sap.com/2016/10/27/resolve-sappspros_mat_enhanc_comm-issue-request-download/">https://blogs.sap.com/2016/10/27/resolve-sappspros_mat_enhanc_comm-issue-request-download/</a>
21. Material Sales Organization and distribution channel mapping logic in middleware
ERP和CRM銷售組織和分銷管道的映射關系:
<a href="https://blogs.sap.com/2016/10/28/material-sales-organization-distribution-channel-mapping-logic-middleware/">https://blogs.sap.com/2016/10/28/material-sales-organization-distribution-channel-mapping-logic-middleware/</a>
22. How to download material division to CRM
如何下載下傳ERP物料的division:
<a href="https://blogs.sap.com/2016/10/28/download-material-division-crm/">https://blogs.sap.com/2016/10/28/download-material-division-crm/</a>
23. Settype CRMM_PR_SALESA attributes mapping logic between CRM and ERP
<a href="https://blogs.sap.com/2016/10/28/settype-crmm_pr_salesa-attributes-mapping-logic-crm-erp/">https://blogs.sap.com/2016/10/28/settype-crmm_pr_salesa-attributes-mapping-logic-crm-erp/</a>
25. Product Sales status handling logic in Middleware
物料銷售狀态(Sales Status)的映射邏輯
<a href="https://blogs.sap.com/2016/11/01/product-sales-status-handling-logic-middleware/">https://blogs.sap.com/2016/11/01/product-sales-status-handling-logic-middleware/</a>
26. How to resolve error message Parent objects have not been downloaded when downloading a BOM from ERP to CRM
<a href="https://blogs.sap.com/2016/11/14/how-to-resolve-error-message-parent-objects-have-not-been-downloaded-when-downloading-a-bom-from-erp-to-crm/">https://blogs.sap.com/2016/11/14/how-to-resolve-error-message-parent-objects-have-not-been-downloaded-when-downloading-a-bom-from-erp-to-crm/</a>
27. How to download BOM from ERP to CRM – relationship STRSET or BOMITM
如何下載下傳BOM
<a href="https://blogs.sap.com/2016/11/27/how-to-download-bom-from-erp-to-crm-relationship-strset-or-bomitm/">https://blogs.sap.com/2016/11/27/how-to-download-bom-from-erp-to-crm-relationship-strset-or-bomitm/</a>
28. Step by step to send IDoc data into external receiver via XIF adapter
IDOC和XIF練習
<a href="https://blogs.sap.com/2016/12/23/step-by-step-to-send-idoc-data-into-external-receiver-via-xif-adapter/">https://blogs.sap.com/2016/12/23/step-by-step-to-send-idoc-data-into-external-receiver-via-xif-adapter/</a>
29. Settype COM_TA_R3_ID – mapping between ERP Equipment and CRM Individual Object
序列号(Serial Number)知識分享
<a href="https://blogs.sap.com/2017/02/08/settype-com_ta_r3_id-mapping-between-erp-equipment-and-crm-individual-object/">https://blogs.sap.com/2017/02/08/settype-com_ta_r3_id-mapping-between-erp-equipment-and-crm-individual-object/</a>
30. Another reason that no IDOC is created for BUS_TRANS_MSG although all system configuration are correctly maintained
IDOC排錯案例分享: 銷售訂單成功儲存之後，系統沒有自動生成對應的BDOC, 怎麼辦？
<a href="https://blogs.sap.com/2017/10/18/another-reason-that-no-idoc-is-created-for-bus_trans_msg-although-all-system-configuration-are-correctly-maintained/">https://blogs.sap.com/2017/10/18/another-reason-that-no-idoc-is-created-for-bus_trans_msg-although-all-system-configuration-are-correctly-maintained/</a>
31. BDOC Content Search tool
自己寫的根據關鍵字搜尋BDOC的工具，收到一個DBS的同僚回報說很有用。
<a href="https://blogs.sap.com/2017/10/27/bdoc-content-search-tool/">https://blogs.sap.com/2017/10/27/bdoc-content-search-tool/</a>
要擷取更多Jerry的原創技術文章，請關注公衆号”汪子熙”或者掃描下面二維碼: