Part 4: Extraction from CRM with ABAP program
Preliminary note: This article refers to release 1709 of Hybris Marketing (on premise).
Getting Permissions from CRM Using ABAP Program CUAN_MP_CRM_EXTR_INITIAL
In case you already have marketing permissions in your SAP CRM system and want to get them into a Hybris Marketing System, you can use the ABAP report CUAN_MP_CRM_EXTR_INITIAL (in Package CUAN_CONTACT_ENGAGEMENT). The program can be used either to extract initial permission data out of CRM, or to perform an update in case there is new data in the CRM system which has not yet been transferred to Hybris Marketing. However, the use for delta extraction is not recommended in terms of performance, because unchanged data will be checked as well.
As a precondition for the extraction, you must perform an SLT replication of the CRM data, depending on your individual deployment scenario. Check the Installation and Configuration Guide 1709 for details:
Follow the link, click on the PDF symbol, and then on the “PDF” button.
Chapter 3 of this document describes the different deployment scenarios, chapter 6 explains the Data Replication.
The data replication is necessary, because the report needs data from two database tables:
1.) CA_MKTPERM_EXTR_CRM_BUPA_PERM: CRM Business Partners
2.) CA_MKTPERM_EXTR_CRM_MP_PERM: CRM Marketing Prospects
In addition – to make sure that the mapping works as shown here – implement the following notes: Note No. 2496644 for permissions with origin ‘TEL’, and Note No. 2505985 for channel ‘SMS’.
After performing the data replication from CRM to Hybris Marketing, the report can be used. It runs in the accustomed way (from transaction SE38 or SE80) without further parameters. Just execute it, and view the results. The resume will tell you, how many permissions were found in the CRM, and whether the extraction was successful or not.
In the report, the following mappings take place:
a) Permission code ‘001’ is mapped to ‘Y’ for “yes”, ‘002’ to ‘N’ for “no”
b) CRM channels are mapped to Outbound Communication Media in Hybris Marketing.
In detail:
c) CRM origin is mapped to Communication Medium in Hybris Marketing
In detail:
However, be careful when renaming channels or origins in CRM: This will cause problems, because the mapping won’t work as outlined above.
If you want to learn more about uploading permissions and subscriptions into the Hybris Marketing system, read the other parts of this blog.
Part 4: Extraction from CRM with ABAP program
