Showing results for 
Search instead for 
Did you mean: 

Extraction of WBS Structure(KJH3) into BW with Delta

Former Member
0 Kudos

Hello All,

I have a requirement to extract a structure of WBS from ECC into BW.  In BW, there will be authorizations setup on this hierarchy. These authorizations will use the technical node IDs as reference.(lets say untill level 4 out 7 of the hierarchy).

Therefore, with any change made to the structure in ECC (adding new nodes ) until level 4 , upon extraction in SAP BW, the technical reference of ALL nodes in the hierarchy will get updated.

What I would like to achieve is a only a delta transfer of the hierarchy after the initial load. So that there the entire hierarchy does not get refreshed each time.

How do I achieve this? Is this possible?

Please advise.



Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Abhishek,

U can use tcode BW07, to define datasource on sets.. This is the only way u can sets data from R/3 to BI/BW.

Below doc explains how to extract hierarchy data in sets.

If you want to extract WBS Element hierarchies then you can follow below steps.

1. Go to the datasource tab and replicate the datasource 0WBS_ELEMT_WBSH_HIER

2. from the business content tab go to the transfer rules and install 0WBS_ELEMT_WBSH_HIER.

3. Create an infopackage for the same, there will be hirarchy selection tab, check the WBSH.

4. Start loading the data from the infopackage.