01-10-2008 3:32 PM
Hi
I have a summary report of customer activities in CRM system
I need to fetch some pricing details from R3 system.
Can anyone suggest me how to do this
Thanks in advance
kar
01-10-2008 3:36 PM
Hi Karthik,
The only way of data flow from CRM to R/3 is through Site Ids.
In SMOEAC you will have to create a R/3 type Site and add Subscriptions and Publications.
'All Business Transactions (MESG)' is the Subscription that takes care of Service Orders as well. For filtering of Service Orders you can use 'Criteria Values' tab and create a 'Filter'.
Data transfer from r3 to CRM.a) Either you can use the ALE Integration between HR and CRM (in this case HR is also the leading system!). For further information on this, check SAP Help:
[http://help.sap.com/saphelp_crm40sr1/helpdata/en/83/5cc2abae8e7848bb3f58d3abeb8bcf/frameset.htm]
b) The other option is to copy the normal R/3 SD sales structure to CRM. Here is the link in SAP Help which describes this:
[http://help.sap.com/saphelp_crm40sr1/helpdata/en/7a/0e153b17031147e10000000a11402f/frameset.htm]
Hope this helps.
Reward if helpful.
Thankyou,
Regards.
01-10-2008 3:40 PM
If you know which table to make select then you can use fm RFC_READ_TABLE with destination
PS:
1. Please donot use this for fetching large amount of data
2. If your system is Unicode enabled then please donot use this.
or
Create your own function module with RFC enabled and make query from CRM system with destination option
a®
01-10-2008 3:52 PM
Hi,
What I typically do with this requirement is create an RFC enabled function module in R/3 to read the data I need. I can then call this from my CRM report and be certain I have up to date information every time I run it.
Regards,
Nick