Table for Intersected Target Groups

[Former Member]

Hi,

when intersecting two target groups one new target group is getting created. I am looking for the table that stores which target groups 1 and 2 were used to get the new target group 3.

Any help is highly appreciated.

Nicole Lange

[klaus_brengel]

Hi Nicole,

you will need the GUID of TG 3. Let's call it GUID3.

 
DATA model_tg_3 TYPE crmd_mkttg_model.
SELECT SINGLE * FROM crmd_mkttg_model
  INTO model_tg_3  
  WHERE object_guid = guid3 
    AND reference   = space.

yields the position of TG 3 in the model.

  DATA edges_to_parent TYPE crmt_mkttg_step_db.
  SELECT * FROM crmd_mkttg_step 
    INTO TABLE edges_to_parent
    WHERE to_node = model_tg_3-node
      AND to_step = model_tg_3-step.

yields the edges leading to the parents. Now you will have to read the parent nodes again from the node table:

  DATA parent_guids TYPE crmt_mkttg_guid_tab.
  IF edges_to_parent IS NOT INITIAL.
    SELECT object guid FROM crmd_mkttg_model
      INTO TABLE parent_guids
      FOR ALL ENTRIES IN edges_to_parent
      WHERE node = edges_to_parent-from_node
        AND step = edges_to_parent-from_step.
  ENDIF.

Now parent_guids should contain the GUIDs of TG1 and TG2 (at least in theory - haven't tested it, but that's the way you do it normally).

Hope that helps!

--klaus

[Former Member]

Hi Klaus,

so are you saying that there is not a single table to get the information from? The example you gave, what is it? Is it a function module?

Thanks

Nicole

[klaus_brengel]

Hi Nicole,

so are you saying that there is not a single table to get the information from? 

yes.

The example you gave, what is it? Is it a function module?

Nope. Just code that I wrote down here in the thread. I doubt that the code exists in the system at the moment.

hope that helps

--klaus

[AnupDDesai]

Hi Nicole Lange,

Generally the TG's are updated in tables CRMD_MKTTG_TG_H (for Target group header data) and

CRMD_MKTTG_TG_I (for Target group items).

Hope this helps.

Regards,

Anup

[Former Member]

Hi Anup,

thanks for your answer. I am aware of these tables. They store the general information for target groups. I am looking for a table that shows me the intersected target groups and which target groups I used to build them.

Thanks

Nicole