Show TOC

  DataSource for Synchronization of Target Groups in the BW

Technical name: 0CRM_TGGRP

Technical Data

Type of DataSource

Transaction data (movement data)

Application component

CRM-MKTCA

Available from OLTP release

SAP CRM 4.0 SP03

RemoteCube Compatibility

Not relevant

Prerequisites

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.

Use

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.

Delta Update

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.

Fields of Origin in the Extract Structure

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