Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

BW Customer hierarchy datasource

Former Member
0 Likes
862

Hello

I have created a customer master hierarchical data source in R/3. When I extract data data is R/3 it is extracting correct number of records. But when creating info object in BW is is giving error Data Source does not exist in source system

Any help would be appericiated

Thanks

Aarti

Hello

I have created a customer master hierarchical data source in R/3. When I extract data data is R/3 it is extracting correct number of records. But when creating info object in BW is is giving error Data Source does not exist in source system

Any help would be appericiated

Thanks

Aarti

2 REPLIES 2
Read only

Former Member
0 Likes
483

hi Aarthi,

try this,

1. Create an infoobject

2. Create a hierarchy for this infoobject.

3. Assign source sysyem to this infoobject.

4. When you assign datasource, sysyem will prompt you

three selection, master, hierarchy and text.

5. Once you have selected hierarchy, choose transfer

method IDoc, at the below there is a tab named 'hier.

structure', click on it and create a hierarchy that

you have created previously.

6. Automatically, system generates a structure

hierarchy format for you to upload.

7. create infopackage.

8. go to the master table for the infoobject, at tab

'hierarchy', double click on the hierarchy table,

download it into txt file, then modify from the text

file, delete those unnecessary column according to you

hierarchy format, save it as .csv

9. upload it as normal flat file.

Read only

0 Likes
483

Hello,

Thank you for the response. However I have not created the DS through RSO2. I have written a program to create data source(populating all ROO tables) it has wrapper FM.

Data source is fine. I can extract data in ECC. We are having issue while creating info package it is giving following error

"There are no hierarchies for this Infosource in the source system"

Please let me know if you need more information.

Appreciate your response!!

Thanks

Aarti