Skip to Content

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.

To report this post you need to login first.

3 Comments

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

  1. 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

    (0) 
    1. 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.

      (0) 

Leave a Reply