Skip to main content

SAP CRM: Marketing Segmentation/Target Group Management

Submitted by Stefan Barsuhn on

Quick note to self - SAP provides the following reports to manage segmentation and target groups:

  • CRM_MKTTG_SEE_SEG MODEL to see model details (i.e. if you have model GUID, see target group GUIDs)
  • CRM_MKTTG_GENERATE_SEG_MODEL - this is the report that is scheduled when users generate a target group via WebUI. Debug job to get target group GUID.
    • Table CRMD_MKTTG_TG_H contains target group header
    • Table CRMD_MKTTG_TG_I contains BPs assigned to target group
  • CRM_MKTTG_PURGE_TG_I to delete target group items (can be used as blueprint to create own deletion report, b/c you can also delete "active" target groups. They'll just be empty, so you can regenerate if required. (Reason is to reduce size of CRMD_MKTTG_TG_I, so performance of target group generation is improved.)

Also, the counting of segments happens in CRM_MKTTG_PF_COUNT (in general, the CRM_MKTTG_PF_* FM are interesting to look at).

When using BW, the actual call to BW happens in function module CRM_MKTTG_PF_BW_SELECTION. Here, the conversion from BP ID to GUID takes place. Note, though, that the system will convert ID to GUID by default (no matter what you're setting in the data source). To disable conversion, you have to maintain function module CRM_MKTTG_PF_CONV_GUID_TO_GUID in the data source configuration. This FM is not actually called, if the system recognizes it, it will simply pass the GUIDs to the output without conversion.