on 10-07-2015 1:27 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.