Question:
Hi,
Is there any documentation out there where I can get information
about the cross reference tables from R/3 to CRM! Could some one
please point me to the right direction! I could not find any on sapnet.
I appreciate any help! Thanks
JM
Answer:
Hi
There is no direct correlation between the tables in R/3 and CRM. CRM uses new relationships called GUIDs which relate tables to each other. i.e. it is far harder to find the link between tables and in some case you need to use a function module to convert GUIDs (GUIDs are hexadecimal fields). SAP hold on very tightly to these relationships! Intellectual capital I have been told!
Regards
Answer:
Hi
In general most of the table of SD and MM you will find in the SAP CRM system. In general the table names have changed. The customer table KNA1 in R/3 is named SMOKNA1 in the CRM. Most tables have been extended ba the prefix SMO. Not all tables in the CRM system have equivalent tables in r/3. The tables for appointments exist only in CRM.
In all CRM Tables you find additional columns with GUIDīs in. This is that for the mobile application a replication mequanism is required. This mequanism uses GUIDīs to replicate data. But for most purpose you can still use the standard R/3 idīs (e.g. Customer Number) to build relations. Of course you can use the GUIDīs for the relation which is more exact.
Martin Schneider
ms@ab-on.com
Answer:
Hi,
CRM has two DB's CDB and CRM, The CDB is used for Mobile Sales and CRM for CRM on-line, the datamodel for the CDB resembles the R/3 datamodel KNA1 > SMOKNA1 etc. However the CRM datamodel is completly different! And not even all fields are defined in the same way. For example the Search-term fields in CDB anr R/3 have a different length in CRM! What cases some suprises...
Answer:
Hi,
In addition to suggestion given by other members, Pl. refer to CRM 2.0C set up and down load guide and Adapter frame work. One of these documents has relation betn R/3--CRM online and CDB tables.
_________________
Cheers!!!
Dev