camapign replication
TRANSCRIPT
http://wiki.scn.sap.com/wiki/display/CRM/Campaign+Element+data+don%27t+flow+from+CRM+to+ECC
PurposeThe article show a general view of how to transfer data to ERP system, this scenario is only available from CRM 2007
OverviewThe transfer of project from CRM to ERP need correct customizing settings; these steps are described in this article.
Transfer to ERPThere are two mode of transfer
For the manual transfer an option 'Online' in the customizing for the ERP Integration Type. Should be checked
Transaction SPRO
CRM->Marketing -> Marketing Planning and Campaign Management-> System Landscape-> Define ERP Integration Type
For the manual transfer, the automatic transfer choose via middleware transfer
The Manual (online) transfer to EPR was removed starting CRM 5.2, we can only use the automatic transfer. You can use this also by leaving the integration type blank in the customization, in that case the project won’t be transferred.
To transfer a marketing element automatically from CRM to R3, the following settings need to be done;
1. You must register the following queues: In CRM: CSAMKTP* CRM_MKTPL* In R/3: CRM_MKTPL* R3AD*
2. The masks have to be respected; the name of the newly created WBS element in R3 has to match the mask specifications.
3. On the 'Details' view of the marketing project the flag 'No ERP Transfer' should NOT be checked.
4. The fields transferred from the CRM marketing element/project to the R3 WBS element are: identification, description, plan start date, plan end date, actual start date, actual end date.
5. In customizing Customer Relationship Management -> Marketing -> Marketing Planning and Campaign Management -> System Landscape ->Define RFC Connection: The connection to the R3 system should be defined.
6. Define Target System (R/3, BW, SEM): the RFC destination should be maintained for the identification MKTPLR3.
7. In ADMIN Console (Tx. SMOEAC) Object Type: SITE, click on glasses, open the R/3 branch, choose one for the planner, double click on thesite name click on site attributes and there define RFC destination
8. Define R/3 Integration Type: the type should be 'Middleware'.9. Define R/3 Project Profile for RFC Destination: the project profile from R3
(Project System -> Structures -> Operative Structures -> Work Breakdown Structure (WBS) -> Create Project Profile) should be assigned next to the name of the R3 destination system.
10. Assign Project Scenarios to Logical System: the project scenario from R3 (Project System -> Project Replication-> Define Project Scenario) should be assigned next to the RFC destination.
====
Hi Rizwan,
the marketing project is transfered to R/3 and is visible as a project in R/3 Project system.
It is visible in Tcode CJ20N in ECC( R/3)
To be able to transfer marketing project to ECC ,you have to work in accordance with a PS consulatnt.He will create and give you a project scenario and formatting mask that you will assign in CRM customizing settings
in ECC PS you have to carry out the foll settings:
1. Define project scenario
2. Define formatting mask
the foll: settings need to be carried out in CRM
1. Marketing>System Landscape->Define ERP Integration Type
2.Marketing>System Landscape-->Assign ERP Project Scenario to RFC Destination ( created above)
3. Marketing>System Landscape-->Define Formatting Mask for Marketing Projects ( created above)
Now when you create a marketing project and change the status of the project to Released,it will get transferred to ECC PS.
==
Finally, I was able to resolve the ECC integration issue.
Standard SAP delivered project mask "M" format in ECC is not same as CRM marketing plan id. I have modified the ECC prject mask format by deleting the standard entry and add ing "M" project id with CRM format (for example: M-00000000).
http://help.sap.com/saphelp_crm700_ehp01/helpdata/en/46/03835dcfc604a9e10000000a114a6b/frameset.htm
http://scn.sap.com/people/vinay.prasad2/blog/2011/10/21/sap-crm-campaign-management-sap-crm-ecc-middleware-integration
SAP CRM Campaign Management – SAP CRM & ECC Middleware integrationPosted by Vinay Prasad in vinay.prasad2 on Oct 21, 2011 12:45:09 PM inShare1
SAP Campaign Management covers the complete process for running a campaign starting with market analysis, continuing with execution of the campaign, and ending with the closure of the campaign and analysis of the results. The process completes by assigning direct marketing expenses to accounting objects as well as detailed postings in
the ECC system.
Well the more information about the SAP CRM Campaign management process itself is available at help.sap.com, this blog deals with the integration of SAP CRM Campaign Management with SAP ECC system through CRM Middleware.
Basic CRM middleware settings like establishing RFC connections to SAP CRM & SAP ECC should be already be taken care. The below steps only deals with the system configuration on top of the basic CRM middleware set up.
Following are the steps that are needed to configure Campaign management data flow between CRM and ECC.
1. Define ECC integration type
2. Define Target Systems
3. Assign ERP Project Scenario to RFC destination
4. Set up the Publication/Subscription for Message type ‘Campaigns’ in Middleware Administration console (Tx. SMOEAC) for Campaign replication.
5. Set up the Publication/Subscription for Message type ‘Targetgroups’ in Middleware Administration console (Tx. SMOEAC) for Target group replication.
6. Check underlying tables in CRM and ECC for replication of Campaign and Target groups.
1. Define ECC integration type
In this activity, you specify whether the campaign integration is through CRM Middleware.
SPRO -> SAP CRM -> Marketing -> Marketing Planning & Campaign Management -> System Landscape -> Define ERP Integration Type
2. Define Target Systems
In this step you define the connection of the CRM system to ECC system. For ECC system we need to enable the parameter type MKTPLR3RFC
SPRO -> SAP CRM -> Marketing -> Marketing Planning & Campaign Management -> System Landscape -> Define Target Systems (ERP, BI, SEM, cPro)
3. Assign ERP Project Scenario to RFC destination
In this activity, you specify the default Project scenario (WBS element) from the ECC Project System (PS) for transfer of campaign elements to ECC for posting the cost.
SAP CRM -> Marketing -> Marketing Planning & Campaign Management -> System Landscape -> Assign ERP Project Scenario to RFC destination
If you assigned more than Project scenario (WBS element), then system needs to know which system receives each marketing project. This can be controlled through Badi CRM_MKTPL_R3_INT.
4. Set up the Publication/Subscription for Message type ‘Campaigns’ in Middleware Administration console (Tx. SMOEAC) for Campaign replication.
Adapter object for Campaign:
Subscription for Campaign:
5. Set up the Publication/Subscription for Message type ‘Targetgroups’ in Middleware Administration console (Tx. SMOEAC) for Target group replication.
Adapter object for Target groups:
Subscription for Target groups.
6. Check underlying tables in CRM and ECC for replication of Campaign and Target groups.
Once the campaign is released, verify for an entry for campaign in ECC table CMPB_MAP with should match an entry in CRM table CGPL_PROJECT for a campaign.
CRM : table CGPL_PROJECT
ECC : table CMPB_MAP
Target group is stored in table by the name CRMD_MKTTG_TG_H both in CRM and ECC, although structure of the table is different.
CRM : table CRMD_MKTTG_TG_H
ECC : table CRMD_MKTTG_TG_H
