In CRM, in the middleware partner-exchange context, there are very userful tables where we can check the data exchanged.

The table CRMM_BUT_CONTNO retains the contact persons information. The ORG_GUID represents the partner guid, the PERSON_GUID represents the contact person guid, and the CONTACT_NO represents the number in R3 (the relation between a partner guid and a partner number is in table BUT000). In R3, the corresponding table is CRMPARNR.

The table CRMM_BUT_CUSTNO retains the contact persons information. The PARTNER_GUID represents the partner guid, and the CUSTOMER_NO represents the number in R3. There, the corresponding table is CRMKUNNR.

See if this may be helpful to you

Buffering the organization structure in SAP CRM, will improve performance when you need to read organizational data.

For that, a report HRBCI_ATTRIBUTES_BUFFER_UPDATE should be scheduled to run every night. But be careful, this report should only run after midnight for buffering the current day. If not, organizational data may be not available, and inconsistencies may occur.

For more information, check SAP Library.

At SAP CRM, do you need a good Function Module to get all documents related to a partner?

Check out if CRM_BUPA_READ_ORDER_OBJECTS is the answer for you.We have a good feeling that it is!

Building blocks are a very useful resource that SAP offers to you to help configuring a vast set of scenarios.
They’re  simple step-by-step instructions and they’re also called SAP best practices.

If you need a guide to start your CRM project, here’s a good starting point:
- Building blocks CRM 2007
- Building blocks CRM 7.0

Good readings and good luck!

Database views are very useful to gather information from various related tables. Especially when programming….

SAP CRM provides some database views in a way that can be easy to collect massive data about documents.

One example: if you want to get information about partners from a document, you can use database view CRMV_LINKPARTNER.

Another example: if you want to get information about organizational data from a document (header level), you can use database view CRMV_LINKORGMAN.

Check for database views with prefix CRMV_LINK*, for more combinations.

If you need to create activities via ABAP, the BAPI named ‘BAPI_ACTIVITYCRM_CREATEMULTI’ is the one you need.

Since parameters filling are not very intuitive for starters, report CRM_CALL_ACTIVITY_INTERFACE was designed to help you using this bapi, with a little help of our debug friend.

You are coding at SAP CRM. You want to get the R/3 RFC to do something integrated with R/3 system.

How?

DATA ls_erpsite             TYPE smof_erpsh.

*- Get R/3 RFC (ls_erpsite-rfcdest)
CALL FUNCTION ’SMOF_READ_SMOFERPSH’
EXPORTING
i_sitetypeid = ’SMOF_ERPSITE’
IMPORTING
e_smof_erpsh = ls_erpsite.
CHECK ls_erpsite IS NOT INITIAL.

*- Ping R/3 using obtained RFC to confirm communication
CALL FUNCTION ’RFC_PING’
DESTINATION ls_erpsite-rfcdest
EXCEPTIONS
system_failure        = 1
communication_failure = 2.
CHECK sy-subrc = 0.

If you like to experiment yourself some SAP CRM processes, just download some tutor files at following path:

- Enter http://service.sap.com/bestpractices
- Enter navigation entry ‘SAP Business All-in-One’
- Then ‘Demonstrate and Experince’
- Then ‘Interactive Tutorials’
- Then ‘Customer Relationship Management’

You’ll need SAP Tutor to play these files. You can download it at:
https://service.sap.com/~sapidp/011000358700001572552002E

PS.: You’ll need an SAP service marketplace user for that