cancel
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.

regards,

Abhi

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member213275
Contributor
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.

http://scn.sap.com/docs/DOC-11387

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.

Srikanth.