Skip to Content
Author's profile photo Former Member

Determine the associated CRM table of the Adapter Objects

I have been working in SAP CRM WebUI, ABAP-CRM and Middleware.  I have been searching for the CRM tables which are relevant to the Adapter Objects; I haven’t seen any relevant information in any blogs/Papers on this topic. After 2 hours of debugging I got the below information. I am contributing my first blog, hope it will be useful to the community


Display object using R3AC1/R3AC3/R3AC5.

In this case we are looking at customizing for Account Group Business Partner: DNL_CUST_ACGRBP.


In the Table/Structures tab can view the associated R/3 tables which will be transferred during download process. That will be much better if we can see this table information in the SMOFTABLES.


Chek the same tables in ECC side in SE11/SE16.

   R/3 account group  :       ‘TVKT’.


   R/3 account group  text :       ‘TVKTT’.


In order to determine relevant table in CRM side, need to review code contained within mapping module of the download object. In tab Mapping Module R/3 to CRM select the associated module name



As Highlighted, We can see the mapping between ECC and CRM tables.

                     Table in  R3

             Table in CRM





Table in the CRM :

CRMC_ACGRBP :  Account Assignment Groups for Business Partner


CRMC_ACGRPBP_T : Business Partner Account Assignment Group


Same process can be followed for all Objects in order to identify mapping between R/3 and CRM table.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Lizel de Villiers
      Lizel de Villiers

      Hi Shyam

      Thank you for your clear explanation.  I am also struggling with this mapping between ERP and CRM.

      I'm looking for the Object containing Table MVKE and CRMV_PRC_GRP5, so the other way around.  I went through all the Objects in Building Block B09 and displayed the tables via transaction R3AC3 - Tables/Structures tab.

      But cannot find the object to import.

      Kind Regards


      Author's profile photo Samantak Chatterjee
      Samantak Chatterjee

      Hi Lizel,

      The adapted Object - MATERIAL has the table MVKE mapped to it in the Business Adapter Object. The CRMV_PRC_GRP5 is a view and the table CRMC_PRC_GRP5 is part of it. This table is mapped to the Customizing Adapter Object - CUST_PRDGRP_WRI.

      Hope this helps.


      Samantak Chatterjee.

      Author's profile photo Lizel de Villiers
      Lizel de Villiers

      Thank You Samantak

      It helps a lot, but getting to know the tables in CRM seems like a mission.

      Kind Regards


      Author's profile photo LuckyBoy Kho
      LuckyBoy Kho



      This is great information and very helpful.


      Thank you