如何通过阅读代码的方式查出SAP ERP和CRM里物料主数据描述信息的数据库存储表
Recently I am working on a project whose prerequisite is that developer must figure out how a field for example Material description in ERP and Product description in CRM is stored.
For example, user can maintain description for Material in ERP and Product in CRM:
And my aim is to find out which two database tables store the content of the description field in ERP and CRM.
How to find the database tables and fields where this description is stored in ERP and CRM separately?
(1) Log on to a CRM system, tcode R3AC1, Position, type “Material”:
Click tab “Mapping Modules:”
Double click this subroutine:
then double click again:
MARC: Plant Data for Material in ERP
MAKT: Material Descriptions table in ERP
Double click this subroutine:
Clear enough now?
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:
From line 23, keyword “shtext” and “short_text”, we can know the product descrption is modelled as set type in CRM product.
Please read set type concept from sap help.
Then find potential database table which stores product text in CRM using “*” in SE16:
And this is just what I am looking for:
要获取更多Jerry的原创文章,请关注公众号"汪子熙":
相关文章
- SAP UI5 SimpleForm 在 size XL 下的布局开发
- SAP ABAP Gateway Client 的 ABAP 实现,重用 HTTP Connection
- 关于 SAP UI5 所有控件的共同祖先 - sap.ui.base.ManagedObject
- SAP UI5 sap.ui.Device.media.initRangeSet 方法的单步调试
- 通过 SAP 官方帮助网站自学 SAP 业务知识的一种办法
- 我与 SAP 成都研究院吴院长的二三事
- SAP QM 从检验批提取样品
- SAP MM Output Procedure中条件类型里的Requirement是在哪里定义的?
- SAP MM 内向交货单的Relationship Browser II
- SAP OLE中常用的一些方法和属性详解编程语言
- SAP ALV标准范例程序介绍详解编程语言
- [代码]如何上载图片到SAP数据库并显示详解编程语言
- SAP ABAP-ALV选择屏幕字段按需显示demo—自用详解编程语言
- SAP中数据库表长度的界定详解编程语言
- SAP 中session和外部断点设置的区别详解编程语言
- SAP Payment Terms 付款条件详解编程语言
- SAP中委外采购订单发料详解编程语言
- SAP上线时未清采购订单处理详解编程语言
- SAP SE16N手工调试修改表数据详解编程语言
- SAP彭俊松:中国工业互联网的两大“缺憾”与服务贸易的逆差转型之路 | 2020 GIIC
- Oracle与SAP在仓储领域的联姻(仓库oracle和sap)
- 深度比较:SAP vs Oracle(sap与oracle比较)
- 对比:Oracle 与 SAP的优势(oracle 与 sap)
- 聘请高级Oracle与SAP顾问,拓展业务潜力(oracle sap顾问)