如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系
![](https://user-images.githubusercontent.com/5669954/59276364-bb799f00-8c90-11e9-958a-0a3be369fd03.png)
For example, user can maintain description for Material in ERP and Product in CRM:
![](https://user-images.githubusercontent.com/5669954/59276365-bc123580-8c90-11e9-8bf8-087fec91e532.png)
![](https://user-images.githubusercontent.com/5669954/59276367-bcaacc00-8c90-11e9-9a24-e51a92b4e608.png)
How to find the database tables and fields where this description is stored in ERP and CRM seperately?
Log on to a CRM system like AG3/001, tcode R3AC1, Position, type “Material”:
![](https://user-images.githubusercontent.com/5669954/59276373-bd436280-8c90-11e9-9fb9-485e481626f9.png)
Click tab “Mapping Modules:”
![](https://user-images.githubusercontent.com/5669954/59276374-bddbf900-8c90-11e9-9b88-49852271ae79.png)
Double click this subroutine:
![](https://user-images.githubusercontent.com/5669954/59276375-be748f80-8c90-11e9-9f9f-6f0e0ec09668.png)
then double click again:
![](https://user-images.githubusercontent.com/5669954/59276377-bf0d2600-8c90-11e9-9119-211190934cac.png)
![](https://user-images.githubusercontent.com/5669954/59276378-bf0d2600-8c90-11e9-93b5-ff36d4bd7b44.png)
MARC: Plant Data for Material in ERP
![](https://user-images.githubusercontent.com/5669954/59276381-bfa5bc80-8c90-11e9-8620-8876ce9746dd.png)
MAKT: Material Descriptions table in ERP
![](https://user-images.githubusercontent.com/5669954/59276383-c03e5300-8c90-11e9-86a5-944f68b8e456.png)
I will only use subroutine process_mara_data for example to demonstrate how to find field mapping relationship.
Double click this subroutine:
![](https://user-images.githubusercontent.com/5669954/59276386-c0d6e980-8c90-11e9-857a-d5a921522fdf.png)
Clear enough now?
![](https://user-images.githubusercontent.com/5669954/59276389-c2081680-8c90-11e9-8d80-0b43c47d04f9.png)
Note that com_product is not database table but just a structure. The structure is used as input to call product API to save the change triggered from ERP into CRM database table. However in this very case, it is fortunate enough since the database table COMM_PRODUCT has exactly the same name of fields:
![](https://user-images.githubusercontent.com/5669954/59276352-b7e61800-8c90-11e9-9d6d-62fa1873b655.png)
From line 23, keyword “shtext” and “short_text”, we can know the product descrption is modelled as set type in CRM product.
![](https://user-images.githubusercontent.com/5669954/59276353-b87eae80-8c90-11e9-89ec-b87deeaefb13.png)
Please read set type concept from sap help.
![](https://user-images.githubusercontent.com/5669954/59276359-b9afdb80-8c90-11e9-82e8-cf7b2368eabc.png)
result is found:
![](https://user-images.githubusercontent.com/5669954/59276361-ba487200-8c90-11e9-842f-5e6ad1f4113d.png)
![](https://user-images.githubusercontent.com/5669954/59276363-bae10880-8c90-11e9-8645-f766b79e68ca.png)
![](https://user-images.githubusercontent.com/5669954/61616089-2a87e180-ac9a-11e9-861d-c29c2cf897af.png)
相关文章
- 162. 通过一个具体的例子,深入了解 SAP UI5 控件数据双向绑定的工作原理和问题排查方法
- SAP UI5 应用如何采取 JavaScript 代码调用 OData API 读取满足过滤条件的业务数据($filter 操作)试读版
- 通过 SAP UI5 ODataModel API 在 JavaScript 代码里访问 OData 元数据试读版
- SAP UI5 数据绑定之高级技巧 - Type System
- 使用 yo 命令行向导创建 SAP UI5 应用
- 如何将SAP CRM产品主数据页面的assignment block设置成只读
- SAP CRM产品主数据工作流相关调试
- 如何找出 SAP电商云产品明细页面读取后台数据的代码具体位置
- SAP Spartacus产品数据HTTP GET请求前的OPTIONS请求
- SAP CRM产品主数据重要函数COM_PRODUCT_UI_GETDETAIL的调试
- SAP Analytics Cloud里根据数据的经纬度绘制地图
- SAP UI5和Vue的数据双向绑定实现原理比较