CRM Tables

[Former Member]

Hi Experts,

I had downloaded customizing adapter objects from ecc to crm. I want to know how to find out the crm table names of adapter objects.

Ex: I had downloaded DNL_CUST_PROD1. I want to know in CRM in which table this data is kept.

How to find out crm table names of adapter objects ?

Kindly help me out experts....

Thanks & Regards,

A.Lakshith Rao

[juergenbaur · Accepted solution]

Hi,

you can see the tables in TA R3AC3.

You can also have a look at table SMOFTABLES.

To see the corresponding CRM tables have a look at the mapping function modules R/3->CRM and vice versa.

[Former Member · Accepted solution]

Hi ,

    comm_prcat ,   comm_category,  comm_applcatgrpr,   comm_prappl_hier and       comm_prcat_user are the CRM  tables that gets updated while you download using DNL_CUST_PROD1 adapter object.

You can find this from the corresponding mapping function module in r3ac3 transaction.

Regards,

Riyas.

[Former Member]

Hi Lakshith,

The adapter object DNL_CUST_PROD1 fetches the basic details like materials, services etc to the crm. These are created under three hierarachies R3PRODSTYP, R3MATCLASS and R3PRODHIER. You can check these using the transaction comm_hierarchy. Under each of these hierarchies, CRM maps the various entities in ECC under corresponding categories. For example, if you have a material group (field matkl) in the MARA table of ECC, the same will be mapped as a category under the R3MATCLASS.

Hope this was helpful.

Regards

Ullas Saffarulla

[Former Member]

Hi,

I did not get your question completely.

If you want  to check the product hierarchies in CRM Check tables COMM_HIERARCHY and COMM_CATEGORY