For example, user can maintain description for Material in ERP and Product in 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”:
Click tab “Mapping Modules:”
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-2mrYw8L0-1605451783323)(https://user-images.githubusercontent.com/5669954/59276374-bddbf900-8c90-11e9-9b88-49852271ae79.png)]
Double click this subroutine:
then double click again:
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-9GthprY0-1605451783325)(https://user-images.githubusercontent.com/5669954/59276377-bf0d2600-8c90-11e9-9119-211190934cac.png)]
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-FYdFJ6HC-1605451783326)(https://user-images.githubusercontent.com/5669954/59276378-bf0d2600-8c90-11e9-93b5-ff36d4bd7b44.png)]
MARC: Plant Data for Material in ERP
MAKT: Material Descriptions table in ERP
I will only use subroutine process_mara_data for example to demonstrate how to find field mapping relationship.
Double click this subroutine:
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-qcYZLbt8-1605451783328)(https://user-images.githubusercontent.com/5669954/59276386-c0d6e980-8c90-11e9-857a-d5a921522fdf.png)]
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.
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-XmJnywJa-1605451783333)(https://user-images.githubusercontent.com/5669954/59276353-b87eae80-8c90-11e9-89ec-b87deeaefb13.png)]
Please read set type concept from sap help.
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-pAvDqvjV-1605451783333)(https://user-images.githubusercontent.com/5669954/59276359-b9afdb80-8c90-11e9-82e8-cf7b2368eabc.png)]
result is found:
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-d9XvMiJg-1605451783334)(https://user-images.githubusercontent.com/5669954/59276363-bae10880-8c90-11e9-8645-f766b79e68ca.png)]
要获取更多Jerry的原创文章，请关注公众号"汪子熙":
