Skip to Content
Former Member
Feb 24, 2009 at 04:30 PM

Targetting based on customer hierarchy


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 :





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.