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.

/wp-content/uploads/2014/09/1_531238.jpg

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.

/wp-content/uploads/2014/09/2_531254.jpg

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

   R/3 account group  :       ‘TVKT’.

/wp-content/uploads/2014/09/3_531255.jpg

   R/3 account group  text :       ‘TVKTT’.

/wp-content/uploads/2014/09/4_531256.jpg

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

  1. e.g : CRMC_OUTPUT_ACGRBP_MAP_SAVE

/wp-content/uploads/2014/09/5_531257.jpg

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

                     Table in  R3

             Table in CRM

                      TVKT

        CRMC_ACGRBP

                      TVKTT

        CRMC_ACGRBP_T

Table in the CRM :

CRMC_ACGRBP :  Account Assignment Groups for Business Partner

/wp-content/uploads/2014/09/6_531258.jpg

CRMC_ACGRPBP_T : Business Partner Account Assignment Group

/wp-content/uploads/2014/09/7_531259.jpg

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

Assigned Tags

      4 Comments
      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

      Lizél

      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.

      Thanks,

      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

      Lizel

      Author's profile photo LuckyBoy Kho
      LuckyBoy Kho

      Hello,

       

      This is great information and very helpful.

       

      Thank you