Hierarchy Loading from R/3 to BW

[Former Member]

Hi Gurus,

How to load Hierarchy from R/3 to BW

can somebody help with step by step procedure

as well as some scenarios where and how exactly this heirarchy does work in reports.

thanks and regards

neelkamal

[Former Member · Accepted solution]

Hi,

You need to find out wich hierarcy you need to load from r/3 to bw. Frex: t.code: gs03 is ued to set hierarchy.

In the bw side you have to options to load data into be

1) Flexible update 2)Direct update

you need to select direct update and load to data respective data targets.

This may help you.

Thanks,

V.V.Reddy

[Former Member · Accepted solution]

Hi

Actually i want to load 0Consumer_hier from R/3 to BW..

are you talking about the infoobjects in 0consumer hierarchy...

becoz i could see some infoobjects in the infosource but when i opened the 0consumer -maintain heirarchies i could not find any of them in BW side...does this mean i need to assign the concerned infoobjects which i want them in the heirarchy to be assigned in maintain heirarchy>>>>Create hierarchy. procedure

when i created the infopackage i could only find only one in heirarchy selection tab-- that is Customer Class

thanks

neelkamal

[edwin_harpino · Accepted solution]

hi Neelkamal,

try following steps,

- in r/3 side, rsa5, transfer datasource 0CONSUMER_LKLS_HIER under application component sd io

- replicate from bw, application component sd io, you will then see the datasource

- rsa1->infosource->search 0consumer, and 'assign datasource', choose source system r/3, you will get a list of 0CONSUMER_LKLS_HIER, etc... mark the datasource, and activate transfer rules.

- create infopackage, you will have option this hierarchy

hope this helps.

[Former Member · Accepted solution]

Hi A.H.P.

Yes i followed exactly the steps u mentioned and i created a infopackage and i selected hierarchy selections tab but still i could only find customer class option only so what should i do next.

thanks'

neelkamal

[edwin_harpino · Accepted solution]

hi Neelkamal,

i have the option here and can extract some data,

maybe hierarchy not exist in r/3 ? i never deal with hierarchy in r/3 side, ask r/3 guys for help ?

[Former Member · Accepted solution]

Hi A.H.P

You are absolutely right their is some problem on R/3 side, so i notified them , thanks once again for your time.

thanks and regards

neelkamal

[edwin_harpino]

hi Neelkamal,

take a look

http://help.sap.com/saphelp_nw04/helpdata/en/0e/fd4e3c97f6bb3ee10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a6729e07211d2acb80000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/3d/320e3d89195c59e10000000a114084/frameset.htm

reporting

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a5543e09411d2acb90000e829fbfe/frameset.htm

[Former Member]

Hi Neelkamal,

Hope this helps

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a6729e07211d2acb80000e829fbfe/frameset.htm

Cheers

Anurag

[Former Member]

Hi,

like e.g. 0mat_sales, 0cust_sales.. if you create an infopack for loading hierarchies at infopacklevel you can see the available hierarchies for the infoobjects.

/manfred