Targetting based on customer hierarchy

[Former Member]

Hi experts,

The customer hierarchy of our client is modelised in SAP CRM as follow :

Customer 1

-

---

>Customer 1.1

-

---

>Customer 1.1.1

-

---

>Customer 1.2

-

---

>Customer 1.2.1

-

---

>Customer 1.2.2

I create an infoset in SAP CRM (via SQ02) with tables :

BUT_HIER_NODE

BUT_HIER_STRUCT

CRMM_BUT_BUHI_1

BUT000

In the Segment Builder, I make a filter on Hierarchy Node ID.

For example, I make filter on the Hierarchy Node ID of the Customer 1, as result, I get Customer 1.1 and Customer 1.2

But I want that, when I enter the Hierarchy Node ID of Customer 1, I get all customer uner him : Customer 1.1, Customer 1.1.1, Customer 1.2, Customer 1.2.1 and Customer 1.2.2 (all the levels under Customer 1).

Should I modify my infoset ? If yes what changes could I make ? Else, should I use a BW query that gives all customers linked to Customer 1 ?

Thank you in advance for your help.

Regards.

[anik_roy]

FYI - I'm moving this message to the CRM - General & Framework Forum where technical questions such as these are more likely to get answered/searched.

The new Marketing forum is intended for marketing process-related queries.

Warm Regards,

Anik Roy

Moderator