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
- e.g : CRMC_OUTPUT_ACGRBP_MAP_SAVE
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
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.
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
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.
Thank You Samantak
It helps a lot, but getting to know the tables in CRM seems like a mission.
Kind Regards
Lizel
Hello,
This is great information and very helpful.
Thank you