Technical name: 0CRM_TGGRP
Type of DataSource |
Transaction data (movement data) |
---|---|
Application component |
|
Available from OLTP release |
SAP CRM 4.0 SP03 |
RemoteCube Compatibility |
Not relevant |
You want to use a Top-n scenario, in which the selection of the target groups is to be performed via the BW system and not via the Segment Builder in the CRM-System.
This DataSource is needed to extract the target group data during synchronization of the target groups with the BW from the CRM system. Extraction is only possible for target groups with category
Product proposal
. Also, the indicator
Synchronization with BW
must be set for the target group attributes. If this indicator is set, then an initial transfer of the business partner list to the BW is performed when the target group is saved. As long as this indicator is set, a delta package is created for the BW every time the business partner list is changed. This package contains deletion records for business partners that are deleted when the list is changed. It also contains additional records for newly added business partners (after images).
If the
Synchronization with BW
indicator is removed, then the target group should also be deleted from the ODS object in BW. Furthermore, for all business partners in the list, a deletion record in a delta package is transferred to the BW system. This deletes all records from the target group list, which then causes the entire target group to be deleted from the target group ODS.
The delta mechanism is triggered by the application to set up the delta packages independently and place them in the BW delta queue.
Extraction is performed using BW adapter. This creates after images and possibly deletion records.
Field in Extract Structure |
Description of Field in the Extract Structure |
Table of Origin |
Field in Table of Origin |
---|---|---|---|
TG_GUID |
CRM Marketing: identification of a target group |
CRMD_MKTTG_TG_I |
TG_GUID |
BP_GUID |
GUID for business partner |
CRMD_MKTTG_TG_I |
BP_GUID |
BP_ORG |
CRM Marketing: origin indicator for a business partner |
CRMD_MKTTG_TG_I |
BP_ORG |
BP_DEL |
CRM Marketing: deletion indicator for a business partner |
CRMD_MKTTG_TG_I |
BP_DEL |
BP_NUMBER |
Business partner number |
BUT000 |
PARTNER |
RECORDMODE |
BW delta procedure: update mode |
DomainsRODMUPDMOD |