Targetting based on customer hierarchy

38 Views

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.