如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

For example, user can maintain description for Material in ERP and Product in CRM:

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

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”:

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

Click tab “Mapping Modules:”

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

Double click this subroutine:

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

then double click again:

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

MARC: Plant Data for Material in ERP

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

MAKT: Material Descriptions table in ERP

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

I will only use subroutine process_mara_data for example to demonstrate how to find field mapping relationship.
Double click this subroutine:

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

Clear enough now?

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

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:

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

From line 23, keyword “shtext” and “short_text”, we can know the product descrption is modelled as set type in CRM product.

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

Please read set type concept from sap help.

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系

result is found:

如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系 要获取更多Jerry的原创文章,请关注公众号"汪子熙": 如何自行查找SAP ERP的物料主数据和CRM产品主数据的映射关系
上一篇:【集合】HashSet 源码分析


下一篇:大数据成神之路-Java高级特性增强(HashSet)