Skip to Content

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.

/wp-content/uploads/2016/05/clipboard1_946344.png

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

/wp-content/uploads/2016/05/clipboard2_946345.png

/wp-content/uploads/2016/05/clipboard3_946346.png

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

/wp-content/uploads/2016/05/clipboard4_946347.png

Click tab “Mapping Modules:”

/wp-content/uploads/2016/05/clipboard5_946348.png

Double click this subroutine:

/wp-content/uploads/2016/05/clipboard6_946349.png

then double click again:

/wp-content/uploads/2016/05/clipboard7_946350.png

/wp-content/uploads/2016/05/clipboard8_946351.png

MARC: Plant Data for Material in ERP

/wp-content/uploads/2016/05/clipboard9_946352.png

MAKT: Material Descriptions table in ERP

/wp-content/uploads/2016/05/clipboard10_946353.png

Double click this subroutine:

/wp-content/uploads/2016/05/clipboard11_946354.png

Clear enough now?

/wp-content/uploads/2016/05/clipboard12_946355.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:

/wp-content/uploads/2016/05/clipboard13_946356.png

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

/wp-content/uploads/2016/05/clipboard14_946357.png

Please read set type concept from sap help

Then find potential database table which stores product text in CRM using “*” in SE16:

/wp-content/uploads/2016/05/clipboard16_946358.png

And this is just what I am looking for:

/wp-content/uploads/2016/05/clipboard17_946359.png

/wp-content/uploads/2016/05/clipboard18_946360.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply