cancel
Showing results for 
Search instead for 
Did you mean: 

BW hierarchie question - How can we load Zobject hierarchy with external characteristics from multiples infoobjects hierarchies

Former Member
0 Kudos

Hi All

This question refer to thread 3498400

http://scn.sap.com/thread/3498400

I have a similar scenario than 3498400 discussion and i need help to solve our issue

see details belows

Scenario

BW 7.4

Master data custom infoobject ref <ZTEST) defined with hierarchy using 2 external characteristics

0COSTCENTER ref <CC> and 0WBS_ELEMNT ref <WBS>

First we tested our <ZTEST> ZHIER hierarchy by creating/maintaining it manually directly in BW

Sample #1 hierarchy name is ZHIER

ROOT

          NODE1

               SUBNODE1

                                   CC1 (Costcenter leave 1)

                                   CC2 (Costcenter leave 2)

                                   WBS1 (WBS element leave 1)

          NODE2

                SUBNODE2

                                   CC3 (Costcenter leave 3)

                                   WBS2 (WBS element leave 2)

Its fine up to here. We got the result expected and have either <CC> or <WBS> values as leaves

ZHIER hierarchies also exist for <CC> and <WBS> infoobject in BW and they are loaded from ECC.

Business process is defined to have all hierarchies maintained in ECC and loaded to BW

Excluding the leaves value, each <CC> and <WBS> ZHIER have exactly the same technical name

and structure.

We have created 2 Infoobject hierarchy datasource transformation to feed <ZTEST> ZHIER from both

<CC> and <WBS> ZHIER and modify the IOBJNUM rule to assign appropriate value (ZTEST)

using a similar CASE statement as per as provided in the thread 3498400.

We create 2 DTPs for each flows, so when loading ZTEST ZHIER from <CC>, the IOBJNUM = 0COSTCENTER and when loading from

<WBS> the IOBJNUM = 0WBS_ELEMNT

In term of technical content each load produce correct content

BUT and heres why i need help

DTP1 is for <CC> to <ZTEST>

When we load DTP1 (full update), we got the following result in ZHIER for <ZTEST>

Sample #2 -

ROOT

          NODE1

               SUBNODE1

                                   CC1

                                   CC2

          NODE2

               SUBNODE2

                                   CC3

It is just perfect as per as the source <CC> ZHIER

then in our sequence in Process chain, the next step is to update <ZTEST> ZHIER from the second infoobject <WBS> ZHIER

using DTP2 (we use Update Tree method in DTP) in order to have NODEs and SUBNODES updated with WBS values.

The result is not good because the <ZTEST> ZHIER got completly erased and rebuilt with source Hierarchy

DTP2 is for <WBS> to <ZTEST>

Sample #3

ROOT

          NODE1

               SUBNODE1

                                   WBS1

          NODE2

               SUBNODE2

                                   WBS2

This match exactly source hierarchy but we lost what was previously loaded

We have tried to use Tree Insert method in DTP but it failed because NODES already exist in the hierarchie

Assuming BW is supporting multiple external characteristics hierarchy, we wonder how we can load <ZTEST> hierarchy

from <CC> and <WBS> infoobject and have an fully integrated hierarchy as show as in sample #1

We would like to avoid using as much ABAP as possible to build/merge both sourced hierarchie into <ZTEST>

Can any of you faced same issue or provide some guidance here

NOTE: we are also looking at doing a load from ECC using Grouping or SETs (T-code GS01 in ECC) and use t-code BW07 to create generic datasource from ECC but we have not completed our testing yet.

rgds

Marc

Accepted Solutions (1)

Accepted Solutions (1)

sander_vanwilligen
Active Contributor
0 Kudos

Hi Marc,

Thanks for creating a new discussion.

It is not an easy one. I have been thinking about it and I suggest to create a custom DataSource in the ECC Source System. Here you will have to merge the Cost Center and WBS Element hierarchy and hierarchy nodes.

Please refer to document where you can find an example of such a custom hierarchy extractor.

Best regards,

Sander

Former Member
0 Kudos

Hi Sander

thanks for your input, we will continue investigating on the ECC side with SETS and generic data source including the sample (link) you have provided in your reply.

we will also communicate with SAP in order to confirm the real usage of external characteristics hierarchy.

rgds

ML

Answers (0)