This how to guide explains the steps to enable the transfer of business partner information from CRM to the private contact folder of individual users in Groupware.
Goal
You want to synchronize selected CRM business partners to private contact folders of your groupware users. This functionality is needed especially when you have too many BP’s to use the synchronization to the public contact folder efficiently.
Prerequisites
Customizing Mobile Bridge
- Start Transaction SMW3FDCUST and check that the “Active” flag is selected for all BDoc types related to BUPA_MAIN. If the flag is not selected, select the flag to activate all the BDoc types related to BUPA_MAIN.
- In the IMG customizing view navigate to CRM -> CRM Middleware and Related Components -> Generating Industry-Specific Objects and Services -> Active data synchronization. Or directly start Transaction CMWC_SMW. Check the status of this entry. If the status is not active change it to active.
- With the activation of data synchronization you have to generate many new objects. You can check the status in Transaction GENSTATUS. If there are Objects to be generated press F9 to start the Generation job.
Groupware integration configuration activities
This is described in Detail at Groupware Integration Configuration Activities.
Create Sites for Groupware Adapter Customizing
In the First step we create a new site which is responsible for the mBDoc Groupware Customizing data.
- Start Transaction SMOEAC
- Choose Object Type “Site”
- Press F6 to create a new Object
- Enter “MS-ExchangeServer” for Name and Description and choose the Type “Groupware Adapter 01 (mBDoc)”
- Save this information and stay in Transaction SMOEAC
In the second step we create a new site which is responsible for the sBDoc Groupware Customizing data, which is needed for the initial Load and the Transfer of Employees to the CDB.
- Start Transaction SMOEAC
- Choose Object Type “Site”
- Press F6 to create a new Object
- Enter “sBDoc Groupware Customizing” for Name and Description and choose the Type “Groupware Adapter 02 (sBDoc)”
- Save this information but stay in Transaction SMOEAC
Configure mBDoc Subscriptions
Now we create and assign the Subscriptions for the Site “MS-ExchangeServer”
- In Transaction SMOEAC change the Object Type to “Subscription”
- If you have Subscriptions for the Publications “All Business Partners (MESG)” and “All Business Transactions (MESG)” please assign these to the Site “MS-ExchangeServer”
- In the next step create Subscriptions for the Publications “Groupware Adapter Customizing (MESG)”, “Groupware Adapter Metadata for all BDoc Types (MESG)”, “Groupware Object Master Category List (MESG)” and “Groupware Object Selection Filter Fields and Values (MESG)”
- The Subscription for the Publication “Groupware Adapter - Generic Messages (by object) (MESG)” is a little bit special because you have to specify a criteria value “GWA_APPLN_MSG”.
Configure sBDoc Subscriptions
Now we create a new Subscription for the Publication “E-Mail Information for Groupware”.
- Choose Object Type “Subscription”
- Press F6 to create a new Object
- The Subscription Wizard is started. Click “Continue” on the welcome screen
- Enter “E-Mail Information for Groupware” in the Subscription field and choose “E-Mail Information for Groupware” from the F4 Help of the Publication field. Click “Continue”.
- The chosen publication is only “simple intelligent” and you don’t have to enter any “Criteria Values” next click “Continue”.
- Assign now the Site “sBDoc Groupware Customizing” to this Subscription and click “Continue”.
- End the Wizard by clicking on “Complete”
Now we create a new Subscription for the Publication “Employee”.
- Choose Object Type “Subscription”
- Press F6 to create a new Object
- The Subscription Wizard is started. Click “Continue” on the welcome screen
- Enter “Employee” in the Subscription field and choose “Employee” from the F4 Help of the Publication field. Click “Continue”.
- The chosen publication is only “simple intelligent” and you don’t have to enter any “Criteria Values” so click “Continue”.
- Assign now the Site “sBDoc Groupware Customizing” to this Subscription and click “Continue”.
- End the Wizard by clicking on “Complete”
Initial Load of the Object BUPA_MAIN into the CDB
After the configuration of Subscriptions for our “sBDoc Groupware Customizing” we can now do the Initial load of Object “BUPA_MAIN” into the Consolidated Database (CDB). This will also transfer the Employees which we need in the next step to the CDB.
- Start Transaction R3AS
- Insert “BUPA_MAIN” in the Field “Load Object”
- Choose “CRM” as your Source and “CDB” as the destination
- Press F8 to execute
- Control the Load with Transaction SMQ1 and SMQ2
Create extract of Employees
- Start Transaction SMOEAC again
- Press Shift + F5 to create a new extract
- Click on “Insert Sites” and choose the Site “sBDoc Groupware Customizing”
- Expand the tree and then double click on “Employee”
- Check “Extract Replication Object”
- Click on “Start Extract”
- By clicking on “Start Extract” you get a message to leave the transaction
- When the extraction has finished you will find your Employees under the Object Type “Employee” in Transaction SMOEAC
Initial load of Mapbox and Groupware Connector
- Start Transaction R3AS
- Insert “GWA*” in the Field “Load Object”
- Choose “CRM” as your Source and “MS-ExchangeServer” as the destination
- Press F8 to execute
The Mapbox should be restarted after the initial load.
Create Site for the User
- Start Transaction SMOEAC
- Open Object type “Site”
- Click on new and enter Name, Description and Site type. The Site Type must be “Groupware Adapter 02 (sBDoc)”. Save the new site.
- Switch to the tab “Employee”
- Click on New and choose the Employee which should be assigned to this site
Test the content of table “MBMANDTSTORE“ with Key „GW_EMP_SITE_WRITE“ with Program Z_GW_SITEWRITE
It is important that the content of table “MBMANDTSTORE“ with Key „GW_EMP_SITE_WRITE“ is correct for the next steps. For this I’ve written this program:
*&---------------------------------------------------------------------*
*& Report Z_GW_SITEWRITE *
*& *
*&---------------------------------------------------------------------*
*&Test the content of table “MBMANDTSTORE“ with Key "GW_EMP_SITE_WRITE”*
*& *
*&---------------------------------------------------------------------*
REPORT z_gw_sitewrite LINE-SIZE 1023.
DATA: mbmandtstore TYPE TABLE OF mbmandtstore,
wa_mbmandtstore LIKE LINE OF mbmandtstore,
filename TYPE string,
content TYPE string_table,
wa_content LIKE LINE OF content.
filename = 'crm.xml'.
SELECT SINGLE * INTO wa_mbmandtstore FROM mbmandtstore
WHERE mbkey = 'GW_EMP_SITE_WRITE'.
wa_content = wa_mbmandtstore-mbdata.
APPEND wa_content TO content.
CALL METHOD cl_gui_frontend_services=>gui_download
EXPORTING
filename = filename
CHANGING
data_tab = content.
The program downloads the content of the Table into a XML file in your SAP Work Directory. Open this File in Internet Explorer. It should look like this example:
5E2E501048424240973FA92DDD1F33E7
Mail.User@mail-domain.test
Especially look at the Field MANDT. It must be filled! If you see here duplicate Entries, empty fields, wrong E-Mail addresses and missing MANDT entries then you have to delete the line via SE16.
Then go to transaction SMOEAC, click on Press Shift + F5 to create a new extract. Click on “Insert Sites” and choose the Site “sBDoc Groupware Customizing”. Expand the tree and then double click on “E-Mail Information for Groupware”. Click on “Complete”. Click on “Start Extract”. By clicking on “Start Extract” you get a message to leave the transaction. Start transaction SMQ2 to monitor the extraction. When the extraction has finished start again the program Z_GW_SITEWRITE and check the XML again.
Start the initial load with Transaction R3AS of the Objects GWA* from CRM to the MS-ExchangeServer.
Restart the Mapbox in Transaction SMICM -> Administration -> J2EE-Server -> send Hardshutdown -> with restart
Start the Mapbox via http://[Mapbox-Server-Hostname]:[Port]/mapboxlauncher/manage
Restart also the Groupware connector.
Now you can add new subscriptions to the Site.
Create Subscription for Sales Group + Sales Office
- The Filtering is done by the ID of Sales Group + Sales Office out of the organisation management
- Start Transaction PPOSA_CRM
- Open the Structure and navigate to the Sales Office and note the ID, e. g. “O 50000617”. The space between the O and the number is important. Also navigate to the Sales Group and note also this ID.
- Start Transaction SMOEAC
- Open Object type “Subscriptions”
- Click on new to open the Subscription Wizard, click Next
- Choose Publication “Customer & Prospects (by Sales Group + Sales Office)” and enter a Subscription Name matching the Criteria’s e. G. “Customer & Prospects (Sales Group 123 + Sales Office 1009)”, click Next
- Enter Sales Group + Sales Office ID in the appropriate fields, click Next
- Click assign, Choose Site which should be assigned to this Subscription, click Next
- Click Finish
Monitor the Replication
- Start Transaction SMOHQUEUE
- Prove that Queue Daemon is running if not start it
- The RFC Connections to the Client 000 and to your actual client must be maintained
- Look at the extract and realign Queues
- Start Transaction SMQ1 and SMQ2 to monitor the outbound and inbound qRFC Queue
Set performance parameters
Adjust the J2EE Engine Memory settings in [Installation-Drive]:\usr\sap\[INSTANCE-Name]\DVEBMGS00\j2ee\cluster\server\ cmdline.properties to:
-Xmx1024M -Xms1024M
Set the Blocksize of BUPA_MAIN via Transaction r3ac1 to 10
Set the Blocksize of GWA_COUNTRY via Transaction r3ac3 to 10
Table for test data
| Employee | BP No. | Sales Group. | Sales Group ID | E-Mail | User |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
