Skip to Content
0
Former Member
Dec 04, 2008 at 06:56 PM

Extract Hierachy through Append Structure Customer Exit

40 Views

Hello.

I have a very specific requirement and I'm not sure how to proceed. We have a Customer hierachy define in our system which is then used in BI. Whenever my Customer (0CUSTOMER_ATTR) Datasource is extracted from ECC to BI, I'd like to set an attribute of my 0CUSTOMER equals to a Parent Node value from my Customer hierarchy based on my Customer #.

As an example, here's what my hierarchy looks like:

~ROOT
    80001001 WALMART
        00006505  WALMART STORE #1
        00006749  WALMART SOUTH-WEST
        00004284  WALMART RIVERSIDE
    80001002 COSTCO
        00001848  COSTCO NORTH
        00002189  COSTCO PRICELESS
    80001003 TOYS'R'US
        ...
        ...

So, basically, I have an attribute of 0CUSTOMER that I'd like to be equals to 80001001, 80001002 or 80001003 based on the customer # I'm processing.

I know I can get some information out of SETLEAF, SETNODE and SETHEADER tables on ECC; I had a look at theses tables but can't find anythings that looks like my existing customer hierachy.

Any help would be appreciated. Thanks!

John.